In XCEL? How do I set the heading-cells to appear on every page?

X

XCEL

A guy here is trying to figure out example:

Columns A to K in row 1 is particular headings displayed.

He wants to know instead of copying and pasting where the print area shows
the next page.... is there an easier way???
 
S

Shane Devenshire

Hi,

Choose File, Page Setup, Sheet tab, indicate the row 1:1 which you want in
the Rows to repeat at top. Click in the box and then click the row numbers
in the spreadsheet.
 

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

how can i print (row) titles on all pages except the last page? 3
Can I set column headings on every page and exlcude some pages? 1
How do I get info from cell in a row by column heading 3
how do I remove page headings from an imported text file 1
How do I print column on left of page then break & go to right 2
Same heading on every page 3
Printing column label on every page. 2
How to do double quotes in "cell language"? 4

Top