Microsoft excel print area

In reply to Rohn's post on April 27, Thank you all so much for your help. I figured out that I had a page break in the spreadsheet that I had forgotten about. It's all fixed. I would try this. Copy the data, not the worksheet, and paste into a new file. Now see if Print Area works. This site in other languages x.

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. Showing results for. Show only Search instead for. Did you mean:. Sign In. New Contributor. Labels: Labels: Excel. Tags: Multiple Pages. Jan Karel Pieterse. A sheet has just one print area, paper size, margin settings, zoom percentage. If you need very different settings for any of those, consider using two sheets just for printing or perhaps a macro.

You can record one doing these steps: - Set up first area the way you like and print it - Repeat for second one - Stop recorder This macro should now give you two prints the way you selected during recording. Preview file. Want to visually see all your settings? Here's a more transparent approach to defining a print area:. When you want a hard copy of a whole sheet or entire workbook but do not want to bother clearing all the print areas, just tell Excel to ignore them:.

The ability to print multiple areas per sheet of paper is controlled by a printer model, not by Excel. If your printer has such an option, lucky you are : If there is no such option, then the only way I can think of is copying the print ranges to a new sheet. With the help of the Paste Special feature , you can link the copied ranges to the original data in this way:.

In case you have a lot of worksheets with exactly the same structure, you will obviously want to output the same rage on paper. 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. If you have to print the same area on multiple sheets regularly, the use of VBA can speed up things.

This macro automatically sets the print area s for all selected worksheets the same as on the active sheet. When multiple sheets are selected, the active sheet is the one which is visible when you run the macro. No matter how many sheets you have, this code defines the print range in a whole workbook in one go. Simply, set the desired print area s on the active sheet and run the macro:.

When working with different workbooks, you may find it convenient if the macro prompts you to select a range. Here's how it works: you select all the target worksheets, run the macro, select one or more ranges when prompted to select multiple ranges, hold the Ctrl key , and click OK.

The easiest way is to download our sample workbook with Print Area Macros and run a macro directly from that workbook.

Here's how:. Alternatively, you can save your file as a macro-enabled workbook. Windows 11 Uninstall Clock. Teams Walkie-Talkie. PCI Express 6. Wordle Scams. T-Mobile iCloud Private Relay. Avira Antivirus Crypto Miner. Linux PinePhone Pro. Google Green Messages. Use Your iPhone as a Webcam. Hide Private Photos on iPhone.

All Microsoft's PowerToys for Windows. Take Screenshot by Tapping Back of iPhone. Windows 11 Default Browser. Browse All Windows Articles. Windows 10 Annual Updates. OneDrive Windows 7 and 8. Copy and Paste Between Android and Windows.

Protect Windows 10 From Internet Explorer.