| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Table headers to remain on top
Hello,
I have a table with headers in the first two rows. How can I scroll through my table and "lock" the first two rows remain on top? Thanks, Ellen |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Table headers to remain on top
Click/select cell A3 and then use Window | Freeze from the menu toolbar.
"EllenM" wrote: Hello, I have a table with headers in the first two rows. How can I scroll through my table and "lock" the first two rows remain on top? Thanks, Ellen |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Table headers to remain on top
hi
place your curser at cell A3. on the menu bar.... WindowFreeze panes. regards FSt1 "EllenM" wrote: Hello, I have a table with headers in the first two rows. How can I scroll through my table and "lock" the first two rows remain on top? Thanks, Ellen |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Table headers to remain on top
Hi Ellen,
Select row 3. WindowFreeze Panes -- Kind regards, Niek Otten Microsoft MVP - Excel "EllenM" wrote in message ... | Hello, | I have a table with headers in the first two rows. How can I scroll through | my table and "lock" the first two rows remain on top? | | Thanks, | Ellen |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Table headers to remain on top
Thanks!!! So easy when you know how to do it.
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem formatting pivot table headers | Excel Worksheet Functions | |||
| How do I get word wrap format to remain in an Excel pivot table? | Excel Discussion (Misc queries) | |||
| Pivot table: how to programmatically format headers? | Excel Discussion (Misc queries) | |||
| ? Pivot Table from 3 columns of raw data with headers | Excel Discussion (Misc queries) | |||
| NEED A PART OF THE TABLE TO REMAIN IN THE SCREEN, HOW?? | Excel Discussion (Misc queries) | |||
Linear Mode
