How to Show margins in Excel 2022 Print Preview

A margin is a space between the page content and the edge of the page. Excel offers three predefined sets of margins: Normal (used by default), Wide, and Narrow :

Table of Contents Show

Printing in Excel
Publisher Summary
Indexing guidelines
Capitalization
Advanced output and pen settings
19.5 Lineweight VISIBILITY Settings
How do I show margins in print preview in Excel?
Why are the borders missing in Excel preview?
How do I set print margins in Excel?

To adjust the margins to make the data fit more comfortably on the page, do one of the following:

On the Page Layout tab, in the Page Setup group, click Margins:
Form the Margins dropdown list, select one of the proposed options:
On the File tab, click Print (or click Ctrl+P):
On the Print pane, under Settings, from the Margins dropdown list, select the option you need:

Note: To set the custom margins, click the Custom Margins... option. See how to set custom margins below.

Get full access to Microsoft Excel X for Mac OS X: Visual QuickStart Guide and 60K+ other titles, with free 10-day trial of O'Reilly.

There's also live online events, interactive content, certification prep materials, and more.

In the top left corner we see a large button labeled Print; clearly, this is the command to send the print preview to the printer.

Next to that is the control for selecting how many copies are to be printed. You can use the scroll arrows or type a number in the box to set this value.

The Printer control allows us to select which printer we wish to use—assuming we have more than one printer installed.

Under this is text reading Printer Properties. Clicking on this will bring up a dialog specific to the selected printer. For example, depending on the printer, a user might be able to specify that a multiple page output should be printed on both sides of the paper or that everything should be in grayscale rather than color.

The first control under the Setting heading allows the user to select from the following: print just the active sheets, print all sheets in the workbook, or print a range that has been selected prior to opening the Print Preview dialog.

If the print job has many potential pages, the next control lets the user select which pages to print.

The Collated control has meaning only when one is printing multiple copies of a multipage job.

Next, we have a control from which we may select either portrait or landscape orientation.

Then we have a paper size selection tool.

10.

The penultimate control allows us to set the margins on the paper.

11.

The final control (scaling) is used to make the printout fit onto a specified number of pages. Suppose you have a print job that needs two pages but the second page would contain perhaps three rows from the worksheet. The Fit Sheet control lets us squeeze the print job onto one page. It does this by adjusting the font size on the paper but leaves the worksheet unaltered.

Some of the options (including 8, 9, and 10) on the Print Preview dialog are also available on the Page Layout tab which we look at in the next exercise. On the Print Preview dialog, there is a control (not visible in Fig. 3.1) which gives the user access to the Page Setup dialog.

If your print job takes more than one page then after you have used Print Preview, Excel adds dotted lines to your worksheet showing the page breaks. The exact position is printer dependent. On the author's worksheet, the first vertical dotted line was between columns J and K and the first horizontal one, between rows 46 and 47. These automatic page breaks, unlike manually entered page breaks, cannot be removed. If they clutter your worksheet, just close the workbook and reopen it.

Printing in Excel

Bernard V. Liengme, David J. Ellert, in A Guide to Microsoft Excel 2007 for Scientists and Engineers, 2009

Publisher Summary

Even in this paperless-office world, printing the worksheets from time to time is still needed. This chapter helps to learn about the Print dialog and its option, the Print Preview feature that can save paper wastage, and the Print-Area and how to set it. This chapter also illustrates setting the margins and orientation, setting options such as printing gridlines and row/column headers, getting Excel to print the same rows and or columns on every page, printing a selection, inserting page breaks, and changing the paper orientation.

Indexing guidelines

Kurt Ament, in Indexing, 2001

Capitalization

Read this

Proper capitalization is critical to the usability of an index. Indexes are lists, and lists are scanned, not read. To succeed, index entries must be clear, concise, and to the point. There literally is no time or space for long-winded explanations. Visual (pre-verbal) communication is critical. How an index entry is capitalized signals in the broadest possible terms what type of information the entry contains.

Index entries can be capitalized in one of three ways:

▪

Lowercase (abc)

The clearest signal for garden-variety entries is lowercase (for example, “printing documents”).

▪

Uppercase (ABC)

The clearest signal for literal strings, such as computer commands and filenames, is uppercase (for example, “AUTOEXEC.BAT”).

▪

Initial capitalization (Abc)

The clearest signal for interface elements, such as computer program names and menu items, is initial capitalization (for example, “Print Preview”).

To avoid confusing these three distinct signals, never capitalize the first word of an index entry just because it is the first word (for example, “Printing documents”). Although this traditional type of capitalization, known as downstyle capitalization, is ideal for document headings, it confuses the visual (pre-verbal) signals of the most carefully constructed index.

Do this

When developing any index entry, follow these guidelines:

▪

Use lowercase as your default

Use lowercase for all words that are not proper nouns.

BadGoodSoftware applications, 6software applications, 6Troubleshooting, 4troubleshooting, 4

▪

Use uppercase for literal strings

