Printing Worksheets with Current Options

After you’ve entered all of your data and formatted your worksheets so the data is easy to read, you can print your worksheets for distribution to your colleagues, for example. Opening the File menu, pointing to Print, and clicking Quick Print prints only the worksheet displayed on the screen—if you want to print more than one worksheet at a time, such as when you want to print out several months of sales results and each month is recorded on a separate worksheet, you can do that as well.

Print Multiple Worksheets from the Same Workbook

  1. Hold down the Ctrl key and click the sheet tabs of the worksheets you want to print.

  2. Click the Microsoft Office button.

  3. Point to Print.

  4. Click Quick Print.

    Print Multiple Worksheets from the Same Workbook

    Tip

    Tip

    If all of the worksheets in a workbook are adjacent, click the sheet tab for the first worksheet, hold down the Shift key, and click the sheet tab for the last worksheet. Click the Quick Print button on the Quick Access Toolbar to print all of the selected worksheets.

    Caution

    Caution

    If you drag a column marker so far to the left that you overlap with or pass over another column marker, the column you are adjusting will be hidden from view.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
13.59.158.151