Wednesday, March 3, 2010

Excel 2007 - How to Freeze Multiple Columns and/or Rows

 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. 


  1. How to freeze multiple columns in excel 2007????

    1. hi friends,

      if 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.