Use uppercase for literal strings, such as computer commands and filenames, even if these nouns are capitalized differently in the document you are indexing.

BadGoodAutoexec.bat, 1AUTOEXEC.BAT, 1config.sys, 2CONFIG.SYS, 2

▪

Use initial capitalization for product components

Use initial capitalization for products, product components, and interface elements.

BadGoodnorton utilities, 5Norton Utilities, 5file menu, 3File menu, 3

▪

Follow trademarked capitalization

Never change the capitalization of trademarked product or component names.

BadGoodDBASE files, 1dBASE files, 1Imac, 17Apple iMac, 17

Advanced output and pen settings

Elliot J. Gindis, Robert C. Kaebisch, in Up and Running with AutoCAD® 2022, 2021

19.5 Lineweight VISIBILITY Settings

An additional Lineweight Settings option is available to you. It is found all the way on the right among the bottom screen menu choices, as shown in Fig. 19.10. If it is not there already, you of course must first bring it up via the main menu at the far right (the three horizontal bars). If the icon is blue, as shown in Fig. 19.10, the Lineweight feature (called LWT in older versions of AutoCAD) is active. If it is grayed out, then it is not.

Figure 19.10. Lineweight icon.

Right-clicking on this icon brings up the Lineweight Settings… dialog box (Fig. 19.11).

Figure 19.11. Lineweight Settings.

This feature is not the same as covered earlier in this chapter. The CTB file and setting the lineweights in that manner gets you only see lineweights in the print preview or physically printed results. This means that, on screen, all the lines remain the same size 1 pixel wide, regardless of the CTB settings. The results of the CTB settings can be seen only on paper or in the print previe.

In contrast, the Lineweight option allows you to set line thickness that is visible on screen in the Layer settings for visibility while in Model Space and in Paper Space. It is a rather interesting effect. While in model space, a layer with a lineweight set from 0.00mm to 0.25mm is displayed as one pixel wide, and thicker lineweights use a proportional pixel width greater than 1 pixel wide. Lineweight display in model space does not change with the zoom factor so lineweights can get muddy as you zoom out, away from your design. In a paper space layout, lineweights are displayed as they would be printed, and lineweight display changes with the zoom factor. Once set, the lines remain at that thickness regardless of how much you zoom in or out. Opinions on this effect vary among AutoCAD users. In Model Space mos see it as a distraction and are perfectly fine remembering what colors are set to what line thickness via the CTB method. It can be useful in Paper Space, showing a quick print preview of what would be printed without going into the Plot dialog, Page Setup Manager or Ribbon's Output tab for an actual print preview. It is up to you to experiment and see where you stand.

If the Default lineweight of 0.25 mm (0.010 inch) is too thin for your taste, simply type lineweight and set a different global default in the dialog box shown in Fig. 19.11. Alternatively, you can set lineweights layer by layer by going in Layer Properties Manager, creating a new layer (usually with a color), and setting the value under the Lineweight header, as seen in Fig. 19.12 (with 0.50 mm used for clarity). The result is seen in Fig. 19.13.

Figure 19.12. Lineweight Settings.

Figure 19.13. Lineweight set to 0.50 mm.

After setting this layer as current, draw something. Notice that the line is thin, as if nothing happened. Now press in the Show/Hide Lineweight button to activate it; the line suddenly turns thicker, as seen in Fig. 19.14. This is exactly how it will print.

Figure 19.14. Line drawn with the 0.50 mm Lineweight Setting.

Note, that CTB settings supersede a layers Lineweight settings. Ideally your CTB file and your layer lineweight setting would match so there is no confusion between the on-screen display and the final output. In the professional world, where shared CAD standard files are housed on a network, the CTB method alone seems to be the most prevalent and has been well established over time. If you are in an educational environment and need grayscale or screening, like most things in AutoCAD, there are several options. You can add transparency to your layers in the Layer Properties Manager to lighten them up. This takes some experimenting and can yield interesting results where lines overlap. A final approach is to set your layers with the desired grayscale work to the color 9. Then when printing, set your plot style table to monochrome.ctb and click the button to Edit the Plot Style Table. Next, scroll down and change the Color setting for color 9 to Use object color. Your layers set to color 9 will print as gray following the linetype and lineweight as specified for those layers. Every other color will still print black following their respective layer's linetypes and lineweights. There are lengthy debates online about which way is best and you or your CAD manager must decide. What is more important is to know your options and how to troubleshoot printed output problems if they arise.

How do I show margins in print preview in Excel?

Tip: To preview the new margins, click File > Print. To adjust the margins in Print Preview, select the Show Margins box in the lower right corner of the preview window, and then drag the black margin handles on either side or at the top or bottom of the page.

Why are the borders missing in Excel preview?

If you are using Microsoft Excel 2010+ (i.e. a version later than Office 2010), Navigate to the Layout tab. There are 4 sub-sections there namely: Page Setup, View, Print and Window. Under the Print sub-section, check the Gridlines option. That should do it.