| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Different font in footer on first worksheet than the others
I selected all worksheets and went to file page setup, and added a footer
to all my worksheets. For some reason however, the footer on the first worksheet is smaller than all the other worksheets and I cant seem to fix it. I dont know why this would happen if I added the footer to all the worksheets at the same time. Please help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Different font in footer on first worksheet than the others
Is the worksheet printed at a different zoom than the others?
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "watchtower83" wrote in message ... I selected all worksheets and went to file page setup, and added a footer to all my worksheets. For some reason however, the footer on the first worksheet is smaller than all the other worksheets and I cant seem to fix it. I dont know why this would happen if I added the footer to all the worksheets at the same time. Please help. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Different font in footer on first worksheet than the others
not really sure what that means to tell you the truth. The rest of the font
is printing fine on the first worksheet so not sure if the zoom would affect the whole sheet or just the footer. If it would, how would I change the zoom? "Jon Peltier" wrote: Is the worksheet printed at a different zoom than the others? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "watchtower83" wrote in message ... I selected all worksheets and went to file page setup, and added a footer to all my worksheets. For some reason however, the footer on the first worksheet is smaller than all the other worksheets and I cant seem to fix it. I dont know why this would happen if I added the footer to all the worksheets at the same time. Please help. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Different font in footer on first worksheet than the others
File menu Page Setup Page tab Scaling - Adjust To ___ %
The headers and footers are changed by this percentage as well as the printed cells. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "watchtower83" wrote in message ... not really sure what that means to tell you the truth. The rest of the font is printing fine on the first worksheet so not sure if the zoom would affect the whole sheet or just the footer. If it would, how would I change the zoom? "Jon Peltier" wrote: Is the worksheet printed at a different zoom than the others? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "watchtower83" wrote in message ... I selected all worksheets and went to file page setup, and added a footer to all my worksheets. For some reason however, the footer on the first worksheet is smaller than all the other worksheets and I cant seem to fix it. I dont know why this would happen if I added the footer to all the worksheets at the same time. Please help. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Different font in footer on first worksheet than the others
So, I checked the page setup and they are all set to Fit to 1 page by 1 page
and are not set using zoom. Is there anything else that may be affecting the printing size of the font? "Jon Peltier" wrote: File menu Page Setup Page tab Scaling - Adjust To ___ % The headers and footers are changed by this percentage as well as the printed cells. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "watchtower83" wrote in message ... not really sure what that means to tell you the truth. The rest of the font is printing fine on the first worksheet so not sure if the zoom would affect the whole sheet or just the footer. If it would, how would I change the zoom? "Jon Peltier" wrote: Is the worksheet printed at a different zoom than the others? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "watchtower83" wrote in message ... I selected all worksheets and went to file page setup, and added a footer to all my worksheets. For some reason however, the footer on the first worksheet is smaller than all the other worksheets and I cant seem to fix it. I dont know why this would happen if I added the footer to all the worksheets at the same time. Please help. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Different font in footer on first worksheet than the others
There you go. If one sheet has more stuff to fit into a page, it will be
shrunk relative to the others, and its footer font will look smaller. What percentages show up in the Adjust to ___ % boxes? (These show what reduction is needed to achieve the Fit to X by Y page.) - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "watchtower83" wrote in message ... So, I checked the page setup and they are all set to Fit to 1 page by 1 page and are not set using zoom. Is there anything else that may be affecting the printing size of the font? "Jon Peltier" wrote: File menu Page Setup Page tab Scaling - Adjust To ___ % The headers and footers are changed by this percentage as well as the printed cells. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "watchtower83" wrote in message ... not really sure what that means to tell you the truth. The rest of the font is printing fine on the first worksheet so not sure if the zoom would affect the whole sheet or just the footer. If it would, how would I change the zoom? "Jon Peltier" wrote: Is the worksheet printed at a different zoom than the others? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "watchtower83" wrote in message ... I selected all worksheets and went to file page setup, and added a footer to all my worksheets. For some reason however, the footer on the first worksheet is smaller than all the other worksheets and I cant seem to fix it. I dont know why this would happen if I added the footer to all the worksheets at the same time. Please help. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Different font in footer on first worksheet than the others
ahhh... wonderful. I see that now, the percentage does say 70% so looks like
I will need to make some adjustments. Thank you very much for your help! "Jon Peltier" wrote: There you go. If one sheet has more stuff to fit into a page, it will be shrunk relative to the others, and its footer font will look smaller. What percentages show up in the Adjust to ___ % boxes? (These show what reduction is needed to achieve the Fit to X by Y page.) - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "watchtower83" wrote in message ... So, I checked the page setup and they are all set to Fit to 1 page by 1 page and are not set using zoom. Is there anything else that may be affecting the printing size of the font? "Jon Peltier" wrote: File menu Page Setup Page tab Scaling - Adjust To ___ % The headers and footers are changed by this percentage as well as the printed cells. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "watchtower83" wrote in message ... not really sure what that means to tell you the truth. The rest of the font is printing fine on the first worksheet so not sure if the zoom would affect the whole sheet or just the footer. If it would, how would I change the zoom? "Jon Peltier" wrote: Is the worksheet printed at a different zoom than the others? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "watchtower83" wrote in message ... I selected all worksheets and went to file page setup, and added a footer to all my worksheets. For some reason however, the footer on the first worksheet is smaller than all the other worksheets and I cant seem to fix it. I dont know why this would happen if I added the footer to all the worksheets at the same time. Please help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If then formulas | Excel Worksheet Functions | |||
| One worksheet to calulate different items simultaneously | Excel Worksheet Functions | |||
| Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
| Macro to search for and display data in another worksheet | Excel Worksheet Functions | |||
| Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
Linear Mode
