Header Format

B

Bernie Beal

How do I enclose my Header information within a border?

Bernie Beal
(e-mail address removed)
 
D

Debra Dalgleish

AFAIK, that's not possible. Perhaps you could use the Print Titles
feature instead:

1. In the first few rows of the worksheet, enter the data that you want
on each page.
2. Select the cells, and format with an outside border
3. Choose File>Page Setup
4. On the Sheet tab, in 'Rows to repeat at top' box, enter the row
numbers, e.g. $1:$3
5. On the Margins tab, adjust the top margin to accommodate the print
titles rows.
6. Click OK
 
D

Dave Peterson

And if it's really important, maybe you can set up a worksheet with just the
header information in the worksheet itself (nicely formatted). Then print
multiple copies of that and when you need to print the "real" data, just send
the printed sheets through the printer again.

(Or even use word to build your headers.)
 

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