• Skip to main content
  • Skip to secondary menu
  • Skip to primary sidebar

Mechanicaleng blog

siemens nx tutorial & injection molding technology

  • Plastic molding
  • Siemens nx
    • nx modeling
    • nx drafting
    • nx sketching
    • nx assembly
  • Mechanical basic
    • mechanical standard
    • Mechanism video
  • microsoft office
    • microsoft word
    • powerpoint
    • excel tips
  • About me
  • CONTACT ME
Home » microsoft office » excel tips » How to print multiple sheets in Excel?

How to print multiple sheets in Excel?

February 28, 2021 by mechanicaleng blog Leave a Comment

Actually,printing document is the result of your work. With excel, you can print the entire work sheet, specific area you need on a work sheet, multiple sheets, or all sheets.  If you are new member, may be you do not know how to print it. So, today, I will guide to you how to print multiple sheets, all sheets in Excel? It is very easy and simple.

Post contents

  • I. How to print multiple sheets in Excel?
  • II. How to print all sheets in Excel?
  • III. How to set up printing multiple sheets with specific area?

I. How to print multiple sheets in Excel?

+ Step 1: Open your excel file you want to print. If you have many sheet in your file but you do not print all the sheets. The first, move all sheets you need to print to the left of the bar for selecting easily.  And select all sheets you want to print. To select sheet, hold Ctrl key and left click sheet one by one.

For this example, we will select sheet 1,2,3

print multiple sheets all sheets in Excel 1

+ Step 2: Click  File =>  Print. At the settings list, select print active sheets option.
print multiple sheets all sheets in Excel 2+ Step 3: Click on print.

print multiple sheets all sheets in Excel 3

II. How to print all sheets in Excel?

Step 1: Open your file that you want to print. Click file -> print. At the settings list -> Select Print Entire Workbook.

print all sheets in Excel 4

Step 2: Click Print.

III. How to set up printing multiple sheets with specific area?

If you want to printing multiple sheets with specific area at each sheet, the first, you have to set print area manually at each sheet.

  1. Select the cells that you want yo setup printing area at each sheet.
  2. Click Page layout tab -> Print area -> set print area

set print area

After you set print area, you can do same method I. How to printing multiple sheets in Excel.

I have just guided in great detail with you how to print multiple Sheets in Excel file 
Good luck!

Related posts:

Create border in excel by border tool2 ways to create border in excel How to count blank cells in excelHow to count and color blank cells in excel Header and Footer in the ExcelHow to insert header and footer in excel? change cell background color automatically in excelchange cell background color in excel by equal formulas

Filed Under: excel tips Tagged With: excel beginner, excel tutorial

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Recent Posts

  • what is spur gear | introduction
  • Mechanical engineering skills from training process
  • What is Inox | Stainless Steel?
  • How to create thread in nx
  • nx assembly| create a new part from the same part
  • how to calculate sum of squares in Excel
  • How to active GC toolkits in Siemens NX
  • How to create a sphere in nx
  • How to create a cone in nx
  • How to create a cylinder in nx

Copyright © 2023 · Magazine Pro on Genesis Framework · WordPress · Log in