If you work with spreadsheets with large size, so that the top row or leftmost column (which usually contains a description, number, date, name, number, etc.) are always visible when we are at a distant cell (due to the limited display screen computer monitor ), then we should lock these initial columns and rows so that is always visible. We use the Freeze Panes.
• Open your Excel Spreadsheet Documents
• Highlight / Tues store just below the second row and second column, (assuming the first row and first column to be locked)
• Click the View Tab
• Click the Freeze Panes
• Click the Freeze Panes, then the row and first column will be locked, to see results try sliding into cells that far down or right side.
To restore to its original state (without freeze panes)
• Click the View Tab
• Click the Freeze Panes
• Click unfreeze Panes
Post a Comment for "Freeze Panes in MS Excel 2007 (lock the leftmost column or top row)"