| You can also check the checkboxes under the “Center on page” section to center the worksheet data on the page. To center it horizontally, check the “Horizontally” checkbox. To center it vertically, check the “Vertically” checkbox. After you set margins in Excel and make the other changes you want to apply, click the “OK” button.|
Margins are the empty space between the worksheet data and the left, right, top, and bottom edges of the printed page. You can manually adjust them to add more or less space around your worksheet data.
By default, the margins are 0.75 inches at the top and bottom, and 0.70 inches to the left and right.
Portrait orientation is the default setting for printing worksheets, but you may want to use landscape orientation instead.
It happened again. You go to print your latest Microsoft Excel spreadsheet, and half your data is cut off because the ugly, large white borders of the document are too large. You want to fit as much data onto each spreadsheet page as possible, which is why you need to change the page margins in Excel to be as small as possible. Here's how to print in Excel without margins.
What Are Margins?
Margins are those frustrating blank white spaces between your spreadsheet and the edge of your printed page. The top and bottom margins are usually reserved for header and footer content, while the side margins are there mostly to center your document and frame your content to look more visually appealing. However, if you are like many who have printed awkward spreadsheets, you may find them to be unnecessary space-fillers that could be space better filled with more data cells.
There are a couple of ways you can change page margins in Excel to better serve your spreadsheet. You can adjust the preset margins or create custom ones all together. But first you need to decide what part of your spreadsheet you are going to print.
Selecting Your Spreadsheet for Print
When you go to print your spreadsheet, you may be trying to print your whole Excel document, or just a single sheet. When you go to print your document, you will be prompted to print either the entire document, the current sheet you are on, or all content you have selected.
If you are just trying to print one sheet, click the bottom tab of the sheet you are trying to print to select it. If you are trying to print a couple sheets at a time, you can select them by bookending them, clicking the tab of the first sheet you want to print, holding Shift, then clicking the tab of the last sheet you want to print. This will select the content, so you can choose the From Selected option when you go to print.
Change Page Margins in Excel
Now, to change the margins for your spreadsheet. First, locate the Page Layout tab of your Excel menu bar. There, under the group of options in the Page Setup section, click the Margins icon. You can adjust the margins in a couple ways.
You will first be given the option to select from one of Excel’s pre-made margin templates. These options are Narrow, Normal, and Wide. To reduce the white space in your margins with one of these settings, you will want to change the margins of the current worksheet to Narrow. There is a potential fourth option as well, but we will get to that in a minute.
To see if this will fit your taste, change the margins of the current worksheet to Narrow. To preview how this changes your document, go forward with a Print Preview. If you change the margins of the current worksheet to Narrow and it is not a big enough reduction for you, you will need to use the Custom Margins option.
Create Custom Margins
You have the option to customize your margins with the Custom Margins option. There will be four separate boxes, indicating each of the four margins, for you to enter your custom dimensions. They are Top, Left, Right, and Bottom. You can click on each margin box directly to edit them. The lower you make each individual margin number, the narrower the margin will be, and vice versa for when you make the numbers larger.
Every time you set a custom margin for a document, Excel actually saves those settings, and they will show up in the margin template section next to Narrow, Normal and Wide under the option Last Custom Setting. This way, once you find a margin setting you like, you can use it again in the future.
Beyond the basic Top, Bottom, Left and Right margins, you can also adjust your Header and Footer margins. Changing these settings will change the distance between the top of the page and your header, or from the footer to the bottom of your paper. Microsoft recommends keeping your header and footer margins smaller than your top and bottom margins, but larger than or equal to whatever the minimum margin is for your printer.
Apply the Preset Margin Option to Reduce the White Space
To apply the preset margin option that will add the least amount of white space, set all of your margins, header, and footer options to zero inches. This will remove all margins from your document, which should in turn solve your problem.
If you want to review how your spreadsheet will look without margins before you click OK to apply, you can do so by pressing the Print Preview icon. If you want to physically see the size of the margins on your document, click the little box in the lower right hand corner called Show Margins, which will project them as little black lines over your document.
You can actually adjust these margins in this section by dragging and placing them. However, if you turned all your margins to zero, there should be very little need to do this. That’s why you apply the preset margin option that will add the least amount of white space.
Print to Excel
You may now Print your spreadsheet. Go to the File drop down menu and select the Print option. Before you go ahead with your print, click the Print Setup option, which will bring up a new window. In this window, you are going to want to set the scale of your printed document.
You can make good use of Excel’s Custom Scaling options to change page margins in Excel and get rid of any extra white border even after you set your margins to zero. From the Print Setup page, make sure that you click the No Scaling box, and then drop down to the Custom Scaling Options button from the end of the list. This will open a window called Page Setup, where you will see a little section for Scaling.
In the Scaling sub-section, there should be a box that says Adjust to, which refers to your document’s current percentage of scale. If correct, it should say Adjust to: 100% normal size. If the number is any less than 100%, you will want to click the up arrow to increase it to 100 percent. Then, click OK to apply the changes, and go ahead with printing your document.
Compare Your New Print to Excel
Once your s*preadsheet has printed, check it out*_._ Compare your printed spreadsheet to your spreadsheet document in Excel. Is there still a small white margin that your spreadsheet doesn’t show in Excel? If so, it may be that your printer is not capable of edge-to-edge printing.
The type of printer you own may affect how close you can reach to the edge of the page without margin. It all depends on the built-in constraints of the printer. For example, some printers will always leave a small white border because of how they are designed. If that’s the case and your printer just isn’t capable of edge-to-edge printing, you can still reduce the margins to be as small as possible.
There is a chance that there are additional settings under Printer Properties you can meddle with, or you can look into the manufacturer website to see if there are any known workarounds for your printer type.
Other Ways to Change Page Margins in Excel
Another method to change page margins in Excel is to make the actual content of your spreadsheet wider. You can do this by increasing the width of your spreadsheet columns, increasing the font size of your column’s content, or resizing any included images to be horizontally larger so they stretch to the edge of your spreadsheet.
The last step you can take to ensure that your Excel spreadsheet will print without any Margin _w_hatsoever is by adjusting your printer settings. To begin, make sure your printer is online. Next, log onto your computer, and head to the Printers and Faxes section of your computer’s devices hub. This is located in different places depending on what type of computer you have, so here are breakdowns for both PC and Mac.
Checking Your Printer for Borderless Printing on a PC
On your PC, use your Windows Start Menu to get to your devices, and right click the name of your printer, then click Properties. Navigate to the tab called General, and look at your Printing Preferences. From the Printing Shortcuts section, choose the option for photo printing - borderless to ensure that whatever document you print, the default will be for your printer not to add any additional borders. As you can tell from the name, this option is usually used for printing photos, but can be useful for removing borders from any type of document.
Depending on the type of printer you have, this option may be called borderless or may simply be unavailable to you. If that is the case, then you may need to contact your printer manufacturer directly to find out what other options you have for removing borders from your printed spreadsheet.
Once you have selected whatever borderless printing option is available to you, continue to the options for Print Quality and layout. For the best results for a spreadsheet, set your printer’s orientation as Landscape, and make any other needed adjustments to the paper size and paper type options as applicable to whatever paper type you are printing your spreadsheet on.
Checking Your Printer for Borderless Printing on a Mac
On your Mac, open your System Preferences window, and click on Printers & Scanners. Here, you will be able to change the Default Settings of your printers, particularly the Default Paper Size. However, to change the margins of these paper sizes specifically, you will need to adjust them in a different area and save them as a Preset so you can access them every time you print a spreadsheet. To do so, move forward with printing a document in another area first.
On whatever web browser you currently use, click File and then Print to open the Page Setup setting. Under the Paper Size list, select the option to Manage Custom Sizes. From here, you will see all the options to adjust the margins, but will be unable to adjust them until you click the + sign under the list of custom margin presets. Once you click the + sign, you can now begin to edit your settings.
As shown above, type zeroes into all of the margin boxes. Your printer may push back against doing this, and a new window will pop up to tell you what the smallest margin your printer will accept. Once you have made your adjustments, name your new custom paper size something like Zero Margins and then click OK.
Back on the Print screen, go up to the Presets section and select the option to Save Current Settings as a Preset. You will be prompted to name the preset, so name it something like Zero Margins as before, then click OK. Now, next time you take a spreadsheet to print to Excel on your Mac, your printer will default to this zero margins preset to keep your margins as narrow as possible.
How do I set margins in Excel cell?
Click the Home tab and select the Cells group. 2. In the Margins section, click the desired margin (left, right, top, or bottom) and type a value in that box. If you want to change the margin for all cells in a workbook, select the workbook and then use the keyboard's arrow keys to navigate to the Cells group.
How do I get Excel to recognize 0?
Click File > Options > Advanced. Under Display options for this worksheet, select a worksheet, and then do one of the following: To display zero (0) values in cells, check the Show a zero in cells that have zero value check box.
How do I get rid of margin lines in Excel?
Click the Home tab. In the Font group, click on the 'Border' drop-down. In the border options that appear, click on 'No Border'