How do you make the tiles of you cells float when you scroll so that you can
still see them.
How do you make the tiles of you cells float when you scroll so that you can
still see them.
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 Window>Freeze Panes.
HTH
Bruce
Bruce
The older I get, the better I used to be.
USA
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.
Thanks!
Dennis
I am using Windows 7 and Office 2007, all of my posts are based on this.
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" <[email protected]> wrote in message
news:[email protected]...
> 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks