lopscape.blogg.se - Excel different margins on first page

#Excel different margins on first page how to#
#Excel different margins on first page mac os#
#Excel different margins on first page code#
#Excel different margins on first page trial#

LeftMargin = Application.InchesToPoints(1.5) CenterHeader = "Page # " & lNum & " of " & lTotal BottomMargin = Application.InchesToPoints(0.4) TopMargin = Application.InchesToPoints(0.4) RightMargin = Application.InchesToPoints(1.5) LeftMargin = Application.InchesToPoints(0.2) I have no idea why 54 = 1.905 cm, or how this works.Įven so, I still can’t get the pages to print with different margin on the odd and even pages.

#Excel different margins on first page trial#

After considerable trial and error, I discovered that by making the value 54, I finished up with a margin of 1.905 cm (I did this by running the VBA and then checking the margin in Layout/Margins after each trial). I set the print area as normal in File/Print/Set Print AreaĪs you can see, I gave a value only to the Left Margin on the odd page (the critical margin measurement), and only to the Right Margin on the even page (the critical margin measurement).Īlthough I set the margin to 1.905 cm, the result was different.

#Excel different margins on first page code#

I realise the lines of code for the Top, Bottom, Header and Footer margin are circular, and probably unnecessary, but this worked for those margins, so I left them. Cells.Find(What:="*", After:=, SearchDirection:=xlPrevious) Although I found one solution (posted by Administrator Dave Hawley in answer to a post from Mikeburg, 15 June 2006), I have been unable to get that to work. I am not very experienced with VBA, and have searched exhaustively for a solution in the posts here and elsewhere before posting this. I am printing on both sides of the paper with a duplex printer and need the left margin greater than the right margin to allow for the pages to be bound into a long edge, left-side-bound booklet. This video lesson is from our complete Excel tutorial, titled “ Mastering Excel Made Easy v.2019 and 365.I am trying to print different margins for the odd pages, and the even pages, from an Excel document with 50+ pages.

#Excel different margins on first page how to#

The following video lesson, titled “ Setting Margins,” shows how to set margins in Excel worksheets.

After you set margins in Excel and make the other changes you want to apply, click the “OK” button.

To center the worksheet data on the printed page, check the “Horizontally” and/or “Vertically” checkboxes under the “Center on page” section.

To set how far in from the top or bottom edge of the page the header and footer data prints, enter the desired value into the “Header:” and “Footer:” text boxes.

Use the spinner arrows at the right of each margin’s text box to set the “Top,” “Right,” “Bottom,” and “Left” margins’ widths, in inches.

Then click the “Margins” tab within the “Page Setup” dialog box.

To center the sheet on the page when you print, under Center on page, select Horizontally and Vertically. Click Custom Margins, and then adjust the margins as you want them to appear.

Then click the “Page Setup” dialog box button in the lower-right corner of the “Page Setup” button group. On the Layout tab, under Page Setup, click Margins.

To set margins in Excel worksheets before printing, click the “Page Layout” tab in the Ribbon.

After you set margins in Excel and make the other changes you want to apply, click the “OK” button. To center it vertically, check the “Vertically” checkbox. To center it horizontally, check the “Horizontally” checkbox. You can also check the checkboxes under the “Center on page” section to center the worksheet data on the page. Set Margins in Excel – Instructions: A picture of the “Margins” tab within the “Page Setup” dialog box in Excel. To do this, enter the desired value into the “Header:” and “Footer:” text boxes. You can also set how far in from the top or bottom edge the header and footer data prints. Use the spinner arrows at the right of each margin’s text box to set the “Top,” “Right,” “Bottom,” and “Left” margins’ widths, in inches. On the Wrong spredsheet, in 'Cell Styles' (yes, I know weve been here before), right-click on 'Normal', then click 'Modify' and then click. I think I found it (at least my print previews of your files came out the same). You can set the margins in Excel for your worksheet on the “Margins” tab. Re: Two Identical Excel Files Print at Different Widths.

Then click the “Margins” tab within the “Page Setup” dialog box. Then click the “Page Setup” dialog box button in the lower-right corner of the “Page Setup” button group. If you print the spreadsheet from the File menu, the preview will only display the selected information. To open the “Page Setup” dialog box, click the “Page Layout” tab in the Ribbon. Click on Set Print Area, and Excel will show you a preview with a dotted line around your selected entries. To set margins in Excel worksheets before printing, open the “Page Setup” dialog box.

#Excel different margins on first page mac os#

Mac OS Monterey-Mojave Keyboard Shortcuts.