Wednesday, December 11, 2013

How to Freeze Rows Columns


1. Place the cursor in the cell directly below the row you want to remain visible (freeze) and directly to the right of the column you want to remain visible (freeze). For example, if you want Row 1 and Columns A through C to remain visible (freeze), place the cursor in cell D2.
2. Click on the 'Window' menu.
3. Select 'Freeze Panes.'
4. Move the cursor through the spreadsheet and notice that Row 1 and Columns A through C are frozen. In other words, they always remain visible while the rest of the data move.
5. Click on the 'Window' menu and select 'Unfreeze Panes' to remove the frozen rows and columns.

Blogger news