Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Anchoring Excel Cells
Is there a way to anchor cells so that as I scroll down the same two cells
will always be at the top of the screen. Would be useful when looking at a lot of data trying to match it up |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Anchoring Excel Cells
If the cells you want to anchor are at or very near the top, you can use
Freeze Panes (just go to the cell that is one row beneath and one column to the right of the cells you wish to anchor then go to menu Window--Freeze Panes. If, however, the cells you wish to see are somewhere in mid-worksheet, get the cells at or near the top of your view, click in a cell just below them, then go to menu Window--Split. This will give you a 2nd view of your same worksheet. -- John C "stockwsr" wrote: Is there a way to anchor cells so that as I scroll down the same two cells will always be at the top of the screen. Would be useful when looking at a lot of data trying to match it up |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Anchoring Excel Cells
Select the row below and the column to the right of the static rows and
columns, then WindowsFreeze Panes -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "stockwsr" wrote in message ... Is there a way to anchor cells so that as I scroll down the same two cells will always be at the top of the screen. Would be useful when looking at a lot of data trying to match it up |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
Anchoring Cell Contents | Excel Discussion (Misc queries) | |||
Anchoring shapes when printing in Excel 2007 | Excel Discussion (Misc queries) | |||
'anchoring' or 'grounding' part of a formula | Excel Discussion (Misc queries) | |||
Anchoring Activex Controls | Excel Discussion (Misc queries) |