Header/Footer

A

Antonio

Hi, all

For the header, have an option to select row to repeat at top, is
there anything similar for the footer??

Tks in advance
Antonio
 
G

Gord Dibben

Setting "rows to repeat at top" is setting Print Titles and is not the same as
setting a header.

You can have a header as well as the Print Titles.

No. You cannot set "rows to repeat at bottom".

Gord Dibben Excel MVP
 
A

Antonio

Ok, tks

Gord Dibben said:
Setting "rows to repeat at top" is setting Print Titles and is not the same as
setting a header.

You can have a header as well as the Print Titles.

No. You cannot set "rows to repeat at bottom".

Gord Dibben Excel MVP
Click to expand...
 
J

jackiemac1595

Any ideas on how to repeat rows at the bottom of each page? The text I need
to repeat is too large for the footer (exceeds characters). I don't want to
figure out where to break my pages to insert the text each time.
 
J

Jim Cone

Use Page Break Preview and paste your text above each page break.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"jackiemac1595"
wrote in message
Any ideas on how to repeat rows at the bottom of each page? The text I need
to repeat is too large for the footer (exceeds characters). I don't want to
figure out where to break my pages to insert the text each time.
 
G

Gord Dibben

Excel has no function for repeating rows at bottom.

Workaround................

Select the range to repeat.

SHIFT + Edit and "Copy Picture" as Bitmap

Start>Run clipbrd.exe

File>Save As mypic.clp

With your favorite Graphics Editor like IrfanView, convert mypic.clp to a *.jpg
file.

Insert that into your footer.


Gord Dibben MS Excel MVP
 
J

jackiemac1595

thx - jam

Jim Cone said:
Use Page Break Preview and paste your text above each page break.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"jackiemac1595"
wrote in message
Any ideas on how to repeat rows at the bottom of each page? The text I need
to repeat is too large for the footer (exceeds characters). I don't want to
figure out where to break my pages to insert the text each time.
Click to expand...
 
B

BBZ

The answer looks partially answered my questions. But how to apply the
customized header and footers to other existing file without re-editing them
?
 
G

Gord Dibben

If text to repeat on all files would be the same as first one, create the
*.jpeg then record a macro while inserting the graphic on grouped sheets in
that workbook.

Run that macro on each existing file.

If text would be unique to each sheet and/or file, you have a lot of work to
do.


Gord
 
Top