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 |
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 |
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