ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2007, Headers & Footers question (https://www.excelbanter.com/excel-discussion-misc-queries/208832-excel-2007-headers-footers-question.html)

pgarcia

Excel 2007, Headers & Footers question
 
Hello all,
I have been up graded to Excel 2007 here at my office. I'm having problems
with the headers & footers. When using Excel 2000 I would select all my tabs
and change the footer without incident, but now in 2007 it removes all my
"freeze panes" sections and I have this strange view of the header and
footer. I cant see all the data in my footer. Then I have to change the
€śview€ť back to €śpage break layout€ť. Any ideas?
Thanks


ShaneDevenshire

Excel 2007, Headers & Footers question
 
Hi,

It sounds like you are in Page Layout view. Instead, in Normal view, select
the sheet tabs and choose the Page Layout tab, and on the bottom right corner
of the Page Setup group click the quick launch button below Print Titles. Do
your page setup for headers and footers here.

--
Thanks,
Shane Devenshire


"pgarcia" wrote:

Hello all,
I have been up graded to Excel 2007 here at my office. I'm having problems
with the headers & footers. When using Excel 2000 I would select all my tabs
and change the footer without incident, but now in 2007 it removes all my
"freeze panes" sections and I have this strange view of the header and
footer. I cant see all the data in my footer. Then I have to change the
€śview€ť back to €śpage break layout€ť. Any ideas?
Thanks


pgarcia

Excel 2007, Headers & Footers question
 
THAT'S IT!!! Thanks. I know stuff is still here but some time it seem very
hidden.

"ShaneDevenshire" wrote:

Hi,

It sounds like you are in Page Layout view. Instead, in Normal view, select
the sheet tabs and choose the Page Layout tab, and on the bottom right corner
of the Page Setup group click the quick launch button below Print Titles. Do
your page setup for headers and footers here.

--
Thanks,
Shane Devenshire


"pgarcia" wrote:

Hello all,
I have been up graded to Excel 2007 here at my office. I'm having problems
with the headers & footers. When using Excel 2000 I would select all my tabs
and change the footer without incident, but now in 2007 it removes all my
"freeze panes" sections and I have this strange view of the header and
footer. I cant see all the data in my footer. Then I have to change the
€śview€ť back to €śpage break layout€ť. Any ideas?
Thanks



All times are GMT +1. The time now is 09:34 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com