Repeat header row?

D

degas1900

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

How do I format a worksheet so that the row containing column headings repeats on every sheet? I can't find a way to do it similar to the Windoz version.
 
L

Laroche J

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

How do I format a worksheet so that the row containing column headings repeats
on every sheet? I can't find a way to do it similar to the Windoz version.

As it has always been in all versions, Mac or Windows:
File / Page Setup... / Sheet

JL
Mac OS X 10.4.11, Office v.X 10.1.9
 
C

CyberTaz

As JL suggested, or click the Print Titles button in the Page Setup section
of the Formatting Palette in order to get into the dialog box. Specify "Rows
to repeat at top", such as: $4:$4.

HTH |:>)
Bob Jones
[MVP] Office:Mac
 

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

Top