Yes, printing is a familiar and close concept for you to do office work. However, in printing, there are many advanced skills that require users to explore and learn to know.
In the last article, blogchiasekienthuc.com has guided you how to print double-sided paper in Excel, to help you improve your skills in printing in Excel spreadsheets.
And today, I will continue to share with you another tip related to printing on Excel, which is how to print multiple sheets or print all the sheets in an Excel file easily and quickly. . Help you handle your work faster.
Read more:
#first. How to set up printing multiple sheets in Excel (print continuity)
+ Step 1: First, open your Excel file.
To be able to print sheets in Excel, you need to set the order of the sheet first to suit your printing requirements by clicking and dragging the sheet into the slot between the two sheets, or sheet. Last to move.
For example, after I arrange the sheets in the appropriate position, I will get the results of the sheets in the following order.
+ Step 2: Then select / highlight the sheets to be printed, by holding down the key Ctrl => and click on the Sheet you want to print.
+ Step 3: Okey, now click on the File menu 
=> and select Print as shown. Or you can use keystrokes CTRL + P for.Note: In older versions of Excel, the interface was a bit different, but in general the way to do it is quite similar.
+ Step 4: At the dialog box Print, you can click the arrow button to check the number of pages according to the selected sheets => then press Enter, or reselect the print style at Settings => and press Print to perform printing.
#2. How to print all sheets on Excel file
Beside Print multiple sheets on Excel at the same time, you can do it Print all sheets in Excel Easily.
Perform:
+ Step 1: Right-click any sheet => and select Select All Sheet to select all sheets on the Excel file.
+ Step 2: Then press the key combination Ctrl + P to open the window Print. Here, you can see all the sheets have been selected.
To make printing according to your needs, you can set it up in the section Settings => and click Print to print, or press Enter to print in the default order of the sheets.
# 3. Epilogue
Okay, so I have detailed instructions for you How to print multiple sheets in Excel, or print all the sheets on the Excel file to help you be more convenient in your work.
Well, here comes the tutorial on how to improve printing in Excel and I would like to pause. Hope this tip will be helpful in your work.
Good luck !
CTV: Luong Trung - Blogchiasekienthuc.com
Note: Was this article helpful to you? Do not forget to rate the article, like and share it with your friends and relatives!
0 Comments