9/22/2023 0 Comments How to freeze more than one columnTo remove the pane freeze, select Unfreeze Panes from the Freeze Panes menu. If we scroll across, these columns will remain in place. The worksheet will freeze columns A to C. In the Ribbon, select View > Freeze Panes > Freeze Panes. Position your cursor in the column you wish to freeze. You might want to freeze more than one column. In the Ribbon, select View > Freeze Panes.Īs you scroll across in your worksheet, you will see that the first column remains visible regardless of how far you scroll across. If we have a large worksheet with many columns going across the screen, we might want to make sure that we can always see the first column. This tutorial will demonstrate how to lock columns in Excel and Google Sheets.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |