I have a spreadsheet with many rows in it, but I want to do an option that when I scroll down the first two rows (the heading) do not disappear and kind of travel down when I scroll down. Any ideas how to do it?? Thanks a lot in advance.
2006-12-07 07:08:56 · 6 answers · asked by D. V 2 in Computers & Internet ➔ Software
The answers above are right-on, but below are more detailed, step-by-step directions in case you are unfamiliar with some of the instructions the others have given:
1. Select the entire third row of your spreadsheet by clicking on the "3" to the far left of the row.
2. Click on "Window" from the main menu bar at the top of the Excel window.
3. Scroll down and select "Freeze Panes" from the menu that appears.
(Note that depending on your Excel option settings, and if you have not recently used the "Freeze Panes" option, you may have to clink on down-ward pointing arrows at the bottom of the "Windows" menu in order to make the "Freeze Panes" option appear.)
You can turn this off by selecting "Window" and then "Unfreeze Panes" at any time.
The above works for maintaining just the column headers in a spreadsheet, but the same can be accomplished for row labels, also.
For example, click in cell B3 and select "Window", "Freeze Panes". You can now scroll up and down (with rows 1 and 2 visible) AND left and right, keeping column A visible.
This is a very handy feature.
2006-12-07 07:32:33 · answer #1 · answered by Kenneth G 2 · 0⤊ 0⤋
Put cursor at the bottom of the information you wish to not move
Click on Window
Click on Freeze Panes
2006-12-07 07:48:29 · answer #2 · answered by J89434 2 · 0⤊ 0⤋
Place the cursor on the third row then click on window then click freeze panes, to reverse do the same and unfreeze panes.
2006-12-07 07:15:29 · answer #3 · answered by MC 2 · 1⤊ 0⤋
Hightlight where you want to put your header and click the Merge and Center button located on the far right side of the screen. This should take care of your problem.
John
A+ Certified
2006-12-07 07:12:26 · answer #4 · answered by A+ Certified Professional 5 · 0⤊ 1⤋
put your curser on the box below your heading. then click on Window, then Freeze Pane. that will make your heading stay at the top.
2006-12-07 07:14:53 · answer #5 · answered by Magick Kitty 7 · 1⤊ 0⤋
In E1 enter =MIN(A:A) reproduction for the duration of to G1 In H1 enter =decide for(tournament(MIN(A:C), E1:G1,0),"A","B","C") that's your column designation/style (first occasion in straightforward terms, does not coach any duplicates)
2016-10-14 05:29:50 · answer #6 · answered by corbo 4 · 0⤊ 0⤋