Headings

H

Homer J

New Member
Joined
Sep 20, 2003
Messages
23
Hello,
How do I make the cells in the top row to be permanently positioned headings, so that they are still visible even when scrolling down the page? I've been trying with the 'insert name' stuff on the insert menu but not getting anywhere.
Thanks very much
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
Sort by date Sort by votes
Select the row below the row you want to remain on top when scrolling. Then go to windows (on the top menu bar with File, Edit etc) and select freeze panes. Your all set. You can also freeze columns in place too.
 
Upvote 0
Welcome to the board

Highlight the row below your data then select Window-->Freeze Pane
To print it on all pages, File-->PageSetup-->Rows to repete
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Question
Pivot Table report
Replies
0
Views
129
cccbzg
C
D
  • Question
Create empty table (with headings) in Word document after some text
Replies
5
Views
137
dwsteyl
D
L
  • Question
Insert WAV file in Col on next available row
Replies
0
Views
172
Ligg
L
A
  • Question
I'm trying to float a button at the bottom of an Excel table
Replies
1
Views
355
skillilea
S
F
  • Solved
Page Breaks and Subscript out of Range
Replies
1
Views
430
Farscape2020
F

Forum statistics

Threads
1,214,653
Messages
6,120,749
Members
448,989
Latest member
mariah3

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top