Formatting Headers

K

kurting0

This is a simple problem but I cannot remember how to remedy it. I am
working in a large worksheet and want to keep the column headers on the
top of the page as I work my way down the page. Thanks.
 
M

Max

If col headers are in row1, row headers down col A

try:

Click on B2
Click Window > Freeze Panes

Col A will stay in view as you scroll across to the right
Row1 will stay in view as you scroll down

Adjust the "corner cell" B2 of the frozen panes accordingly to suit

To "re-freeze" panes at another corner cell,
unfreeze panes first via click Window > Unfreeze Panes
then select the new corner cell and click Window > Freeze Panes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Skipping the first row in a repeated header 0
Loop through pages and insert header image 0
Space at end of multi page list to accommodate new entries 1
Table of content - format does not get saved 2
Header Roman Numeral to Regular Numbers 1
How can the font and size of (all) citation numbers be altered? 1
Two columns followed by single page-width column on same page 0
Inserting shape to Header when table exists - anchor problem - Word VSTO 1

Top