1. M

    Page Layout Margin

    Error rows going onto next page when space left on page, only seems to happen for this workbook, all others seem to fill ok. But there is a fair amount of invested time in layouts formula, and macros that would be a pain to switch to a new workbook (so i'm leaving that as last resort) Workbook...
  2. S

    Formula equivalent of Goal Seek function. How to manipulate margins based on Pricing requirements?

    0 <button class="js-vote-down-btn grid--cell s-btn s-btn__unset c-pointer" title="This question does not show any research effort; it is unclear or not useful" aria-pressed="false" aria-label="down vote" data-selected-classes="fc-theme-primary" style="margin: 2px; box-sizing: inherit; font-size...
  3. S

    No Margins

    Hi All, Is it possible, to have printout in Excel with NO margins (maybe with macro) ? Thank you in advance.
  4. D

    Subindexing and Marginal Differencing

    I have this dataset: <tbody> User Date Time A 9/1/2019 8:00 AM A 9/1/2019 10:00 AM A 9/1/2019 4:00 PM A 9/1/2019 5:00 PM A 9/2/2019 8:00 AM A 9/2/2019 5:00 PM B 9/1/2019 9:00 AM B 9/1/2019 3:00 PM B 9/1/2019 5:00 PM </tbody> The first thing I want to do is add a subindex on...
  5. Y

    Print to PDF margin page setup VBA MACRO

    Hello I am trying to print and have the vba code adjust margins so i don't have to every time. The issue im running into is that it wont print it to a 11x17 pdf size and it wont fix the margins for me. It wont print to scale. Anyways it keeps saying "Document not saved" AND when i debug it...
  6. C

    Increase Cell Margins - sometimes the text tab isn't in format options

    Hi, I'm looking to increase the size of the margins in my cell, particularly the vertical. i.e. - I want there to be more white space between the rows. When I select Format cells, sometimes the text tab is there to be able to change those margins, but many, many times, it's not. Is there...
  7. N

    Office365 Excel

    I want to print below a logo letterhead but cannot get the margins set as I need them?
  8. N

    need help with calculations

    I am trying to determine a margin based on my total cost of products For example I have multiple line items with a cost I want to add a margin to each line item depending on it range <1000 add 45% margin <5000 but greater than 1001 add 43% margin <10000 but greater tan 5001 add 35% margin etc
  9. C

    Macro needed for Formatting Print Area, Margins etc

    Can someone please help me with possibly an advanced macro. I process a bunch of different reports with different sizes, sometimes single tabs, sometimes multiple tabs, different rows or columns of data and different formatting etc. But every report I send has a few formatting requirements and I...
  10. T

    After Macros is broken, formatting is not the same

    Hi everyone, I had an issue with a macro in my workbook, which is now resolved. However, I can not get the margins, headers and overall formatting of my document back to the way it was. I've re-created it, tried it from another version of excel, even a different pc but the margins are just not...
  11. Wessie

    Excel Workbook Print layout differs across machines

    Good day all I was hoping that someone could be of assistance. I created a complex workbook with all kinds of Userforms, Modules and VBA coding. The resultant workbook is a separate workbook created by my Excel utility that consists of a Sheet copied from my utility. Upon initial setup of...
  12. E

    How can I get the spreadsheet to print on the sheet from edge to edge?

    I have removed all the Margins , Header & Footer... Thanx Brian
  13. B

    Setting margins in comments with VBA

    I need help writing code to set margins within the cell comments themselves in VBA. I have found posts to set every other kind of margins, but not in cell comments. let me know if you know of any. For Each MyComments In ActiveSheet.Comments With MyComments .Shape.AutoShapeType =...
  14. U

    VBA sets print margins for 9 pages, but they don't print in the right order

    Hello, I have code to set the print margins on an excel sheet with 9 sheets printed. The code is the following: <code> ActiveSheet.PageSetup.PrintArea = "$A$14:$P$87,$A$88:$P$155,$A$162:$P$221,$Q$14:$AE$87,$Q$88:$AE$155,$Q$162:$AE$221,$AG$14:$AV$87,$AG$88:$AV$155,$AG$162:$AV$221" </code>...
  15. D

    Excel print page misses first column

    Hi guys! i made a macros that sorts people's names. it has 2 columns, the names, and the desk number. however, when i go to print it, the print space doesnt include the first column, only shows the desk space column. and the first page that prints is blank. to fix it, i have to go to page layout...
  16. H

    Formula require to work out selling price based on NOG

    NOG stands for Nett On Gross and is calculated by dividing cash margin ex VAT by retail sales including VAT. Whereas the standard method of working out retail margin is cash margin divided by retail sales excluding VAT. NOG example Retail Sales Price of Product X = £2.00 Less 20% VAT = £1.67...
  17. D

    Page Size

    I am attempting to find the usable page size so that I can set Page Breaks in VBA. I have it working with the following code. But it is only guess work. I would like to be able to know when I am going to overflow the bottom of the usable space rather that guessing at how big it is. There is...
  18. L

    Changing Orientation of pages

    Hi, I'm looking for a way to change the margins while changing the orientation of the page in Excel. When in portrait mode the margins need to be: Left/Right: 2,3; Top/Bottom: 3,6 and Header/Footer: 3,3 (cm). In Landscape it should be: Left/Right: 3,3; Top/Bottom: 2,3 and Header/Footer: 2 (cm)...
  19. D

    Best way to display custom setting for printing

    There are often times when reports or data sets are larger then what can normally fit on one page. When ever this happen I usually go into page break view or set rows/columns to fit to one page. This works great for getting what you need down to one page. However whenever I print that one...
  20. J

    Display margin settings

    I am using Excel 2016, Windows 10. How do I display/show the margin settings of the current worksheet, using VBA. Thanks, Judy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back