To freeze multiple columns in an Excel spreadsheet, click on the column to the right of the column you wish to freeze and click through the following:
View > Freeze Panes > Freeze Panes
You can do this for rows, too.
If you want both rows and columns to freeze, then click the single cell you wish to start scrolling with, and go through the same menus above.
How to freeze multiple columns in excel 2007????
ReplyDeletehi friends,
Deleteif you want to freeze multiple rows in excel 2007, firstly you freeze top row and after that you insert the nos. of row, which you want.
nothing happens
ReplyDelete