Perform the Commands to Center the Selected Worksheets

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.

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.

Perform the Commands to Center the Selected Worksheets

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.

Perform the Commands to Center the Selected Worksheets

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.

Perform the Commands to Center the Selected Worksheets

After selecting the Select All Sheet option you will see all the worksheets of your workbook gets selected.

Perform the Commands to Center the Selected Worksheets

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.

Perform the Commands to Center the Selected Worksheets

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”.

Perform the Commands to Center the Selected Worksheets

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.

Perform the Commands to Center the Selected Worksheets

By scrolling on the previewed page or changing the page serial on the bottom you can see the preview of other worksheets.

Perform the Commands to Center the Selected Worksheets

Note: Don`t forget to select the Fit Sheet on One Page option if you see your data in a single worksheet gets scattered in different pages.

Conclusion

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.

Related Articles


Siam Hasan Khan on FacebookSiam Hasan Khan on Linkedin
Hello!

Welcome to my Profile. Here I will be posting articles related to Microsoft Excel. I have completed my BSc in Electrical and Electronic Engineering from American International University-Bangladesh. I am a diligent, goal-oriented engineer with an immense thirst for knowledge and attitude to grow continuously. Continuous improvement and life-long learning is my motto.

We will be happy to hear your thoughts

      Leave a reply