how do I display footer while working?It is hidden until I print.

D

Displaying Footers

Right now the footer I made is hidden until I print. I'd like to be able to
see it while I'm working.
 
G

Gord Dibben

Excel does not have this functionality.

You could flip between print preview and your sheet or use a cell range for
the footer then before print use VBA to add that range as the footer.

Example......................

Sub Cell_as_Footer()
With ActiveSheet.PageSetup
.LeftFooter = "&""Algerian,Regular""&14" & Range("A1")
End With
End Sub


Gord Dibben MS Excel MVP

On Sun, 21 Dec 2008 11:26:00 -0800, Displaying Footers <Displaying
 
B

Bob Umlas, Excel MVP

Maybe it's time to upgrade to Excel 2007 - you can see it there in the new
Page Layout view
Bob Umlas
Excel MVP
 
Top