Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,358
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10,593
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel: match two cells in one sheet to two cells in another and return a third cells value Spence Excel Worksheet Functions 3 February 13th 11 05:33 AM
Anchoring Cell Contents [email protected] Excel Discussion (Misc queries) 0 January 10th 07 05:45 PM
Anchoring shapes when printing in Excel 2007 DLF Excel Discussion (Misc queries) 2 January 2nd 07 05:14 PM
'anchoring' or 'grounding' part of a formula Dave Excel Discussion (Misc queries) 2 September 15th 06 07:48 PM
Anchoring Activex Controls KG Excel Discussion (Misc queries) 2 March 24th 05 07:51 PM


All times are GMT +1. The time now is 04:22 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"