Tuesday, September 11, 2012

How to Anchor Columns in a Spreadsheet

1. Open the Excel program and open the desired spreadsheet or enter data to create a new spreadsheet.
2. Select the column or columns that are to remain visible when scrolling. To select a column, click on the letter at the top of the column. The column will then be highlighted showing it has been selected.
3. After selecting a column when using Excel 2007, click on the view tab on the toolbar. Once the view tab is open, in the Windows group, click on the arrow that is located below the freeze panes. To anchor only one column, click on Freeze First Column. To anchor more than one row, click on Freeze Panes. To anchor columns in other versions of Excel, such as 2003, select the column and click on the Windows tab on the toolbar and click on Freeze Panes.
4. When the column or columns need to be unanchored, click Unfreeze Panes in the Window menu.

Blogger news