floating cells
 

How do you make the tiles of you cells float when you scroll so that you can
still see them.

midnightdream, select the row under the one you want to stay put and window
freeze pane
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"midnightdream" wrote in message
...
How do you make the tiles of you cells float when you scroll so that you
can
still see them.

Place your cell pointer where you want the page to scroll and click on
Windows then Freeze Panes.

HTH

If you mean "Titles" of the columns (or rows) "freeze" so they don't
scroll off the screen, place the cell pointer in the row just below
your column Title row(s) and just to the right of the column of your
row title column(s) (If you only want to freeze the top row, put the
pointer in A2) and select WindowFreeze Panes.

HTH

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=383653

If you are refering to the header row on a table? If this is at the top
of your spreadsheet, the easy way is to use the freeze pane.

You can do this in two ways, I prefer the second.

First:
At the top of the vertical scroll bar on the right is a very small
button, right above the up arrow. Place you mouse pointer over this
area and it should turn to a double point. Click and drag down to
reveal the row with your titles (or however many rows want) These will
bow remain visible when you scroll down.

The same is true for the horizontal scrolling, the freeze pane tool is
to the right of the horizontal scroll bar on the bottom.

Second:
Customize your toolbar to include the Freeze Pane tool. Right click in
the toolbar area, and pick Customize from the context menu.

Click the Commands tab, and select Windows & Help from the choices. In
the right window (scroll may be necessary) click and drag the Freeze
Panes icon to your toolbar (I put mine next to the Zoom tool.)

Click on the Freeze Panes tool, and click in the cell immediately below
your title row (And immediately to the right of your row titles if you
have them) and a thin freeze pane line will appear and the items above
will remain when you scroll up & down - The items to the left will
remain when you scroll left & right.

This is a toggle tool, turn it off by clicking on the tool again.

Good luck.


--
DCSwearingen


------------------------------------------------------------------------
DCSwearingen's Profile: http://www.excelforum.com/member.php...o&userid=21506
View this thread: http://www.excelforum.com/showthread...hreadid=383653