Home |
Search |
Today's Posts |
#1
|
|||
|
|||
floating cells
How do you make the tiles of you cells float when you scroll so that you can
still see them. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
Place your cell pointer where you want the page to scroll and click on
Windows then Freeze Panes. HTH |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Counting only active cells | Excel Discussion (Misc queries) | |||
Locate and delete specific cells | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |