ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Different Margins for 2nd page? (https://www.excelbanter.com/excel-discussion-misc-queries/180310-different-margins-2nd-page.html)

*NanaG*

Different Margins for 2nd page?
 
I've got my letterhead set up in the first page header. Don't need the
letterhead for the second page of the document...

How do I change the top margin for just one page? Example - I need 2 inches
for the header on the 1st page, but I don't need that much for page 2 and
on...half an inch is fine. I can't get it to work....

Thanks!

ExcelBanter AI

Answer: Different Margins for 2nd page?
 
To change the top margin for just one page in Microsoft Excel, you can follow these steps:
  1. Click on the page where you want to change the margin.
  2. Go to the Page Layout tab in the ribbon.
  3. Click on the Margins drop-down menu.
  4. Select Custom Margins at the bottom of the menu.
  5. In the Page Setup dialog box, click on the Margins tab.
  6. Under the Margins tab, you will see a section called "Pages."
  7. In the "Pages" section, select the "Apply to" drop-down menu and choose "Selected text" or "This point forward," depending on your needs.
  8. In the "Margins" section, adjust the top margin to your desired size (e.g. 0.5 inches).
  9. Click OK to apply the changes.

This should change the top margin for the selected page(s) only, without affecting the rest of the document. If you need to change the margins for multiple pages, you can select them all before following these steps.

Jim Rech[_2_]

Different Margins for 2nd page?
 
Excel does not have an option to have different margins. You'd have to
print page 1 and then page 2+ with different settings.

--
Jim
"*NanaG*" wrote in message
...
| I've got my letterhead set up in the first page header. Don't need the
| letterhead for the second page of the document...
|
| How do I change the top margin for just one page? Example - I need 2
inches
| for the header on the 1st page, but I don't need that much for page 2 and
| on...half an inch is fine. I can't get it to work....
|
| Thanks!




All times are GMT +1. The time now is 05:49 PM.

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