If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Freeze the side column/top row & scroll others
what is the function to set (lock in or freeze) the first column and / or top
row of a spreadsheet, so the words and numbers remain in the same place as you scroll the other columns and rows. (so you can add more columns..yet keep the main information in the first column/row) |
#2
|
|||
|
|||
Freeze the side column/top row & scroll others
Freeze Panes.....
In older versions of Excel, it is under Window. In 2007 version of Excel, it is under View. You first select a cell, then activate the command. Excel uses the selected cell's upper left corner to define the freeze point. Play with it. You can also Unfreeze panes that were frozen before. Dennis "goadk123" wrote in message ... what is the function to set (lock in or freeze) the first column and / or top row of a spreadsheet, so the words and numbers remain in the same place as you scroll the other columns and rows. (so you can add more columns..yet keep the main information in the first column/row) |
#3
|
|||
|
|||
Freeze the side column/top row & scroll others
Select B2 Window Freeze Panes
"goadk123" wrote: what is the function to set (lock in or freeze) the first column and / or top row of a spreadsheet, so the words and numbers remain in the same place as you scroll the other columns and rows. (so you can add more columns..yet keep the main information in the first column/row) |
Thread Tools | |
Display Modes | |
|
|