In many cases, after working with your Excel worksheets you may want some of the selected worksheets to be aligned in the center position of the pages while printing. In this article, we will perform the commands to center the selected worksheets while printing. We will use the Page Layout option to perform this task.
Suppose we have some worksheets with some product IDs and their monthly sales. While printing them we want some of these worksheets to be in the center position. To do that you need to perform some sequential task. These tasks are given below.
Table of Contents
Selecting Multiple Worksheets in Excel
Many of us might not know how we actually select multiple worksheets in Excel. Here I will be selecting 3 worksheets at a time which are Sheet1, Sheet2, and Sheet4. To do that, go to the bottom side of your workbook where the Sheets name is provided. By pressing the “Ctrl” button, select the worksheets Sheet1, Sheet2 and Sheet4 one by one.
As you can see, after selecting the worksheets, the worksheets name will glow in green bordered lines. Which will indicate that those worksheets are selected.
Selecting Sequential Worksheets in a Workbook
Now, if you want to select some sequential worksheets, first select the first worksheet of the sequence and then by pressing the Shift button of the keyboard to select the last worksheet of the sequence. Let`s say you want to select the worksheets Sheet1, Sheet2, Sheet3, and Sheet4. First, select the 1st worksheet of the sequence which is Sheet1 and by pressing the Shift button we have to select the Sheet4.
Selecting All the Worksheets in a Workbook
Most of the times you need to select all the worksheets while printing the whole workbook. For this, you have to select the option Select All Sheets. Press any worksheet of your workbook and by clicking the right button of the mouse and press on to the Select All Worksheets.
After selecting the Select All Sheet option you will see all the worksheets of your workbook gets selected.
Selecting Custom Margins from Excel Page Layout Tab
After selecting the worksheets, now select the Margins option from the Page Layout tab. In the Margins drop-down list, select the Custom Margins button.
After selecting the Custom Margins option, you will get the below dialogue box. This box is actually the Page Setup dialogue box where other options of Page Layout like Page, Header/Footer, and Sheet are given. From this dialogue box, you can customize your page for printing.
Customizing the Margins of Excel Worksheets
In the dialogue box of the Page Setup, do the following as the picture stated. Like, put tick marks on Horizontally and Vertically options and select different values of Top, Bottom, Left, Right, Header and Footer. Make sure you put same values for “Left & Right”, “Top & Bottom” and “Header & Footer”.
After doing these, press on to the Print Preview option. You will see the pages you want to print are being previewed sequentially from page 1.
By scrolling on the previewed page or changing the page serial on the bottom you can see the preview of other worksheets.
After reading this article I believe you will not face any difficulties while printing selected worksheets. Here we mainly perform the commands to center the selected worksheets while printing. This is an interesting method of printing Excel worksheets and this method may save your time while printing different Excel worksheets.
- How to Print An Excel Sheet on One Page
- How to Format an Excel Spreadsheet for Printing (10 Tips)
- How to Print Excel Spreadsheet with Grid Lines and Change its Color
- How to Make Excel Spreadsheet Bigger when Printing