margins

  1. 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...
  2. S

    No Margins

    Hi All, Is it possible, to have printout in Excel with NO margins (maybe with macro) ? Thank you in advance.
  3. 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...
  4. 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...
  5. 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...
  6. N

    Office365 Excel

    I want to print below a logo letterhead but cannot get the margins set as I need them?
  7. 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
  8. 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...
  9. 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...
  10. 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...
  11. 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
  12. 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 =...
  13. 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>...
  14. 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...
  15. 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...
  16. 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...
  17. 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)...
  18. 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...
  19. 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
  20. A

    Margins not saved for other users

    I have a workbook that I made for the office, which multiple people use. On my computer, the page breaks are set so each worksheet only prints on one page. However, when another user tries to print it comes out on 2-3 pages. I noticed that my margins were set as custom and their margins are...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top