Choose what to print: selected area, entire sheet, or entire workbook
Posted: Mon Dec 23, 2024 6:42 am
How to print an Excel 1
I will explain the Configuration options in the next point, however, at the top we can select the basic printing options, such as which printer we want to use and the number of copies.
On this same screen we have a very useful feature that appeared since Excel 2010 (if this is your case) which is the print preview , just to the right of this menu. So, taking into account that in the next steps we are going to modify the printing details, keep in mind that it is possible to preview the changes before printing. So we save paper!
As we saw in the image above, under Settings we have a series of printing options, the first of which is the delimitation of the printing area. The meaning of each of the options is as follows:
How to print an Excel 2
Next, we have an indication of the pages; it will saudi arabia email list change depending on whether the printed content fits on a single page of the selected sheet.
How to print an Excel 3
Print active sheets
Prints only the last sheet in which you selected a cell. Prints the entire region of the worksheet where something is typed.
Print the entire book
Well, if in the previous option we printed only the selected sheet, in this option we print the entire workbook. The workbook, in case you don't know, is the group of all the sheets in the file.
Print selection
In this option, we will print only a range of selected cells from a spreadsheet. To select a range of cells in your spreadsheet, simply click and drag the mouse over the desired region or click on both ends of the cell range by pressing the CTRL key.
I will explain the Configuration options in the next point, however, at the top we can select the basic printing options, such as which printer we want to use and the number of copies.
On this same screen we have a very useful feature that appeared since Excel 2010 (if this is your case) which is the print preview , just to the right of this menu. So, taking into account that in the next steps we are going to modify the printing details, keep in mind that it is possible to preview the changes before printing. So we save paper!
As we saw in the image above, under Settings we have a series of printing options, the first of which is the delimitation of the printing area. The meaning of each of the options is as follows:
How to print an Excel 2
Next, we have an indication of the pages; it will saudi arabia email list change depending on whether the printed content fits on a single page of the selected sheet.
How to print an Excel 3
Print active sheets
Prints only the last sheet in which you selected a cell. Prints the entire region of the worksheet where something is typed.
Print the entire book
Well, if in the previous option we printed only the selected sheet, in this option we print the entire workbook. The workbook, in case you don't know, is the group of all the sheets in the file.
Print selection
In this option, we will print only a range of selected cells from a spreadsheet. To select a range of cells in your spreadsheet, simply click and drag the mouse over the desired region or click on both ends of the cell range by pressing the CTRL key.