How To Freeze Spreadsheet In Excel 2010
How To Freeze Spreadsheet In Excel 2010. Select view on the ribbon. To freeze the top row, open your excel spreadsheet.
To freeze multiple columns, you need to select the columns to the right that you wish to lock. Scroll to the right of the worksheet. To freeze the top row, open your excel spreadsheet.
To Freeze The Top Row, Open Your Excel Spreadsheet.
Select the view tab from the toolbar at the top of the screen and click on. To freeze multiple columns, you need to select the columns to the right that you wish to lock. First, select the column behind those we want to freeze.
This Is Because The First Four Columns Are To Be Frozen.
On the view tab, in the window group, click freeze panes. Freeze multiple columns in excel. From the window group click the freeze panes button and select the freeze panes command.
Then, We Need To Choose The “Freeze Panes” Command On The “View” Tab.
If you're using excel for mac, skip this. So let’s have a look at those procedures to freeze multiple columns in excel. For excel 2007/2010, click the view tab.
Highlight At Least Two Rows From The Worksheet.
In order to make the first column and row label apparent while scrolling, you need to follow very simple steps. Go to view tab > freeze panes > freeze top row. Then select the view tab from the toolbar at the top of the screen and click on the freeze.
So We Will Select Column D.
Select view on the ribbon. Follow these three steps to get your worksheet's header to stay in place. In this video, you’ll learn more about freezing panes in excel 2010.
