Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to place a stable title row?
Hi there!
For a scientific analyse I need to create an Excel table with more than 1.000 rows content. Now, how can I create a title row that doesn't scroll with the rest of the content, so one that is always visible at the top, while you scroll up and down the rest of the content. I hope that's possible like this! Otherwise, it will be pretty difficult to enter the data into the correct (of about 15) column. Thanks for your help in advance! |
#2
|
|||
|
|||
One way:
Assuming headers are in row1, Select A2. Click Window Freeze pane This freezes the 1st row, so it always remains in view when you scroll down And if you want to keep the 1st col, e.g.: col A in view as well as you scroll right (assuming col A contains the row headers), try selecting say, B2 instead of A2, then click Window Freeze pane -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- " wrote in message ... Hi there! For a scientific analyse I need to create an Excel table with more than 1.000 rows content. Now, how can I create a title row that doesn't scroll with the rest of the content, so one that is always visible at the top, while you scroll up and down the rest of the content. I hope that's possible like this! Otherwise, it will be pretty difficult to enter the data into the correct (of about 15) column. Thanks for your help in advance! |
#3
|
|||
|
|||
Hi
Place your cursor in cell A2 then choose Window=Freeze Panes -- Regards Roger Govier " wrote in message ... Hi there! For a scientific analyse I need to create an Excel table with more than 1.000 rows content. Now, how can I create a title row that doesn't scroll with the rest of the content, so one that is always visible at the top, while you scroll up and down the rest of the content. I hope that's possible like this! Otherwise, it will be pretty difficult to enter the data into the correct (of about 15) column. Thanks for your help in advance! |
#4
|
|||
|
|||
Hi Max and Roger
Thanks a lot - it worked! :-) It's great to get such helpful information from you guys! Hope that I can return the favour one day! Best regards from Switzerland Thomas "Bubble" Schneider |
#5
|
|||
|
|||
Pleasure`, Thomas !
-- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- " wrote .... Hi Max and Roger Thanks a lot - it worked! :-) It's great to get such helpful information from you guys! Hope that I can return the favour one day! Best regards from Switzerland Thomas "Bubble" Schneider |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Relative Chart Title? | Charts and Charting in Excel | |||
Changing Graph Title W/ Pivot | Excel Discussion (Misc queries) | |||
Problem with Chart Title Formatting | Charts and Charting in Excel | |||
how to cell reference a Chart title | Charts and Charting in Excel | |||
The x-axis title is truncated in EXCEL charts 2003. | Charts and Charting in Excel |