how to enlarge mac excel spreadsheet for printing elsewhere

Enlarge Excel Spreadsheet For Printing Elsewhere Code In Excel

Try making the margins narrower or adjust scaling choose Fit All Columns on One Page.

But what if you dont really need all the content of a huge worksheet on paper Luckily, Excel provides the ability define the parts for printing.

In case you dont want to print the entire spreadsheet, set a print area that includes only your selection.

If you change your mind at a later point, you can clear the print area or change it.

Without it, you may end up with messy, hard to read pages where some important rows and columns are cut off, especially if your worksheet is bigger than the paper you are using.

To select multiple ranges, please remember to hold the Ctrl key.

Whenever you send the worksheet to the printer, only that area will be printed.

For more information, please see How to print selection, sheet or entire workbook.

To check if this option is available to you, press Ctrl P, click the Printer Properties link, and then switch through the available tabs of the Printer Properties dialog box searching for the Pages per Sheet option.

With the help of the Paste Special feature, you can link the copied ranges to the original data in this way.

The problem is that selecting several sheets disables the Print Area button on the ribbon.

Luckily, there is an easy workaround described in How to print the same range in multiple sheets.

When multiple sheets are selected, the active sheet is the one which is visible when you run the macro.

Simply, set the desired print area(s) on the active sheet and run the macro.

Enlarge Excel Spreadsheet For Printing Elsewhere Code In Excel

For the detailed step-by-step instructions, please see How to insert and run VBA code in Excel.

To get it right, here are a few important things to remember.

The best thing about this method is that it lets you make any changes you want modify the print area, delete or add a new one.

This will remove all the existing print areas so only the selected one is set.

This will set a new print area in addition to the existing one(s).

Regrettably, there is no direct way to lock the print area in Excel even by protecting a worksheet or workbook.

For this, you add the WorkbookBeforePrint event handler that silently forces the specified print area just before printing.

Nevertheless, the following troubleshooting tips may come in helpful when Excel is not printing the correct data.

The Print Area field shows some odd ranges, but not the ones you have entered.

How To Enlarge Mac Excel Spreadsheet For Printing Elsewhere