Repeating headings

  • Thread starter Thread starter ace_stace
  • Start date Start date
A

ace_stace

Is it at all possible, to have a table with column headings/titles that
can be repeated on further pages if the table takes up more than one.
So that the headings will appear on the top of each page without having
to insert rows to copy and paste the headings in:)

would appreciate any help

even if it is just to confirm that there is no function that will do
this
 
Hi ace_stace

If you mean when printing then:

File>Page Setup, Sheet tab, input or select the "Rows to repeat at
top".

If you mean when viewing the worksheet then:

Activate the cell below and to the right of the cells you want fixed
and click Windows> Freeze Panes.

Regards

Steve
 
yes that makes sense

but the option to input specific cells or highlight they is greyed out
and i cant access it for some reason
 
Hi ace_stace

Sorry, I've not come across an instance where I can't input or select
the rows I want, perhaps someone else has...

Regards

Steve
 

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

Printing a Different Row Heading Mid-way through a Spreadsheet 1
Not receiving forum emails 14
Windows 10 One of my previous builds is experiencing random, multiple BSODs 9
Print Column Heads WITHOUT Excel Column Lables 1
Excel Returning Multiple Results (closest Match Not Exact) From A Table Using Multiple Criteria 1
row heading to show on all pages 1
Repeat rows on top - in worksheet - not printing! 2
Colume Headings 1

Back
Top