#Excel 2013 print preview button code#
Then select View Code from the context menu.
#Excel 2013 print preview button how to#
VBA Macro to Display Print Preview for the Active Sheetįirstly, we’ll learn how to display a print preview for the current working active sheet. To explore the methods, we’ll use the following dataset which represents some salespersons sales in different regions.ġ. All Rights Reserved.3 VBA Macros to Display Print Preview in Excel The exact layout of your Print Preview window is determined by the Printer Driver.Įxcel will include a small header and footer by default although this can easily be removed. Margins are only visible when you display your worksheet in Print Preview. You can also define a group of non continous cells as your print area by using the Ctrl key and then selecting (File > Print Area > Set Print Area). To return to normal view press the left mouse button again. To magnify an area of the page, move the mouse over the area (the cursor should change to a magnifying glass) and press the left mouse button. There are six types of margin that can be adjusted Note there is a margin indicator in the bottom left corner to give you the exact size. You can reposition any of the margins by dragging them with the mouse. Press and hold down the left mouse button as you drag the column to a new width. To change the width move the mouse over the column, the cursor will change to a ?. You can also change the widths of the columns. To adjust one of the margins move the mouse over one of the margin lines, hold down the left mouse button and drag the margin to its new location. Help - Displays the Print Preview commands from the Help menu.Īs you move a margin the distance is displayed in the bottom left corner between the margin and the edge of the page. The same as selecting (View > Page Break Preview).Ĭlose - Closes the print preview window and returns to the previous view of the active worksheet. Page Break preview - Displays the worksheet in Page Break preview. Displays or hides margin handles that you can drag to adjust page margins, header and footer margins, and column widths. Margins - Displays the current margins on the page. Setup - Displays the (File > Page Setup) dialog box. Print - Displays the (File > Print) dialog box. There is no way to adjust the percent of the zoom though. It is possible to zoom in by pressing the left mouse button anywhere on the page. Zoom - You can use the Zoom option to magnify and examine any particular part of the page. If you have multiple worksheets selected and click Previous when the first page of a selected worksheet appears, Excel displays the last page of the previous selected worksheet. Previous - Moves to the previous page if your worksheet has multiple pages. If you have multiple worksheets selected and click Next when the last page of a selected worksheet appears, Excel displays the first page of the next selected worksheet. Next - Moves to the next page if your worksheet has multiple pages.
The status bar in the bottom left corner tells you which page you are currently looking at and the total number of pages on your worksheet. You can display the whole page again by pressing again.
You can magnify an area of the page by moving the left mouse button over the page and pressing with the left mouse button. The majority of the available options can be accessed from the Print Preview toolbar. You can exit Print Preview mode at any time by pressing the ESC key. It is not possible to view more than one page at a time (unlike Word). You can display Print Preview either by pressing the button on the standard toolbar or by selecting (File > Print Preview). The worksheet name and page number will appear by default, although it is very easy to change the header and footer ? Print Preview displays your page exactly as it will be printed and is only displayed in colour in you have a colour printer.
0 kommentar(er)
