Even if you are an expert in formulas and handling of Excel, it may be the case that, when you need to have a physical representation of your work, you get a complete disaster. It is because the unlimited format of the calculation books is not complemented by reality.
Configuring the print area is a basic aspect to consider before starting any physical reproduction of your Excel files. The truth is, this does not have any degree of complexity, with some common sense and practice you will be able to learn it by heart. Right now we will explain everything you need to know.
Index( )
- How can you see the print area in your Excel document?
- With the Android or iOS mobile app
- From your Windows or Mac computer
- What is the procedure to manually set the area of your print?
- What to do to clear the print area of your spreadsheet?
- Using VBA
- With the page break
How can you see the print area in your Excel document?
If normally when you want to print in Excel correctly without being cut off , you ask for help from third parties, it is time for you to learn for yourself how to obtain an optimal result. It is very likely that your work area exceeds the dimensions of the paper on which you will print.
In these cases, it is important to check the workbook print area in Excel, since, many times, you will have the need to print only a section of the document such as a specific graph or data table, and properly configuring said area will allow you to achieve it. .
With the Android or iOS mobile app
Nowadays, practically all human beings have a mobile device, because it is easier to access them than a computer, so it is not unusual to use these devices to carry out office tasks. For example, editing Excel workbooks, if you are part of this user group and need to verify the print area , follow these steps:
- Download the official Microsoft Excel app and log in with your user.
- Open the corresponding file, followed by pressing the button with three parallel dots in the upper right corner of the screen.
- There you will find the “print” option, if you click on it you will have a preview of the document divided into pages, just as it would be printed.
From your Windows or Mac computer
It will always be much more comfortable and functional to use the Excel desktop software, in carrying out specific tasks, since it is still a reality that the functions it offers are broader than in its mobile version. So, from your computer, verifying the printing area is very simple:
- Click on the top menu of “File” of the Excel workbook.
- Scroll down to the “print” option and click on it will show a preview of the active pages for printing.
A trick to get to this point much faster is to press the CTRL and F2 keys simultaneously. Another aspect that you should consider when making changes to your book is to protect an Excel file in ‘Read only’ mode, in this way when printing you avoid accidentally causing damage to the formulas and structure in general.
What is the procedure to manually set the area of your print?
It is common that you need to print only a section of your spreadsheet, and you may think that you should copy to another file, only the necessary information to be able to print separately , but the truth is that this is not necessary. Within Excel there are tools arranged to facilitate this process:
- Initially, you will have to download Excel from its site , immediately open the file you are interested in.
- There, keeping the left click you select the cells or region you want to print.
- The next thing is to go to the top menu of “Page layout”, choose the option “Print area”, then click on “Set print area”.
- The next thing is to press the “Print titles” button, a page configuration window will open, in which you make sure to check the “Print preview” option.
- You will notice that in your print area, only the cells selected at the beginning are displayed.
What to do to clear the print area of your spreadsheet?
It is possible that when deciding to print something it has gone wrong and you are interested in removing errors when printing an Excel sheet , then you can modify the previously configured print area simply by clicking on “Print area”, then on “Add to print area ”, so you can include other sections to print.
If ultimately, you need to reset the entire print area to start a new configuration, you only have to press the “Print area” button and then choose the “delete print area” option, in this way you restart the entire process.
Using VBA
Visual Basic for Application or VBA, is a programming language that allows you to configure macros, within the different Microsoft Office platforms, thus automating many tasks. If you use this tool in Excel you will discover multiple features, including automated printing.
Basically, you train Excel to do various tasks for you, which is extremely efficient, if you are interested just go to File> Options> Customize Ribbon and check the box for “Scheduler” . By inserting a new schedule in Excel you can create a button that simplifies your printouts in a custom way.
With the page break
When what you need is to print different sections of the document, by default Excel will generate a page for each one, at the end of printing you will have consumed a large amount of paper. To save yourself this you can activate the Kutools plugin by this path File> Options> Plugins, once you have it enabled you can eliminate the page breaks in your printout with the “Multiple Selection Wizard”.
