Saturday, June 23, 2012

How To Freeze All Top Cells In Excel 2003


1. Open your Excel spreadsheet. You can open a spreadsheet by double-clicking the XLS file on your computer, or you can open in the 'Open' dialog box when you click the 'Open' icon at the top of your window.
2. Click the row letter on the left of the spreadsheet to highlight the row you want to freeze. To highlight more than one row, hold the 'Ctrl' key and click each row letter with your mouse.
3. Click the 'Window' menu item. Click 'Freeze Panes' to freeze the rows. Scroll down the spreadsheet. Notice the rows you froze are always displayed at the top of your workspace.

Blogger news