• Ablebits blog
  • Excel print

How to print Excel spreadsheet: tips and guidelines for perfect printouts

Svetlana Cheusheva

Learn how to print Excel spreadsheets exactly the way you want - print selection, sheet or entire workbook, on one page or multiple pages, with proper page breaks, gridlines, titles, and a lot more.

Living in a digital world, we still need a printed copy every now and then. At first sight, printing Excel spreadsheets is super easy. Just click the Print button, right? In reality, a well-organized and beautifully formatted sheet that looks great on a monitor is often a mess on a printed page. This is because Excel worksheets are designed for comfortable viewing and editing on screen, not to fit on a sheet of paper.

This tutorial aims to help you get perfect hard copies of your Excel documents. Our tips will work for all versions of Excel for Office 365, Excel 2019, Excel 2016, Excel 2013, Excel 2010 and lower.

How to print Excel spreadsheet

For starters, we will provide high-level instructions on how to print in Excel. And then, we will have a closer look at the most important and useful features.

To print an Excel worksheet, this is what you need to do:

  • In your worksheet, click File > Print or press Ctrl + P . This will get you to the Print Preview window.
  • In the Copies box, enter the number of copies you want to get.
  • Under Printer , choose which printer to use.
  • Under Settings , specify exactly what to print and configure the page margins, orientation, paper size, etc.

Printing an Excel spreadsheet

Choose what to print: selection, sheet or entire workbook

Below you will find a brief explanation of each setting shown in the screenshot above and how to correctly use them.

Print selection / range

Print entire sheet(s).

To print the entire sheet that you currently have open, pick Print Active Sheets .

Print entire workbook

Print excel table, how to print the same range in multiple sheets.

When working with identically structured worksheets, such as invoices or sales reports, you will obvious want to print the same rage in all the sheets. Here's the fastest way to do this:

  • Open the first sheet and select the range to print.
  • Click Ctrl + P and choose Print Selection in the drop-down list right under Settings .
  • Click the Print button.

Tip. To set the print area in multiple sheets, you can use these Print Area macros .

How to print Excel spreadsheet on one page

By default, Excel prints sheets at their actual size. So, the bigger your worksheet, the more pages it will take. To print an Excel sheet on one page, choose one of the following Scaling options that reside at the end of the Settings section in the Print Preview window:

  • Fit Sheet on One Page – this will shrink the sheet so that it fits on one page.
  • Fit All Columns on One Page – this will print all the columns on one page while the rows may be split across several pages.
  • Fit All Rows on One Page – this will print all the rows on one page, but the columns may extend to multiple pages.

If the Adjust To number is low, a printed copy will be difficult to read. In this case, the following adjustments might be useful:

  • Change page orientation . The default Portrait orientation works well for worksheets that have more rows than columns. If your sheet has more columns than rows, change the page orientation to Landscape .
  • Adjust margins . The smaller the margins, the more room there will be for your data.
  • Specify the number of pages . To print an Excel spreadsheet on a predefined number of pages, on the Page tab of the Page Setup dialog, under Scaling , enter the number of pages in both Fit to boxes (wide and tall). Please note that using this option will ignore any manual page breaks .

Print to file – save the output for later use

Print to File is one of the most rarely used Excel print features underestimated by many. In short, this option saves output to a file instead of sending it to a printer.

Why would you want to print to file? To save time when additional printed copies of the same document are needed. The idea is that you configure the print settings (margins, orientation, page breaks, etc.) only once and save the output to a .pdf document. Next time you need a hard copy, simply open that .pdf file and hit Print .

Let's have a look at how that works:

  • On the Page Layout tab, configure the required print settings and press Ctrl + P .
  • In the Print Preview window, open the Printer drop-down list, and select Print to File .

Print preview in Excel

It's always a good idea to preview outputs before printing to avoid unexpected results. There are a couple of ways to access print preview in Excel:

  • Click File > Print .
  • Press the print preview shortcut Ctrl + P or Ctrl + F2 .

Excel Print Preview is an extremely helpful tool in terms of saving your paper, ink and nerves. It not only shows exactly how your worksheets will look on paper, but also allows making certain changes directly in the preview window:

  • To preview the next and previous pages , use the right and left arrows at the bottom of the window or type the page number in the box and hit Enter . The arrows only appear when a selected sheet or range contains more than one printed page of data.
  • To display page margins , click the Show Margins button in the bottom-right corner. To make the margins wider or narrower, simply drag them using the mouse. You can also adjust the column width by dragging the handles at the top or bottom of the print preview window.
  • Though Excel Print Preview does not have a zoom slider, you can use a common shortcut Ctrl + scroll wheel to do a little zooming . To get back to the original size, click the Zoom to Page button in the lower-right corner.

Excel print options and features

Apart from configuring page margins and paper size, here you can insert and remove page breaks, set print area, hide and show gridlines, specify the rows and columns to repeat on each printed page, and more.

Dialog launcher

Note. The Page Setup dialog box can also be opened from the Print Preview window. In this case, some of the options, for example Print area or Rows to repeat at top , may be disabled. To enable these features, open the Page Setup dialog from the Page Layout tab.

Excel print area

To ensure that Excel prints a specific part of your spreadsheet and not all the data, set the print area. Here's how:

  • Select one or more ranges that you want to print.

The Print Area setting is saved when you save the workbook. So, whenever you print this particular sheet, a hard copy will only include the print area.

How to add a print button to Excel Quick Access Toolbar

If you frequently print in Excel, it may be convenient to have the Print command on the Quick Access Toolbar . For this, just do the following:

  • Click the Customize Quick Access Toolbar button (the down arrow at the far-right of the Quick Access toolbar).

How to insert page breaks in Excel

When printing a huge spreadsheet, you can control how the data is split over multiple pages by inserting page breaks. Here's how it works:

  • Click on the row or column that you want to move to a new page.
  • On the Page Layout tab, in the Page Setup group, click Breaks > Insert Page Break .

If you'd like to change the position of a certain page break, move it wherever you want by dragging the break line.

How to print formulas in Excel

To get Excel to print formulas instead of their calculated results, you just need to show formula in a worksheet, and then print it as usual.

How to print a chart in Excel

Tips and notes:

  • To print all the contents of a sheet including the chart, press Ctrl + P without selecting anything on the sheet, and make sure the Print Active Sheets option is chosen under Settings .
  • It's not possible to adjust the scaling of a chart in the Print Preview window. If you wish the printed chart to fit the full page , resize your graph to make it bigger.

How to print gridlines in Excel

By default, all worksheets are printed without gridlines. If you want to print Excel spreadsheet with lines between your cells, here's what you need to do:

  • Switch to the Page Layout tab.

How to print titles in Excel

In a multi-page Excel sheet, understanding what this or that data means can be tricky. The Print Titles feature lets you show the column and row headers on every printed page, which will make reading a printed copy a lot easier.

To repeat header row or header column on every printed page, carry out these steps:

  • On the Page Layout tab, in the Page Setup group, click Print Titles .
  • On the Sheet tab of the Page Setup dialog box, under Print titles , specify which rows to repeat at top and/or which columns to repeat at left.

How to print comments in Excel

In case your notes are no less important than the spreadsheet data, you may want to get comments on paper too. For this, do the following:

  • On the Page Layout tab, in the Page Setup group, click the dialog launcher (a small arrow in the lower-right corner of a group).
  • In the Page Setup window, switch to the Sheet tab, click the arrow next to Comments and choose how you want them printed:

Print comments in Excel.

How to print address labels from Excel

You may also be interested in.

  • How to insert header and footer in Excel sheets
  • How to add a watermark in Excel
  • How to add leading zeros
  • How to insert page numbers in Excel

Table of contents

Ablebits.com website logo

12 comments

print worksheet in excel

Is there a way in Excel to print two different cell ranges of same sheet i.e. A1 to G30 in potrait form (1st option) & A1 to Z30 in Landscape Form (2nd Option).

print worksheet in excel

When printing my 2 page spreadsheet, page 2 does not print starting at the top of the page but halfway down towards the middle. How do I remove all this extra space? There are no hidden or added blank rows. I have added and removed a page break. I also moved page 2 to another tab, it still prints starting halfway down the page. Any help would be so appreciated.

print worksheet in excel

This is great, something I knew how to do 22 years ago in Excel and haven't had to until now. You've got to love these forums for assistance.

print worksheet in excel

Is there a way to ensure those printing preferences selected & saved in a soft copy file, will work when other users open the same file. We are trying to excel for a company wide document, I have set all of the printing preferences, margins, headers / footers, page breaks, orientations etc etc etc and when others open the same file, none of those settings are present.

print worksheet in excel

Good day, I have set my margins all 4 sides to zero, still my print leaves a larger margin to the right, I am loosing that space, which end up in more pages. Please help. Thanx.

print worksheet in excel

I tried to print my worksheet in excel format but the printout appears plain without the chart it was looking as if the job was done on Microsoft Word. I need you to guide me on the right step

print worksheet in excel

My sheet prints with huge right margin, squeezing the sheet to the left and unreadable. Something is overwriting the steps I set according to your instructions.

print worksheet in excel

Hi! You may have activated the Fit Sheet on One Page option. Your table is too large for one page.

print worksheet in excel

Thank you for your great blog post. In this article, you provide website for print on demand and the best practice tools.

print worksheet in excel

Great post, I really like the way to describe Printing and design, thank you for sharing blog all the Ideas and resources from the conference.

print worksheet in excel

how can i print in one shot for different criteria in one sheet

like 1. apple 12 27/03/2021 2. apple 13 27/03/2021 3. apple 14 27/03/2021 4. orange 15 27/03/2021 5. orange 16 27/03/2021 now i want without any selection i want print for seperately apple and orange in one shot.

regards samarpan

print worksheet in excel

Was Helpful. Thank you

Post a comment

#1 Excel tutorial on the net

Print a Worksheet   |  What to Print   |  Multiple Copies   |  Orientation   |  Page Margins   |  Scaling

This chapter teaches you how to print a worksheet and how to change some important print settings in Excel.

Print a Worksheet

To print a worksheet in Excel , execute the following steps.

1. On the File tab, click Print.

2. To preview the other pages that will be printed, click 'Next Page' or 'Previous Page' at the bottom of the window.

Excel Print Preview

3. To print the worksheet, click the big Print button.

Click the big Print Button

What to Print

Instead of printing the entire worksheet, you can also print the current selection.

1. First, select the range of cells you want to print.

2. Next, under Settings, select Print Selection.

Print Selection

3. To print the selection, click the big Print button.

Note: you can also print the active sheets (first select the sheets by holding down CTRL and clicking the sheet tabs) or print the entire workbook. Use the boxes next to Pages (see first screenshot) to only print a few pages of your document. For example, 2 to 2 only prints the second page.

Multiple Copies

To print multiple copies, execute the following steps.

1. Use the arrows next to the Copies box.

2. If one copy contains multiple pages, you can switch between Collated and Uncollated. For example, if you print 6 copies, Collated prints the entire first copy, then the entire second copy, etc. Uncollated prints 6 copies of page 1, 6 copies of page 2, etc.

Multiple Copies

Orientation

You can switch between Portrait Orientation (more rows but fewer columns) and Landscape Orientation (more columns but fewer rows).

Landscape Orientation

Page Margins

To adjust the page margins, execute the following steps.

1. Select one of the predefined margins (Normal, Wide or Narrow) from the Margins drop-down list.

2. Or click the 'Show Margins' icon at the bottom right of the window. Now you can drag the lines to manually change the page margins.

Adjust Page Margins

If you want to fit more data on one page, you can fit the sheet on one page. To achieve this, execute the following steps.

1. Select 'Fit Sheet on One Page' from the Scaling drop-down list.

Fit Sheet on One Page

Note: you can also shrink the printout to one page wide or one page high. Click Custom Scaling Options to manually enter a scaling percentage or to fit the printout to a specific number of pages wide and tall. Be careful, Excel doesn't warn you when your printout becomes unreadable.

1/9 Completed! Learn much more about printing > Go to Next Chapter: Share

Learn more, it's easy

  • Workbook Views
  • Page Breaks
  • Headers and Footers
  • Page Numbers
  • Print Titles
  • Center on Page
  • Print Gridlines & Headings

Next Chapter

Follow excel easy.

Excel Easy on Facebook

Become an Excel Pro

  • 300 Examples

Print • © 2010-2024 Popular Excel Topics: Pivot Tables • Vlookup • Formulas • Charts • Conditional Formatting

How to Print an Excel Spreadsheet on One Page (+ More)

Trying to fit your big spreadsheet into 1 tiny page?

As easy as it seems, printing Excel spreadsheets can be difficult if you don’t know the pro tricks. And even more so if you’re new to this software.

Luckily, this guide has everything you need to know about printing Excel spreadsheets. We’ve jotted down some of the most important Excel techniques to help you get started 😃

So without further ado, let’s get right into it.

Also, if you want to practice along the guide, download our sample workbook here .

Table of Contents

How to print an Excel sheet on one page

How to print the entire workbook, how to change the print area, how to print comments, frequently asked questions.

Sometimes we just want to squeeze all our data on one page to avoid extra mess. But by default, Excel prints multiple pages for data that can easily show up on a single page.

Not only does this lead to wastage of paper, but managing so many hard copies can be a true hassle.

This is why people prefer accommodating most of their data on a single page. And if you don’t have extensive data or readability issues, this is the ideal approach.

Let’s suppose we have some data set, and we want to print it on one page 📄

So to print the Excel sheet on one page:

  • Click Print from the File Tab.
  • The Print Preview screen shows up.

The Print Preview screen gives you an idea of how your data will look on a printed page. Our printed page is in Portrait orientation and spread over two pages.

If you prefer, you can change the page orientation from the print settings shown above. Or the Page Layout Tab from the ribbon.

If you have columns to print, choose Landscape. And if the data consists of more rows (like in our case), choose Portrait.

To fit all the rows on one page, we will scale it accordingly.

  • Click the ‘No Scaling’ option at the bottom.
  • Select ‘Fit All Rows on One Page.’
  • Excel shows the preview as:

All your data will now be printed on a single piece of paper 📝

Note that scaling an Excel sheet on one page can make the printout hard to read.

We just saw how to print the Excel spreadsheet on a single page. Now, let’s see how to print the entire workbook in one go.

It’s quite straightforward. All you need to do is:

  • Go to ‘Print” from the File Tab.
  • `Click ‘Print Active Sheets’ in the Print Preview area.
  • Select ‘Print Entire Workbook.’

Excel will now print the entire workbook when you click Print.

You can select other options too. For instance, if you only want to print a specific selection in the sheet, click ‘ Print Selection .’ And if you want to print the Excel worksheet, select the ‘ Print Active Sheets ‘ option.

As evident from the name, the Print Area lets you choose a specific portion of the spreadsheet that you want to print.

This is because often, we don’t want to print the entire sheet but only some part of it. The Print Area feature can help you do just that. And its working is similar to that of Print Selection under the Print Settings.

To enable the Print Area:

  • Select the data you want to print.

We want to print the first ten rows of our data set:

  • Go to the Page Layout Tab.
  • Select Print Area under the Page Setup group.
  • Click ‘Set Print Area.’

And it’s done! 🥳

Excel will now only print the selected data. You can view the Print Area in the Print Preview window as well 🗔

You can also choose whether you want to show the gridlines for printing or not. For that, select the ‘Print’ option under Gridlines from the Sheet Options group.

Excel will now print the gridlines as well. You can view them from the Preview window.

You can also add a new print area to your previous selection. All you need to do is select the new range and press Print Area.

Then select the ‘Add to Print Area’ option.

The selected portion is now added to the Print Area 📃

Similarly, if you want to remove it, click Clear Print Area. Excel will remove the entire Print Area.

If your comments are just as important as your worksheet data, know that you can print them too. The process takes a few seconds only and is easy to understand 😃

To print Excel comments:

  • Open the Page Setup dialog box (from the small arrow at the right corner)
  • Click the Sheet tab.
  • Click the drop-down arrow next to Comments and select an option.

You can now see how the comments will appear on paper in the Print preview window 📄

Just scroll down or move to the next page to view them.

That’s it – Now what

Printing spreadsheets in Excel can be tricky, especially when you have large data to print. But using these new techniques, you will be able to wind that hours-long task in minutes.

Summing up, we learned how to print an Excel sheet on one page in this article. We also saw how to print comments, the entire workbook, and even change the Print Area.

Knowing how to print Excel spreadsheets is pretty important when working in a professional environment. But so are the other things in this giant spreadsheet software that you need to learn!

If you are just starting out, we recommend you practice the Excel VLOOKUP, IF, and SUMIF functions. Enroll in my 30-minute free email course  that teaches these functions and much more for FREE! 😵

Other resources

These printing tips and tricks are sure to give a boost to your Excel skills. All you need is constant practice and more knowledge.

If you enjoyed this article, we’re sure you’d love to know more. Try reading How to Print Gridlines ,  Mailing Labels , and more.

How to fit an excel sheet on one page?

To fit an Excel sheet on one page, go to  File Tab  >  Print . Click the  No Scaling option  at the bottom. Select ‘ Fit Sheet on one Page ‘ from the drop-down. Excel will shrink the printout to fit one page. You can also set custom scaling options to keep the data legible.

How to print a selected area in Excel?

To print a selected area in Excel, open the  Print  option from the  File Tab . Under Settings, click  Print Active Sheets . Select ‘ Print Selection ‘ from the drop-down menu. Excel will now only print the range you have selected in the worksheet.

How to clear the print area in Excel?

Clearing the Print Area in Excel is easy. Select  Print Area  under the Page Setup group from the Page Layout Tab and click  Clear Print Area . Excel will remove the entire Print Area.

GCFGlobal Logo

  • Get started with computers
  • Learn Microsoft Office
  • Apply for a job
  • Improve my work skills
  • Design nice-looking docs
  • Getting Started
  • Smartphones & Tablets
  • Typing Tutorial
  • Online Learning
  • Basic Internet Skills
  • Online Safety
  • Social Media
  • Zoom Basics
  • Google Docs
  • Google Sheets
  • Career Planning
  • Resume Writing
  • Cover Letters
  • Job Search and Networking
  • Business Communication
  • Entrepreneurship 101
  • Careers without College
  • Job Hunt for Today
  • 3D Printing
  • Freelancing 101
  • Personal Finance
  • Sharing Economy
  • Decision-Making
  • Graphic Design
  • Photography
  • Image Editing
  • Learning WordPress
  • Language Learning
  • Critical Thinking
  • For Educators
  • Translations
  • Staff Picks
  • English expand_more expand_less

Excel Tips  - 5 Tips for Printing Excel Spreadsheets

Excel tips  -, 5 tips for printing excel spreadsheets, excel tips 5 tips for printing excel spreadsheets.

GCFLearnFree Logo

Excel Tips: 5 Tips for Printing Excel Spreadsheets

Lesson 24: 5 tips for printing excel spreadsheets.

/en/excel-tips/concatenate-excels-duct-tape/content/

5 tips for printing Excel spreadsheets

So you've made an Excel workbook full of data. It's well organized, it's up to date, and you've formatted it exactly like you want, so you decide to print out a hard copy … and it looks like a mess.

Excel worksheets don't always look great on paper because they're not designed to fit on a page—they're designed to be as long and wide as you need them to be. This is great for editing and viewing on screen, but it does mean your data might not be a natural fit to a standard sheet of paper.

However, this doesn't mean it's impossible to make an Excel worksheet look good on paper. In fact, it's not even that difficult. The following tips for printing in Excel should work the same way in Excel 2007, 2010, 2013, 2016, and 2019.

1. Preview your worksheet before you print

You can see exactly how your worksheet will look on the printed page by using the Print Preview feature. In terms of saving you time and paper, Print Preview is your most valuable printing tool. You can even make certain changes within it, like clicking on and dragging the print margins to make them wider or narrower. Check it as you change printing and layout options to make sure your spreadsheet looks the way you want it to look.

show margins button in Microsoft Excel Print Preview

2. Decide what you're going to print

If you only need to look at a certain segment of your data, don't bother printing your entire workbook—just print the specific data. You can print just the worksheet you're viewing by going to the print pane and selecting Print Active Sheets , or you can select Print Entire Workbook to print the entire file. You can also print a small segment of your data by selecting the data, then choosing Print Selection in the print options.

Print selection in Microsoft Excel Print Preview

3. Maximize your space

You're limited by the dimensions of the paper you're printing on, but there are ways to make the most of this space. Try changing the page orientation. The default orientation is good for data with more rows than columns, but if your worksheet is wider than it is tall, change the page orientation to landscape. Still need more room? You can change the width of the margins on the edge of your paper. The smaller they are, the more room there is for your data. Finally, if your worksheet isn't huge, try playing with the Custom Scaling Options to fit all of your rows, columns, or entire worksheet on one sheet of paper.

4. Use Print Titles

Once your Excel sheet is more than one page long, understanding what you're looking at can get tricky. The Print Titles command lets you include a title row or column on each page of your spreadsheet. The columns or rows you select will show up on every page of your printout, which makes reading your data a lot easier.

5. Use page breaks

If your worksheet takes up more than one sheet of paper, consider using page breaks to decide exactly which data should be on which page. When you insert a page break into your worksheet, everything below the break is moved to a different page than everything above it. This is useful because it lets you break up your data exactly the way you want.

Following these tips will go a long way toward making your printed worksheets easier to read. For more printing tips and detailed instructions for the tips listed above, review our Printing Workbooks lesson.

previous

/en/excel-tips/how-to-use-fractions-in-excel/content/

print worksheet in excel

How to Print in Excel

  • October 24, 2022
  • Spreadsheet Basics
  • Ryan Morton

This article will show you how to print a worksheet in Excel. We will also cover how to adjust some important print settings as well.

How to Print a Worksheet

To print a worksheet in Excel, follow the steps listed below.

In the Excel Ribbon, go to  File > Print . You can also use the keyboard shortcut  CTRL + P .

Click on the  Next Page  or  Previous Page  at the bottom of the window to preview all the pages that will print.

print worksheet in excel

When you are ready to print, click on the  Print  button.

print worksheet in excel

Adjusting the Settings

Here are some settings you might want to adjust when printing your worksheet.

Change What to Print

Instead of printing the entire worksheet, you can change the settings to print only a portion of it.

For example, here is how to only print a specific selection of cells.

Start by selecting the range of cells you would like to print.

print worksheet in excel

Next, go to File > Print  or use  CTRL + P . Then choose  Print Selection  under  Settings .

print worksheet in excel

Finally, click the  Print  button to print the selection.

Change the Orientation

You have the option to switch between Portrait Orientation and Landscape Orientation before you print.

print worksheet in excel

To change the orientation, click where it reads  Portrait Orientation  and change it to  Landscape Orientation .

print worksheet in excel

You can click this same button again to change it to  Portrait Orientation .

Adjust the Page Margins

To adjust the page margins, follow the steps listed below.

Click on the  Margins  button and select one of the predefined margins.

print worksheet in excel

If you would like to customize the margins even further, click on Custom Margins .

print worksheet in excel

You can now change any of the margins in the Page Setup dialog box. When you finish adjusting the margins, click  Ok .

print worksheet in excel

Change the Scaling

If you want to fit a worksheet with lots of data onto a single page, click on the button that reads  No Scaling .

print worksheet in excel

Change the scaling to  Fit Sheet on One Page  to print a single page with all the data.

print worksheet in excel

Note : Be careful when using this option. Excel does not warn you if the printed page is unreadable due to too much data.

Print Multiple Copies

To change how many copies are printed, adjust the number in the  Copies  box. You can also use the arrows to adjust the copy amount up or down.

print worksheet in excel

This Post Has 0 Comments

Leave a reply cancel reply.

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

Save my name, email, and website in this browser for the next time I comment.

Notify me of new posts by email.

This site uses Akismet to reduce spam. Learn how your comment data is processed .

Related Posts

print worksheet in excel

Test Your Spreadsheet Basics Knowledge

print worksheet in excel

Function Quiz – Select the Right Function

print worksheet in excel

Create a Chart in Google Sheets

  • previous post: Basic Spreadsheet Keyboard Shortcuts
  • next post: How to Print in Google Sheets

Privacy Overview

Spreadsheet Planet

How to Print Multiple Tabs/Sheets in Excel

Excel has the option to print the active sheet, any selection on the active sheets as well as the entire workbook.

But what if you want to print multiple sheets in Excel but don’t want to print the entire workbook?

Of course, you can choose to print one single sheet at one time and repeat the process, but you don’t have to.

There is a way to print multiple sheets/tabs in Excel (not the entire workbook) and even print the same selection of cells on multiple sheets.

Let me show you how!

Table of Contents

Print All Tabs/Sheets in the Workbook (Print Entire Workbook)

If you want to print all the worksheets in the active workbook, it’s pretty straightforward (the option is baked into Excel).

Here are the steps to print all the worksheets in the workbook:

  • Click the File tab and then click on the Print option. Alternatively, you can also hold the Control key and press the P key (or Command + P if you’re using a Mac)
  • In the Print Preview window that opens, in the Settings option, click on the Print Active Sheets option. This will show a drop-down with more options.
  • Select the ‘Print Entire Workbook’ option.

Select the Print Entire workbook option

  • Select the Printer from the drop-down.
  • Click the Print button.

print worksheet in excel

Print Multiple Sheets in Excel (But Not All)

Suppose you have five sheets in the Excel workbook, and you only want to print the first three (or any other combination of sheets).

Below are the steps to do this:

  • Select the sheets you want to print. To do this, hold the control key and then click on the tab where you have the sheet name.
  • Hold the Control key and press the P key (or Command + P if you’re using a Mac)
  • In the Print window that opens, under the Settings option, select Print Active Sheets.

print worksheet in excel

  • Select the Printer from the drop-down

That’s it!

This will print all the selected sheets, as now, Excel considers all the selected sheets as active sheets and uses all of them while printing.

Pro Tip : In case you have sheets that are not contiguous, you need to hold the Control key and then use the mouse to select the sheets. In case these sheets are contiguous (i.e., all adjacent to each other), you can hold the SHIFT key, click on the left-most sheet and the right-most sheet, and it will select all the ones in between as well.

Caution : When you select multiple sheets, these are grouped together. When sheets are grouped , any changes you make will be made to all the grouped sheets. So make sure you ungroup the sheets once you’re done with printing.

Print a Specific Selection on Multiple Sheets

In case you want to print multiple sheets in Excel, but not the entire worksheet – only a specific part, you can do that too.

Note that this would work only when you need to print the same range from all the selected sheets.

Below are the steps to print the same selection from multiple sheets:

  • Select all the sheets that you want to print. To do this, hold the Control key and select the sheets (or Command key if you’re using Mac)
  • In the active sheet, select the range of cells that you want to print
  • Hold the Control key and press the P key (or Command + P if using Mac)
  • In the Print window, under the Settings option, click and then select Print Selection

print worksheet in excel

  • Click on the Print button.

The above steps would only print the selected range of cells in the selected sheets.

VBA Code to Print Multiple Sheets in Excel

If you want to do the printing in Excel using a VBA, you can use the various codes provided in this section.

When you run any of the VBA macros covered below, it will send the worksheets to your default printer for printing.

VBA Code to Print Active Worksheet Only

The above VBA code would only print the active sheet (i.e. the tab that is active when running the code)

VBA Code to Print Entire Workbook

The above code would print all the sheets in the active workbook.

VBA Code to Print Specific Worksheets

In some cases, you may only want to print some of the sheets in your workbook.

In that case, you can use the VBA macro code given below, where I have specified the sheet names that I want to print.

Here, I’m printing Sheet1 and Sheet3. You can adjust the code by specifying the names of the sheets you want to print

VBA Code to Print Sheets with Specific Word/Phrase in the Tab Name

One useful scenario where VBA could be useful when printing sheets is when you want to print only those sheets that have specific words in the name.

For example, say I only want to print sheets where it has the word Sales in the name. The below VBA code would do that:

So these are the ways you can use to print multiple sheets in Excel. You can either use the inbuilt print options that are available in the print preview window, or the VBA macro codes.

I hope you found this tutorial useful!

You may also like the following Excel tutorials:

  • How to Center the Worksheet Horizontally on the Page in Excel
  • How to Print Row Numbers in Excel
  • 3 Ways to Duplicate Sheet in Excel
  • How To Make Excel Spreadsheet Bigger When Printing

' src=

Steve Scott

I am a huge fan of Microsoft Excel and love sharing my knowledge through articles and tutorials. I work as a business analyst and use Microsoft Excel extensively in my daily tasks. My aim is to help you unleash the full potential of Excel and become a data-slaying wizard yourself.

Leave a Comment Cancel reply

Save my name, email, and website in this browser for the next time I comment.

How to Print Excel Sheet on One Page (Fit to One Page)

If you often print your data/work in Excel, I am sure you have faced the issue where it prints multiple pages instead of one single page.

Sometimes, it’s so frustrating that a new page is printed just to accommodate a few extra lines of data (which also leads to wastage of paper).

There are some simple techniques you can use to make sure you Excel data in printed on one page (or in less number of pages in case you’re printing a big report).

In this Excel tutorial, I will share some methods you can use to print the Excel sheet on one page . You can use a combination of these methods to get the best result.

So let’s get started!

This Tutorial Covers:

Check How Many Pages Would be Printed (Preview)

Before you set out to optimize the settings to print the Excel work in one sheet, it’s best to check the current state using the Print Preview.

Don’t worry! You don’t have to print anything for this. You can simply check how the printed work would look and how many sheets will be printed.

This allows you to understand the things you can change to make sure you’re using the minimal number of paper while still keeping your printed report beautiful and legible.

Below are the steps to use Print Preview to see how the final print job would look like:

  • Click the File tab
  • Click the Print Option

Or you can use the keyboard shortcut Control + P (Command + P if using a Mac)

This would open the Print preview page where you would be able to see how many pages would be printed and what would be printed on each page.

You can use the arrow keys to go to the next/previous page when in the Print preview mode.

Ways to Fit and Print Excel Sheet in One Page

Now, let’s see some methods you can use to fit all the data in a sheet on one page and then print your report on one page (or fewer number of pages)

Adjust the Column Width (or Row height )

In many cases, you don’t need your columns to be too wide.

And since this is a direct determinant of how much data is printed on one page, you can save a lot of paper by simply reducing the column width.

But then, how do you know whether you have done enough or not? How do you know how much column width you should reduce to make everything fit on one page?

To make this easy, you can use the Page Layout View in Excel – which shows you in real-time how much data would be printed on each page of your report.

Below are the steps to get into the Page Layout mode and then reduce the column width:

  • Click the View tab in the ribbon

Once you have all the data on one page, you can go ahead and print it.

In some cases, you may find that the data in a cell is being cut off and is not being displayed completely. This often happens when you change the column width. You can correct this by enabling the Wrap text option in Excel .

To return to the normal view (and get out of the Page Layout view), click on the View tab and then click on ‘Normal’.

Change the Scaling (Fit All Rows/Columns in One Page)

Excel has an in-built option that allows you to rescale the worksheet in a way that fits more rows/columns on one page.

When you do this, it simply scales down everything to fit all the columns or rows in one page.

Suppose you have a sheet where the columns are spilling over to the next sheet when printed.

Below are the steps to scale down the sheet while printing:

  • Click on Print (or use the keyboard shortcut – Control + P)
  • In the Print window, click on the Scaling option (it’s the last option on the left)
  • Fit Sheet on One Page
  • Fir All Columns on One Page
  • Fit All Rows on One Page

The above steps would scale the sheet to fit the page (based on what options you have selected). You will also be able to see how the data would look in the sheet preview which is on the right.

This doesn’t impact the worksheet data. It only scales the data for print purposes.

Hide or Delete Rows/Columns

Another smart way to get everything on one page when printing is to hide any columns or rows that you don’t need.

You always have the option to make these visible again in case you need it later, but hiding these while printing will make sure you’re optimizing the space and using fewer pages to print.

To hide a row/column, simply select them, right-click and then select Hide.

Again, it’s best to first get into the Page Layout mode and then do this. This makes sure you can see how many rows/columns you need to hide to fit all the data on one page in Excel.

And here are steps to unhide the rows/columns in Excel .

Change the Page Orientation

If you have more columns and rows, it makes sense to change the orientation of the page while printing.

There are two Orientations in Excel;

  • Portrait (default in Excel) – More rows are printed than columns
  • Landscape – More columns are printed than rows

In case you have more columns than rows (as shown below), you can change the page orientation to Landscape to ensure your data fit and is printed on one page.

Below are the steps to change the page orientation in Excel:

  • Click the Page Layout tab
  • Click on the Page tab in the dialog box (if not selected already)

Now you can go to Print Preview and see how your printed report would look like.

The keyboard shortcut to open the Page Setup dialog box ALT + P + S + P (press these keys in succession)

Alternatively, you can also change the orientation in the Print Preview window, by selecting Landscape Orientation from the drop-down in the settings.

Change the Page Margins

Sometimes you just have one or two extra columns that are getting printed on a new page (or a few extra rows that are spilling to the next page).

A little adjustment in the Page margins may help you fit everything on a single page.

If you’re wondering what page margins are – when you print an Excel worksheet, every printed page would have some whitespace at the edges. This is by design to make sure the data looks good when printed.

You have the option to reduce this white space (the page margin) and fit more data on a single page.

Below are the steps to reduce the page margin in Excel:

  • In the Page Setup group, click on ‘Margins’
  • Click on Narrow

The above steps would reduce the page margin and you may see some extra rows/columns being squeezed on the same page.

In case you want to further reduce the page margin, click on the ‘Margins’ option in the ribbon, and then click on ‘Custom Margins’. This will open the Page Setup Dialog box where you can further adjust the margins.

Reduce the Font Size

Another simple way to quickly make some extra rows/columns (that are spilling to additional sheets when printed as of now) fit the same page can be by reducing the font size.

This can allow you to resize a few columns so that it fits one page when printed.

This can be useful when you have printed data that usually goes in the appendix – something you need to have but nobody reads or cares about it.

Print Selected Data only (or Set the Print Area)

Sometimes, you may have a large dataset, but you may not want to print all of it. Maybe you only want to print selected data.

If this is a one-off thing where you want to quickly print the selected data in the worksheet, you can do that using the below step:

  • Select the data that you want to print
  • Click on Print.

The above steps would only print the selected dataset.

Note that in case you selected a dataset that can’t be fit into a single plage when printed, it will be printed on multiple sheets. You can, however, change the scaling to ‘Fit Sheet on One Page’ to print selection on a single page.

The above method is good when you have to print the selected data once in a while.

But you need to print the same selection from multiple worksheets, it’s a better idea to set the print area. Once set, Excel would consider this Print Area as the part that is meant to print and would ignore the other data on the sheet.

Below are the steps to set the print area in Excel :

  • Select the data that you want to set as the print area
  • In the Page Setup group, click on the Print Area option
  • Click on Set Print Area

That’s it!

Now when you try and print a worksheet, only the print area would be printed (and only this will be shown in the Print Preview).

[Bonus] Add Page Breaks

In case you have a large dataset. it’s obvious that it can not be fit into one page and printing this entire data would take up multiple pages.

You can add page breaks in Excel to let Excel know where to stop printing on the current page and spill the rest to the next page.

Below are the steps to add page breaks in Excel:

  • Select the cell where you want to insert the page break . From this cell onwards, everything would be printed on the next page
  • In the Page Setup group, click on Breaks option
  • Click on Insert Page Breaks

The above steps would add a page break and everything before the page break would be printed in one sheet and the remaining data in other sheets.

Note that in case you have set the print area, it will take precedence over page breaks.

So these are various methods you can use to fit data into one page and print an Excel spreadsheet on one page. In cases where you have a lot of data, it may not make sense to print it on one page, but you can still use the above methods to minimize paper usage and fit the same data into fewer pages.

I hope you found this tutorial useful.

You may also like the following Excel tutorials:

  • How to Print Comments in Excel
  • How to Print the Top Row on Every Page in Excel
  • How to Print Multiple Sheets (or All Sheets) in Excel in One Go
  • How to Unhide COLUMNS in Excel
  • How to Group Worksheets in Excel
  • How to Compare Two Excel Sheets (for differences)

FREE EXCEL BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Leave a comment cancel reply.

BEST EXCEL TUTORIALS

Best Excel Shortcuts

Conditional Formatting

Excel Skills

Creating a Pivot Table

Excel Tables

INDEX- MATCH Combo

Creating a Drop Down List

Recording a Macro

© TrumpExcel.com – Free Online Excel Training

Privacy Policy  | Sitemap

Twitter | Facebook | YouTube | Pinterest | Linkedin

Setting Print Ranges For Multiple Worksheets In Excel

Key takeaway:.

  • Setting print ranges is essential for printing multiple worksheets in Excel, optimizing space utilization and minimizing paper usage.
  • Page Layout View is a powerful tool to view and adjust print ranges for multiple worksheets, customize print titles, and manage different print areas.
  • To troubleshoot common print range issues, users should adjust margins, scaling, and orientation, and be aware of common error messages. Clearing and removing print ranges can also help to address printing issues.

Are you trying to set print ranges for multiple worksheets in Excel, but not sure how? Look no further, this article will guide you through the process, enabling you to get the job done with ease.

Setting Print Ranges in Excel

Want to set print ranges for multiple worksheets in Excel? You’re in luck! There’re two sub-sections to help you out. “

  • How to Set Print Ranges for a Single Worksheet:
  • Ways to Set Print Ranges for Multiple Worksheets:

Read on and make printing your Excel sheets a breeze!

How to Set Print Ranges for a Single Worksheet

For a single worksheet, one can set print ranges easily. Print ranges are helpful for printing a specific area of the worksheet without including unnecessary information. Here’s how to do it:

  • Select the range that you want to print
  • Click on the ‘Page Layout’ tab and select ‘Print Area’
  • Select ‘Set Print Area’
  • To remove print range, click on ‘Page Layout’ tab > ‘Print Area’ > ‘Clear Print Area’

It is important to note that setting print ranges for each worksheet individually can be time-consuming. A more efficient approach is to repeat these steps for each worksheet or selecting multiple sheets while configuring print settings.

Setting up a correct print range can save ample amounts of paper and avoid long hours of manually hidden rows or columns. This also makes sure that every printed copy looks the same and doesn’t miss out on any vital detail.

My friend, who runs an accounting firm, had faced trouble with printing profit and loss sheets. The sheets used to appear cluttered with unnecessary data; which led him to spend more than two hours hiding rows, columns, and reprinting after every change in figures. I suggested he set a print range for the crucial checkboxes so that even when printed, they appear clear while getting rid of surplus information. Now, he spends less time preparing financial reports thanks to this simple solution.

Let’s face it, setting print ranges for multiple worksheets is like herding cats, but here are some helpful ways to keep the chaos under control.

Ways to Set Print Ranges for Multiple Worksheets

When it comes to managing and printing multiple worksheets in Excel, having the ability to set print ranges can save time and effort. Here’s how you can do it:

  • Open the Excel workbook that contains the multiple worksheets that you want to print.
  • In the worksheet that you want to print, select the cell or range of cells that you want to include in your printout.
  • Click on ‘Page Layout’ in the Ribbon.
  • Select ‘Print Area’ , followed by ‘Set Print Area’ from the dropdown menu.
  • Repeat steps 2-4 for each worksheet that you want to set a print range for.
  • To view and adjust your set print areas, click on ‘View’ in the Ribbon and then select ‘Page Break Preview’

It’s noteworthy that there are additional options available for specifying a column or row as a print range, which is useful when working with large data sets.

In my experience working with financial reports, I found setting a print range saved immense time when reporting monthly figures. Without much headache, I was able to customize my print ranges for multiple worksheets bearing intricately different formats. Why settle for one dimension when you can view your spreadsheet like it’s on a catwalk? Welcome to Page Layout View in Excel.

Using Page Layout View in Excel

Page Layout View in Excel with the title ‘Setting Print Ranges for Multiple Worksheets in Excel’ is essential. To use it effectively, view and adjust print ranges in Page Layout View without swapping between sheets. Additionally, set print titles so key info is present on every page.

Viewing and Adjusting Print Ranges in Page Layout View

Page Layout View in Excel refers to the working environment that allows users to view and make adjustments to page layout elements such as margins, headers, footers, and page orientation. This view also facilitates setting print ranges for multiple worksheets in Excel.

To view and adjust print ranges using Page Layout View, follow these 5 steps :

  • Open the workbook containing multiple worksheets
  • Click on the worksheet tab at the bottom of your screen to select it
  • Select the range of cells you want to print by dragging across them while holding down the left mouse button
  • Click on the ‘Page Layout’ tab on the ribbon at the top of your screen
  • click on ‘Print Area’ , then select ‘Set Print Area’

It is worth noting that this view allows you to preview what will be printed. You can adjust your print settings such as margins, page size, and scaling from this view.

The benefit of using Page Layout Views is that it provides more control over every printing aspect. It ensures a consistent look across all pages, especially when dealing with large sheets or worksheets.

Make sure your print titles aren’t as forgetful as Dory by setting them to repeat on every page.

Setting Print Titles to Repeat on Each Page

When preparing multiple worksheets for printing in Excel , it is important to ensure that print titles are repeated on each page for easy reference . Here’s how you can do it:

  • Click on the ‘Page Layout’ tab.
  • Select the ‘Print
  • In the Page Setup dialog box, go to the ‘Sheet’ tab.
  • Under ‘Rows to repeat at top’, select the rows you want to repeat on each printed page.
  • Under ‘Columns to repeat at left’, select the columns you want to repeat on each printed page.

By following these steps, your selected rows and columns will be repeated on each printed page, providing a consistent reference point throughout your document.

It is important to note that when selecting rows or columns to repeat, you should avoid including any header or footer information as this will already be included in those sections of your document.

Did you know that Excel was first introduced by Microsoft back in 1985? Since then, it has become one of the most widely used spreadsheet programs in both personal and professional settings.

Why settle for one print area when you can have multiple? Excel is like a buffet, take as much as you want (or need)!

Managing Multiple Print Areas in Excel

Manage multiple print areas in Excel with ease! Know about dividing print areas for different worksheets . Clear or delete the print ranges. Two subsections under the managing multiple print areas section will take care of your needs.

Separating Print Areas for Different Worksheets

When managing print areas in Excel, it’s important to set separate print ranges for multiple worksheets. This ensures a more organized and efficient printing process.

To exemplify this concept, let’s create an illustrative table using the relevant data. In the given table, the first column displays the worksheet name, the second one represents the print area range, and the third column indicates any notes or comments that may be necessary for reference:

It’s crucial to note that having different print areas for each worksheet allows customization and eliminates any chances of confusion during the printing process.

It’s worth understanding that having unique print areas helps in maintaining coherence between similar worksheets while allowing individuality.

In history, businesses primarily relied on traditional printing methods without realizing their inefficiency. However, by separating print areas in Excel, businesses can now save time and costs while increasing their productivity levels.

You can’t keep your print ranges clutter-free without a little Excel-lence in clearing and removing them.

Clearing and Removing Print Ranges in Excel

To eliminate designated print areas in Excel, you can clear and remove them. This will result in the entire worksheet being printed or newly assigned print areas.

  • To erase a specified print area from a single worksheet, open the Page Layout tab and select Print Area from the Page Setup section.
  • Click on Clear Print Area to delete any assigned print ranges.
  • If you need to remove the print range from several worksheets simultaneously, choose the first worksheet and then press CTRL + left-click for additional selections.
  • Select Page Layout > Print Area > Clear Print Area to erase all corresponding worksheet’s print ranges.
  • Verify that all worksheets now have only one explicit untitled printing range if you want to use new ones.

Alternatively, pressing "Remove Print Range" allows you to extract print areas that have already been set up on an Excel sheet.

Consider reviewing your intangible printer settings if certain rows or columns do not show and initiate caution as removing online printing setups could impact other sheets unintentionally.

“I faced an enormous amount of confusion when I had trouble with my Excel’s printing setup. It caused me significant delays, I spent hours trying to correct it myself until someone else explained it differently.”

Save time, paper, and sanity by printing multiple worksheets at once – because who has time to hit the print button 50 times?

Printing Multiple Worksheets at Once

In Excel, learn about printing multiple worksheets at once with selected print ranges . Check out the sub-sections: “ Printing Selected Worksheets in Excel ” and “ Previewing and Printing Multiple Worksheets in Excel “. These’ll provide solutions to make your printing quicker. No more printing worksheets one by one!

Printing Selected Worksheets in Excel

When printing multiple worksheets together, selecting the specific ones requires a different approach. This can be done easily by setting print ranges for selected worksheets in Excel.

Here are 4 steps to help you Print Selected Worksheets in Excel :

  • Select the specific worksheets to be printed by holding down the ‘Ctrl’ key and clicking on each sheet tab.
  • Click on File > Print and select ‘Print Active Sheets’ or ‘Print Entire Workbook’.
  • In ‘Settings’, choose the page orientation, paper size, and scaling options to fit the print preferences.
  • Press ‘Print’ to execute a combined print job of selected worksheets.

It is important to note that you can only select contiguous sheets for this method. Non-adjacent sheets require a different process of selecting print area individually across multiple pages.

For better organization and effective viewing, setting up proper page breaks in each worksheet can prevent information from overlapping onto other pages while printing.

Don’t miss out on saving time when navigating through large data sets or numerous reports. Follow these easy steps and ensure correct excel printing etiquette today!

Get ready to hit print like it’s going out of style with these preview and printing tips for your multiple Excel worksheets.

Previewing and Printing Multiple Worksheets in Excel

For those seeking how to print multiple worksheets at once, Excel offers a useful solution. This feature is essential for users who deal with large data sets and want to avoid the hassle of printing each table separately.

To preview and print multiple worksheets in Excel, follow these four simple steps:

  • Select the worksheet tab or tabs you want to print.
  • Click on ‘Page Layout’.
  • Select ‘Print Area’, then choose ‘Set Print Area.’ The selected area will appear as a light blue outline.
  • Select ‘Print Preview’ to review your selection before printing.

It’s important to note that setting up page margins and adjusting page orientation should be done before following these steps.

Excel also allows for custom range selections if users prefer greater control over their printing. By double-clicking the border surrounding the set print area, it’s possible to adjust the range manually.

For optimal results, consider making use of printer-friendly formatting options such as removing grid lines or centering data in cells. By doing so, users can ensure their printed output looks clean and professional.

Why fix print range issues in Excel when you can just blame it on Mercury being in retrograde?

Troubleshooting Print Range Issues in Excel

Wanna troubleshoot print range issues in Excel?

Here are some steps to follow:

  • Set different print ranges for multiple worksheets .
  • Adjust margins, scaling, and orientation .
  • To fix common error messages, ya gotta know ’em. Examples are: “ Print Area is Empty ,” “ Margins Too Large ,” and “ Prints Must Be Contiguous “.

Adjusting Margins, Scaling, and Orientation for Print Ranges

When preparing to print ranges in Excel, it’s essential to adjust the margins, orientation, and scaling of your document. These elements can affect the overall appearance of your printed document and must be reviewed before printing. Here’s how to do it:

  • Open Microsoft Excel and select the worksheets you want to print.
  • Click on File then choose Print Preview to visualize your current settings
  • Select Page Setup to access layout options for adjusting margins and orientation.
  • Use the Scale box under Page Layout to control page size when printed by percentages.
  • Select Fit All Columns/Rows on One Page or Adjust To Number Of Pages options for optimizing scaling
  • Once all changes have been made click on Print and choose your printer

While adjusting these settings, watch out for discrepancies between rows or columns fitting on a single page – this is important in keeping consistency across your documents . In certain instances, decreasing margin space will be necessary.

In 2006, an internal memo from Microsoft advised employees against using certain ink colors so that their documents could be more accessible and readable in black-and-white copies. This shows how even small adjustments play a significant role in the effective presentation of documents.

Error messages in Excel are like my ex: they never make sense and always cause frustration, but with a little patience and Google search, they can be fixed.

Common Error Messages and How to Fix Them

When experiencing issues with print ranges in Excel, it can be frustrating to encounter error messages. However, there are solutions for these common problems.

  • Incorrect Print Range – Double-check that the print range is correct and covers all necessary cells.
  • Print Area is Not Set – Set the desired area to be printed by selecting the cells and going to Page Layout > Print Area > Set Print Area .
  • Empty Rows or Columns – Remove empty rows or columns that may interfere with printing by selecting them and right-clicking > Delete .
  • Merge Cells – Unmerge any merged cells as they can cause confusion for printers by selecting them and going to Home > Alignment > Merge & Center > Unmerge .
  • Paper Size Mismatch – Make sure the selected paper size matches the actual paper being used in your printer settings.
  • Incomplete Data – If data is cut off in printing, adjust column widths, reduce margins or try adjusting page orientation.

It’s important to also note that having a clear understanding of how print range works can prevent future issues such as overlapping text or missing data. By following these suggestions, you can ensure efficient printing processes.

Five Facts About Setting Print Ranges for Multiple Worksheets in Excel:

  • ✅ Setting print ranges allows you to print only specific parts of your workbook. (Source: Microsoft)
  • ✅ You can select multiple worksheets and set print ranges for all of them at once. (Source: Excel Easy)
  • ✅ You can also customize the print settings for each worksheet, such as orientation and scaling. (Source: Excel Campus)
  • ✅ The print area that you set is saved with the workbook, so you don’t have to set it every time you print. (Source: Ablebits)
  • ✅ Setting print ranges for multiple worksheets can save time and paper when printing large workbooks. (Source: Spreadsheet Planet)

FAQs about Setting Print Ranges For Multiple Worksheets In Excel

What is the process for setting print ranges for multiple worksheets in excel.

The process for setting print ranges for multiple worksheets in Excel involves selecting the worksheets for which you want to set print ranges, selecting the print area for each worksheet, and then grouping the worksheets together to print as a single document.

Can I set different print ranges for each worksheet?

Yes, you can set different print ranges for each worksheet. Simply select the worksheet, select the print area, and then repeat the process for each additional worksheet.

What is the benefit of setting print ranges for multiple worksheets?

The benefit of setting print ranges for multiple worksheets is that it allows you to print a single document that includes data from multiple worksheets. This can save time and make it easier to share data with others.

Is it possible to adjust print ranges after they have been set?

Yes, you can adjust print ranges after they have been set. Simply select the worksheet and the print range you wish to adjust, and then modify the range as needed.

What happens if I accidentally print a worksheet that is not part of the group?

If you accidentally print a worksheet that is not part of the group, it will print as a separate document. To avoid this, make sure you have properly selected and grouped all of the desired worksheets before printing.

Can I save the print ranges for future use?

Yes, you can save the print ranges for future use. Simply set the print ranges as desired, and then save the file. When you open the file again, the print ranges will be saved with the document.

Javatpoint Logo

  • Web Services
  • Interview Q

MS Excel Tutorial

Excel worksheet, excel calculation, excel fill handle, excel formula, excel advanced, shortcut keys.

Interview Questions

JavaTpoint

  • Send your Feedback to [email protected]

Help Others, Please Share

facebook

Learn Latest Tutorials

Splunk tutorial

Transact-SQL

Tumblr tutorial

Reinforcement Learning

R Programming tutorial

R Programming

RxJS tutorial

React Native

Python Design Patterns

Python Design Patterns

Python Pillow tutorial

Python Pillow

Python Turtle tutorial

Python Turtle

Keras tutorial

Preparation

Aptitude

Verbal Ability

Interview Questions

Company Questions

Trending Technologies

Artificial Intelligence

Artificial Intelligence

AWS Tutorial

Cloud Computing

Hadoop tutorial

Data Science

Angular 7 Tutorial

Machine Learning

DevOps Tutorial

B.Tech / MCA

DBMS tutorial

Data Structures

DAA tutorial

Operating System

Computer Network tutorial

Computer Network

Compiler Design tutorial

Compiler Design

Computer Organization and Architecture

Computer Organization

Discrete Mathematics Tutorial

Discrete Mathematics

Ethical Hacking

Ethical Hacking

Computer Graphics Tutorial

Computer Graphics

Software Engineering

Software Engineering

html tutorial

Web Technology

Cyber Security tutorial

Cyber Security

Automata Tutorial

C Programming

C++ tutorial

Control System

Data Mining Tutorial

Data Mining

Data Warehouse Tutorial

Data Warehouse

RSS Feed

Excel Dashboards

Excel Tutorial: How To Print Selected Worksheets In Excel

Introduction.

Are you struggling to print specific worksheets in Excel? Being able to select and print only the necessary worksheets can save time and resources. In this tutorial, we will show you how to print selected worksheets in Excel in just a few simple steps. Whether you're a beginner or a pro, this tutorial will help you streamline your Excel printing process.

Key Takeaways

  • Being able to print specific worksheets in Excel can save time and resources
  • Understanding the purpose of using multiple worksheets in a workbook is important for efficient printing
  • Selecting and customizing print settings for specific worksheets is crucial for a professional-looking printout
  • Previewing and checking the layout before printing helps to ensure accuracy and quality
  • Mastering the skill of printing selected worksheets in Excel can streamline your printing process and improve organization

Understanding Excel Worksheets

In Microsoft Excel, a worksheet is a single spreadsheet within a workbook, where you can perform calculations, analyze data, and create visual representations of your information.

A. Define what worksheets are in Excel

Worksheets are the primary components of a workbook and are composed of cells organized in rows and columns. Each worksheet can hold an immense amount of data and can be customized to suit the needs of the user.

B. Explain the purpose of using multiple worksheets in a workbook

Multiple worksheets can be included in a single workbook to organize and segregate different sets of data. This is particularly useful for individuals who need to work with various datasets or conduct different analyses within the same excel file.

C. Emphasize the need to print specific worksheets as opposed to the entire workbook

Printing specific worksheets from a workbook can save time and resources, especially when dealing with larger datasets. Instead of printing the entire workbook, users can choose to print only the necessary worksheets that contain relevant information.

Selecting Worksheets to Print

When it comes to printing in Excel, you may not always want to print every single worksheet in your workbook. Fortunately, Excel makes it easy to select specific worksheets to print.

To select a specific worksheet to print, simply right-click on the worksheet tab at the bottom of the Excel window and choose "Select." You can also hold down the Ctrl key while clicking on multiple tabs to select multiple worksheets.

1. Using the Ctrl Key

As mentioned above, you can hold down the Ctrl key while clicking on multiple worksheet tabs to select multiple worksheets at once.

2. Using the Shift Key

If you want to select a continuous group of worksheets, you can click on the first worksheet tab, hold down the Shift key, and then click on the last worksheet tab in the group.

1. Organize your worksheet tabs

Keep your workbook organized by renaming and color-coding your worksheet tabs. This will make it easier to identify and select the desired worksheets for printing.

2. Use the Ctrl key to deselect worksheets

If you accidentally select a worksheet that you don't want to print, you can hold down the Ctrl key and click on the tab of the selected worksheet to deselect it.

Adjusting Print Settings

Printing selected worksheets in Excel requires adjusting print settings to ensure that only the desired content is included in the printout. Here's a step-by-step guide to customize your print settings:

To access print settings in Excel, click on the "File" tab in the upper-left corner of the Excel window. From the dropdown menu, select "Print" to open the print settings panel. Here, you can preview how the worksheets will appear when printed and make adjustments accordingly.

Once in the print settings panel, you can customize various options such as page orientation, paper size, margins, and scaling. You can also choose to print the entire workbook, active sheets, or selected sheets. Additionally, you can adjust the print area to include only specific cells or ranges.

Specifying the print area is crucial when printing selected worksheets in Excel. This ensures that only the relevant content is included in the printout, avoiding unnecessary waste of paper and ink. By defining the print area, you can control exactly which data will be printed, improving the efficiency and clarity of your printed documents.

Previewing and Checking the Layout

Before printing selected worksheets in Excel, it's important to preview and check the layout to ensure that the printout looks professional and accurate. This step is crucial for avoiding any potential errors and making any necessary adjustments before printing.

Show how to preview the selected worksheets before printing

Before printing, it's essential to preview the selected worksheets to see how they will appear on the printed page. This can be done by going to the "File" tab, clicking on "Print," and selecting "Print Preview." This allows you to see exactly how the selected worksheets will look when printed and make any necessary adjustments.

Discuss the importance of checking the layout for any adjustments needed

Checking the layout before printing is important to ensure that all the content is displayed correctly and that there are no formatting issues. This includes verifying that the page breaks are in the right places, the headers and footers are correctly aligned, and the margins are set appropriately. Making these adjustments before printing can save time and resources in the long run.

Offer tips for ensuring the printout is accurate and professional-looking

To ensure that the printout is accurate and professional-looking, it's essential to pay attention to details such as the page orientation, scaling options, and print area. Additionally, double-check the print settings to make sure they are configured correctly for the selected worksheets. It's also a good idea to proofread the content for any errors and ensure that the layout is visually appealing.

Printing the Selected Worksheets

Printing only the necessary worksheets in Excel can save time and resources. This tutorial will guide you through the process of selecting and printing specific worksheets within your Excel workbook.

A. Step-by-step guide for printing the selected worksheets

1. Open your Excel workbook and navigate to the bottom of the screen where the worksheet tabs are located.

2. Hold down the Ctrl key on your keyboard and click on the tabs of the worksheets you want to print. This will select multiple worksheets at once.

3. Once you have selected the desired worksheets, go to the File menu and select Print. Alternatively, you can use the keyboard shortcut Ctrl + P to open the Print dialog box.

4. In the Print dialog box, review the print settings and adjust them as needed. You can preview the selected worksheets by clicking on the Print Preview option.

5. After reviewing the settings, click on the Print button to print the selected worksheets.

B. Additional options or settings that may be useful for the printing process

1. Print Selection: If you only want to print a specific range of cells within the selected worksheets, you can use the Print Selection option. Simply highlight the cells you want to print before opening the Print dialog box, and then choose the Print Selection option to only print the highlighted area.

2. Page Setup: To further customize the print settings, you can use the Page Setup option in the Print dialog box. Here, you can adjust the paper size, orientation, margins, and other layout options to optimize the printed output.

C. Benefits of being able to print only the necessary worksheets

  • Time-saving: By printing only the necessary worksheets, you can avoid wasting time and resources on unnecessary printouts.
  • Cost-effective: Reducing the amount of paper and ink used for printing can lead to cost savings, especially in a business or office environment.
  • Eco-friendly: Printing only what is needed helps minimize paper waste and contributes to environmental sustainability.

In conclusion, this tutorial covered the key points of how to print selected worksheets in Excel, including selecting specific worksheets, setting print area, and adjusting print settings. By following these steps, you can easily print only the necessary worksheets and save time and paper.

We encourage readers to practice this skill in Excel to become more efficient in their work. By mastering this technique, you can maintain a more organized and professional-looking spreadsheet. Not only will this save time, but it will also improve the overall appearance and clarity of your documents.

Excel Dashboard

Immediate Download

MAC & PC Compatible

Free Email Support

Related aticles

Excel Tutorial: What Does #### Mean In Excel

Excel Tutorial: What Does #### Mean In Excel

Understanding Mathematical Functions: How To Call A Function In Vba

Understanding Mathematical Functions: How To Call A Function In Vba

Understanding Mathematical Functions: How To Add Function In Google Sheets

Understanding Mathematical Functions: How To Add Function In Google Sheets

Understanding Mathematical Functions: How To Fill In A Table Using A Function Rule

Understanding Mathematical Functions: How To Fill In A Table Using A Function Rule

Understanding Mathematical Functions: What Are The Basic Functions Of A Cell

Understanding Mathematical Functions: What Are The Basic Functions Of A Cell

Making Write 15 Minutes On A Timesheet

Making Write 15 Minutes On A Timesheet

Making Identify Sheet Sizes

Making Identify Sheet Sizes

Mastering Formulas In Excel: What Is The Formula For Standard Deviation

Mastering Formulas In Excel: What Is The Formula For Standard Deviation

Mastering Formulas In Excel: What Is The Formula Of Force

Mastering Formulas In Excel: What Is The Formula Of Force

Mastering Formulas In Excel: What Is Net Present Value Formula

Mastering Formulas In Excel: What Is Net Present Value Formula

Mastering Formulas In Excel: How To Write Formula In Google Docs

Mastering Formulas In Excel: How To Write Formula In Google Docs

Mastering Formulas In Excel: How To Do A Formula In Google Sheets

Mastering Formulas In Excel: How To Do A Formula In Google Sheets

  • Choosing a selection results in a full page refresh.

How-To Geek

How to use take in excel to extract data.

Extract specific data from your Excel table.

Quick Links

Prepare your table in excel, how to use take to extract the first and/or last rows and/or columns in excel, how to use take to extract a specific column in excel, how to use take with average in excel.

Excel's TAKE function will let you extract the first, last, or specific columns or rows from a table. For example, you might want to extract the data from the last three days or display the top ranked individuals. Let's look into this in more detail.

Excel's TAKE function only works in Microsoft 365 or Excel for the web.

Before you can use TAKE and CHOOSE, you will need to format and name your table . We will use this table of data as our example:

Data unformatted-2

Ensure you have included a row that includes headings for your columns. Now, select any cell within your table and click "Format As Table" in the "Styles" group of the "Home" tab.

Excel sheet with the 'Format As Table' option highlighted.

Click your preferred layout and, in the dialog box that opens, check "My Table Has Headers" and click "OK".

Now that Excel recognizes your data as a formatted table, you need to change the table name (for later use). In the "Table Design" tab on the ribbon, head to the "Properties" group and change the "Table Name" field to one that works for you.

Excel sheet highlighting where the table name can be amended.

You're now ready to extract data.

Excel's TAKE function is mostly used to extract the first or last few rows or columns from your table. The formula you'll need to use is:

=TAKE(X,Y,Z)

where X is the table name, Y is the number of rows to extract, and Z is the number of columns to extract. Simply place a "-" in front of Y or Z to change that part of the formula from the first rows or columns to the last rows or columns.

If the number of rows or columns that you want to extract might change, instead of typing digits for Y and Z, you can place the number in another cell and type the appropriate cell reference.

In our example, we want to find out the names of the top five employees based on profit per month.

First, create a place on your worksheet where you want the data to be extracted, and type an appropriate header. In our case, we've chosen cell J2 and the header "Top 5."

Excel sheet with a table of data and a place for our first formula to be inserted.

Second, start to type the formula as follows:

The next part of your formula is the table name. Begin typing the name of your table in your formula, and then double-click when you see it appear in the suggestions box. Then, add a comma.

Excel sheet with the first part of the TAKE formula typed into a cell and the table name appearing as an option to include within the formula.

=TAKE(Employees,

You now need to tell Excel how many of the first or last rows you want to include in your extracted data. In our case, we want the top five employees. Therefore, we type "5" and add a comma. If we wanted the last five rows, we'd type "-5". To extract all rows, simply don't include the number, and add the comma.

=TAKE(Employees,5,

Finally, finish your formula by telling Excel how many of the first or last columns you want to include. We'll go for just the first column, as we want only the employees' names, and close the parentheses and press Enter. Again, type "-" if you want to extract the last x columns. To extract all columns, miss out the number and press Enter.

=TAKE(Employees,5,1)

You will now see the desired outcome. Now, if you change or reorder the data in your table, the TAKE formula you have just added will automatically adjust to extract the updated information. For example, we want to reorder the column containing profit per month:

Excel sheet showing the result of using the TAKE formula in conjunction with an ordered column of data in the table.

If you were to add more data to your table, the TAKE formula would account for this. For example, if we added another employee's data to the bottom of the table in an additional row (by dragging the corner handle of the table downwards one row and completing their figures), the TAKE formula would include this when looking for the criteria you set.

If you want to extract a specific column, follow the steps above but add the column name to your formula in place of the number of columns .

Let's say that, in our example above, we need to work out how many months each of the five longest serving employees have been at the company. This would be our formula:

=TAKE(Employees[Months of service],5)

where "Employees" is the table's name, "[Months of service]" is the column name (notice the lack of a comma in between these two parts of the formula), and "5" is the number of rows we want to extract from the named column. Remember to filter the corresponding column in your table.

Excel sheet showing the length of the longest five payrolls using TAKE and a named column within the formula.

If you want to use TAKE with Excel's AVERAGE function , follow the steps above but nest the TAKE formula within your AVERAGE formula .

For example, let's say we want to work out the average earnings of the top five employees. This would be our formula:

=AVERAGE( TAKE(Employees,5,-1) )

where the AVERAGE formula surrounds the TAKE formula, which includes "Employees" (table name), "5" (we want to take the top 5 rows), and "-1" (we want to take the last column).

Excel sheet with the top five average calculated through the AVERAGE and TAKE functions being used together.

You now have a fundamental understanding of how the TAKE formula works in Excel. You can now go one step further—extract columns or rows from multiple ranges by using Excel's VSTACK and HSTACK functions , or combine TAKE with Excel's SORTBY function to see it work without you sorting your table's columns. Finally, you can use Excel's DROP function, which excludes certain cells and rows from your extracted data and works with exactly the same syntax as the TAKE function.

print worksheet in excel

Set or clear a print area on a worksheet

If you print a specific selection on a worksheet frequently, you can define a print area that includes just that selection. A print area is one or more ranges of cells that you designate to print when you don't want to print the entire worksheet. When you print a worksheet after defining a print area, only the print area is printed. You can add cells to expand the print area as needed, and you can clear the print area to print the entire worksheet.

A worksheet can have multiple print areas. Each print area will print as a separate page.

Note:  The screen shots in this article were taken in Excel 2013. If you have a different version your view might be slightly different, but unless otherwise noted, the functionality is the same.

What do you want to do?

Set one or more print areas, add cells to an existing print area, clear a print area.

On the worksheet, select the cells that you want to define as the print area.

Tip:  To set multiple print areas, hold down the Ctrl key and click the areas you want to print. Each print area prints on its own page.

On the Page Layout tab, in the Page Setup group, click Print Area , and then click Set Print Area .

Set Print Area

Note:  The print area that you set is saved when you save the workbook.

To see all the print areas to make sure they’re the ones you want, click View > Page Break Preview in the Workbook Views group. When you save your workbook, the print area is saved too.

Top of Page

You can enlarge the print area by adding adjacent cells. If you add cells that aren’t adjacent to the print area, Excel creates a new print area for those cells.

On the worksheet, select the cells that you want to add to the existing print area.

Note:  If the cells that you want to add are not adjacent to the existing print area, an additional print area is created. Each print area in a worksheet is printed as a separate page. Only adjacent cells can be added to an existing print area.

On the Page Layout tab, in the Page Setup group, click Print Area , and then click Add to Print Area .

Add to Print Area

When you save your workbook, the print area is saved as well.

Note:  If your worksheet contains multiple print areas, clearing a print area removes all the print areas on your worksheet.

Click anywhere on the worksheet for which you want to clear the print area.

On the Page Layout tab, in the Page Setup group, click Clear Print Area .

Clear print area

Need more help?

You can always ask an expert in the Excel Tech Community  or get support in  Communities .

Facebook

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

print worksheet in excel

Microsoft 365 subscription benefits

print worksheet in excel

Microsoft 365 training

print worksheet in excel

Microsoft security

print worksheet in excel

Accessibility center

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

print worksheet in excel

Ask the Microsoft Community

print worksheet in excel

Microsoft Tech Community

print worksheet in excel

Windows Insiders

Microsoft 365 Insiders

Was this information helpful?

Thank you for your feedback.

print worksheet in excel

Future-Proof Your Career, Master Data Skills + AI

print worksheet in excel

How to a Take Screenshot in Excel: A Guide for Windows & Mac

by Enterprise DNA Experts | 9:16 pm EST | February 15, 2024 | Excel

How to a Take Screenshot in Excel: A Guide for Windows & Mac

As a data analyst or a spreadsheet enthusiast, you’re probably familiar with the many ways Excel can make your life easier.

Knowing how to take a quick screenshot in Excel is a gamechanger.

The best part? It’s easy.

To take a screenshot in Excel, go to the  Insert  tab on the ribbon, click on the  Screenshot  icon in the  Illustrations  group, and choose either  Screen Clipping  or  Available Windows .

Screen Clipping will allow you to select and capture a specific part of your screen, while Available Windows will let you capture one or more open windows or applications.

But wait, there’s more.

In this article, we’ll take a closer look at how to take screenshots in both Windows and Mac versions of Excel, along with some other tips to enhance your Excel experience.

Let’s dive in!

How to Take Screen Shot in Excel

Table of Contents

How to Use the Screenshot Tool in Excel

Microsoft Excel offers a powerful screenshot tool that allows you to easily capture and insert images of other windows, including other Office applications like Word or PowerPoint.

To use the screenshot tool in Excel, follow the steps below:

Open your Excel file and navigate to the tab where you want to insert the screenshot.

Click on the  Insert  tab on the ribbon.

In the  Illustrations  group, click on the Screenshot button.

Insert a Screenshot

You’ll see two options:  Screen Clipping  and  Available Windows .

– Screen Clipping  allows you to capture a specific portion of your screen, including any open windows or applications.

– Available Windows  allows you to capture an image of any open Windows or applications.

Excel ScreenShot Choices

If you choose the Screen Clipping option, Excel will minimize, and your screen will be temporarily overlaid with a transparent layer. Simply click and drag your left mouse button to select the area you want to capture.

Taking a Screenshot

Once you release the mouse button, the selected area will be inserted as a picture in your Excel sheet.

Screenshot in Excel

If you choose  Available Windows, Excel will display a list of all the currently open windows or applications. Simply click on the window you want to capture, and it will be inserted as a picture in your Excel sheets.

By using the screenshot tool, you can easily capture and insert images of other windows, making it a valuable feature for creating dynamic and visually appealing spreadsheets.

How to Take Screenshots With the Camera Tool In The Excel

The Camera tool is another great way to take screenshots in Excel . The best part about this tool is that it takes “linked” screenshots.

This means that if you update your Excel spreadsheet after taking the screenshot, the change will be reflected in the screenshot no matter where it is in your workbook. Here’s how you can use it:

Step 1: Add the Camera Tool to the quick Access bar:

Navigate to Excel’s Quick Access toolbar

Click on the Customize Toolbar Icon and select More Commands.

Customize Toolbar options

In the dialog box that pops up, set the dropdown box to All Commands to display all the commands available.

Select Camera from the list, click on Add and click Ok .

Add Camera

Step 2: Take the Screenshot

Highlight the area of your Excel screen that you want to capture.

Click on the camera Icon on the top toolbar to capture the image.

Using the Camera

Step 3: Paste the Screenshot

Navigate to the area where you want to paste the screenshot and click on it.

The screenshot will be pasted there.

Linked Screenshot

You can also right-click on the screenshot, copy it, and paste it into other apps like Word, PowerPoint, WordPress, etc.

You can check out this article for more helpful Excel commands.

Note: Once you paste these images outside Excel, they won’t be linked screenshots again. They will turn to static images.

Now, let’s check out the copy tool.

How to Take Screenshots in Excel With the Copy Tool

Excel offers another awesome feature called the Copy as Picture tool for taking screenshots.

With it, you can take a snapshot of a range of cells in your spreadsheet, just like with the Camera tool.

However, the main difference between the Copy as Picture tool and the Camera tool is that the former doesn’t produce linked Screenshots.

So, if you update the cells after taking a screenshot, it will not reflect in the screenshot.

Here’s how you can use the Copy as Picture tool to take a screenshot in Excel:

Highlight the range of cells you want to screenshot.

Select the Copy as Picture option from the Excel toolbar.

Copy As Picture

A small window will come up. For the appearance, select As Shown on Screen and for the File Format, select Bitmap

Picture Options

Navigate to where you want to put the screenshot in on your Workbook and click paste

You can also paste you screenshot in a PowerPoint or Word document.

Pasting in Word Document

How to Take Screenshots in Excel on Mac

If you are a Mac user and looking for ways to take screenshots in Excel, you can use the built-in macOS screenshot tools to capture screenshots in Excel.

Press  Command + Shift + 4  to capture a selected area or  Command + Shift + 3  to capture the entire screen.

After taking the screenshot, the image will be saved on your desktop with a name like  Screenshot 2022-11-01 at 14.29.59 .png.

You can then insert the screenshot into your Excel worksheet by dragging and dropping the image from your desktop or using the Insert menu.

If you want to edit the screenshot, you can open it in Preview or any other image editing application and make the necessary adjustments before inserting it into your Excel workbook.

How to Take Excel Screenshots with Microsoft Snip & Sketch

Microsoft Snip & Sketch is a versatile and user-friendly tool that is perfect for taking screenshots in Excel too.

It offers various screenshot modes, such as full-screen capture, rectangular snip, and freeform snip, giving you the flexibility to capture your desired Excel content.

To take a screenshot in Excel using Microsoft Snip & Sketch , follow these steps:

Open Excel and go to the worksheet you want to capture.

Press the Windows + Shift + S keyboard shortcut. This will open the Snip & Sketch tool.

Choose your desired snipping mode:

Rectangular Snip: Click and drag to create a rectangular snip around the content you want to capture.

Freeform Snip : Click and drag to create a freeform snip around the content you want to capture.

Full-Screen Snip: Capture the entire screen.

Snip and Sketch Options

Once you’ve captured the snip, it will be copied to your clipboard. You can then paste the screenshot into your Excel worksheet or any other application by pressing Ctrl + V.

Alternatively, you can save the snip as an image file. To do this, click the Save button in the Snip & Sketch window and choose a location to save the image.

With these steps, you can easily take screenshots in Excel using Microsoft Snip & Sketch. This tool is a convenient and effective way to capture your Excel content for sharing, analysis, or documentation.

Final Thoughts

Capturing screenshots in Excel is an essential skill for anyone working with data and spreadsheets.

With this knowledge, you can effortlessly create visually appealing reports, presentations, and documents by incorporating relevant images and data from Excel and other applications.

By following the steps outlined in this article, you can quickly master this skill and enhance your Excel proficiency. Happy screenshotting!

Looking for a new data analytics platform? Here’s all you need to know about the all-new Microsoft Fabric.

Frequently Asked Questions

How to save a screenshot in excel.

To save a screenshot in Excel, first capture the desired screenshot using the Snipping Tool, Snip & Sketch, or the Print Screen feature. Save the screenshot and then use the Save As function to store it in your desired location on your computer.

For screenshots taken with Excel tools like the Camera and Copy as picture tools, Excel doesn’t offer a way to save them directly. To save these screenshots, you have to copy them into a Word or PowerPoint document, then use the Save as Picture option to save them to your desired location.

How to capture a screenshot of a cell in Excel?

To capture a screenshot of a cell in Excel, you can use the Snipping Tool or the Snip & Sketch tool. Open the tool and select the cell or range of cells you want to capture. Save the screenshot and then insert it into your Excel worksheet.

How to capture a screenshot of a chart in Excel?

To capture a screenshot of a chart in Excel, you can use the Snipping Tool or the Snip & Sketch tool. Open the tool and select the chart you want to capture. Save the screenshot and then insert it into your Excel worksheet.

How to take a screenshot of an entire worksheet in Excel?

To take a screenshot of an entire worksheet in Excel, you can use the Snipping Tool or the Snip & Sketch tool. Open the tool and select the entire worksheet. Save the screenshot and then insert it into your Excel worksheet.

You can also the Windows Print screen key to take the screenshot. To do this, just press the windows key plus the Print screen button:

Once you’ve taken the screenshot, it will be saved in your gallery.

print worksheet in excel

Related Posts

How to Interpolate in Excel: User Guide With Examples

How to Interpolate in Excel: User Guide With Examples

Excel , Power BI

In data analysis, interpolation plays a crucial role in estimating values that fall between known data...

How to Add Numbers in Excel: 3 Top Methods Explained

How to Add Numbers in Excel: 3 Top Methods Explained

One of the fundamental operations you perform in Excel is adding numbers. Whether you’re managing...

Excel Showing Formula Instead of Result? 5 Quick Fixes

Excel Showing Formula Instead of Result? 5 Quick Fixes

Have you ever found yourself in a situation where instead of showing the results of your calculations,...

How to Hard Code in Excel: 5 Easy Methods Explained

How to Hard Code in Excel: 5 Easy Methods Explained

Have you ever wanted to input a value into a cell in Excel and make sure that it remains unchanged, no...

How to Copy a Formula Down in Excel: A Quick Guide

How to Copy a Formula Down in Excel: A Quick Guide

Copying formulas down in Excel is a handy skill that can save you a lot of time and effort! Whether...

How to Remove Time from Date in Excel: 4 Quick Ways

How to Remove Time from Date in Excel: 4 Quick Ways

When you’re dealing with dates and times in Excel, you might find it necessary to separate the time...

How to Sum a Column in Excel: 5 Ways (Shortcut Included)

How to Sum a Column in Excel: 5 Ways (Shortcut Included)

One of the best things about Excel is how quickly and easily it can add up all the numbers in a column....

How to Calculate Skewness in Excel: Formulas Explained

How to Calculate Skewness in Excel: Formulas Explained

Do you want to calculate the skewness of your data to understand its distribution? Well, you're in the...

How to Remove Apostrophe in Excel: 4 Quick Ways

How to Remove Apostrophe in Excel: 4 Quick Ways

Apostrophes have their place in Excel; however, when not needed, they can clutter your data and make it...

How to Calculate Median in Excel: 3 Fast Methods

How to Calculate Median in Excel: 3 Fast Methods

When it comes to data analysis, having a solid grasp of the various statistical measures can make all...

How to Insert Calendar in Excel in 6 Simple Steps

How to Insert Calendar in Excel in 6 Simple Steps

Are you tired of manually entering dates in your Excel spreadsheets? You'll be happy to know that...

How to Add a Dollar Sign in Excel: 3 Best Ways Explained

How to Add a Dollar Sign in Excel: 3 Best Ways Explained

Cha-ching! Are you working with currencies or financial data? Either way, a dollar sign is essential to...

Are You Ready to Learn Real-World Data Skills & AI?

Access our FREE courses designed by data analytics experts!

IMAGES

  1. Printing in Excel: How to Configure Workbooks to Print

    print worksheet in excel

  2. Print The Selected Worksheet

    print worksheet in excel

  3. Print Worksheet in Excel

    print worksheet in excel

  4. How to Print Sheets in Excel (In Easy Steps)

    print worksheet in excel

  5. Print Setting in Excel

    print worksheet in excel

  6. How to Print a Worksheet with Comments in Excel

    print worksheet in excel

VIDEO

  1. Excel Printing. and Tutorials

  2. #1 page print in excel preview #Get 97 Excel automation templates to # Excel Report in 60 seconds

  3. 006 How to Print Worksheet Content (Punjabi)

  4. THE MS EXCEL WORKBOOK

  5. How to print Excel Worksheet or part of it

  6. Printing a Worksheet in Microsoft Excel

COMMENTS

  1. Print a sheet or workbook

    Print a sheet or workbook Excel for Microsoft 365 for Mac Excel 2021 for Mac Excel 2019 for Mac More... You can print entire or partial sheets and entire workbooks, one at a time or several at once. You can also print selections of several sheets at the same time.

  2. How to print Excel spreadsheet: tips and guidelines for ...

    To print an Excel worksheet, this is what you need to do: In your worksheet, click File > Print or press Ctrl + P. This will get you to the Print Preview window. In the Copies box, enter the number of copies you want to get. Under Printer, choose which printer to use.

  3. How to Print Sheets in Excel (In Easy Steps)

    To print a worksheet in Excel, execute the following steps. 1. On the File tab, click Print. 2. To preview the other pages that will be printed, click 'Next Page' or 'Previous Page' at the bottom of the window. 3. To print the worksheet, click the big Print button. What to Print

  4. Video: Print worksheets and workbooks

    Print Excel worksheets and workbooks one at a time, or several at one time. You can also print a partial worksheet, such as an Excel table. Print one or several worksheets Select the worksheets that you want to print. Click FILE > Print. You can also press Ctrl+P. Click the Print button, or adjust Settings before you click the Print button.

  5. Print a worksheet or workbook

    Select File, and then click Print. Under Settings, select the arrow next to Print Active Sheets and select the appropriate option. Select Print. Note: If a worksheet has defined print areas, Excel will print only those print areas. If you don't want to print only the defined print area, select the Ignore print area check box.

  6. How to Print an Excel Spreadsheet on One Page (+ More)

    To print Excel comments: Go to the Page Layout Tab. Open the Page Setup dialog box (from the small arrow at the right corner) Click the Sheet tab. Click the drop-down arrow next to Comments and select an option. Press Ok. You can now see how the comments will appear on paper in the Print preview window 📄.

  7. How to Print Excel Sheet

    In this step-by-step tutorial, learn how use Excel page setup and print. We cover how to print to one page, how to print your Excel sheet in A4 size full pag...

  8. Excel Tutorial: How To Print A Worksheet In Excel

    Follow these steps to print your Excel worksheet: A. Click on the "Print" button to send the worksheet to the printer. To print your worksheet, click on the "File" tab in the top left corner of the Excel window. Then, select the "Print" option from the dropdown menu. This will open the Print pane on the right-hand side of the screen. B. Wait ...

  9. Excel Tips: 5 Tips for Printing Excel Spreadsheets

    You can print just the worksheet you're viewing by going to the print pane and selecting Print Active Sheets, or you can select Print Entire Workbook to print the entire file. You can also print a small segment of your data by selecting the data, then choosing Print Selection in the print options. 3. Maximize your space

  10. Excel Tutorial: How To Print Worksheet In Excel

    Using the Print Preview feature. Step 1: Open the worksheet in Excel. Step 2: Click on the "File" tab in the top-left corner. Step 3: Select "Print" from the options on the left-hand side. Step 4: The print preview will appear, showing how the worksheet will look when printed. B. Checking for any issues.

  11. How to Print in Excel

    - Use Printing Options - Print worksheets, workbooks, and more - Print workbooks to a file - Print Selected Ranges - Print Formulas, Charts, Tables, and Gridlines - Print Titles for better documentation - Print Comments, Background, Header and Footer - Add Print Button in Excel ribbon And lastly, how to insert Page Break in Excel.

  12. How to Print in Excel

    How to Print a Worksheet. To print a worksheet in Excel, follow the steps listed below. In the Excel Ribbon, go to File > Print. You can also use the keyboard shortcut CTRL + P. Click on the Next Page or Previous Page at the bottom of the window to preview all the pages that will print. When you are ready to print, click on the Print button.

  13. Excel Tutorial: How To Print Worksheets In Excel

    Here's how you can access the print settings: A. Navigating to the File tab. Open the Excel workbook that contains the worksheet you want to print. Click on the "File" tab located in the top left corner of the Excel window. B. Selecting the Print option from the dropdown menu. Once in the File tab, select the "Print" option from the dropdown ...

  14. How to Print Multiple Tabs/Sheets in Excel

    Hold the Control key and press the P key (or Command + P if you're using a Mac) In the Print window that opens, under the Settings option, select Print Active Sheets. Select the Printer from the drop-down Click the Print button. That's it!

  15. Printing Selected Worksheets In Excel

    Select the worksheets you want to print by holding down the "CTRL" key and clicking the tab of each sheet you want to include. Navigate to the "Page Layout" tab and click on the "Print Area" option. Then, click on "Set Print Area." Click on "Print

  16. How to Print Excel Sheet on One Page (Fit to One Page)

    Click the File tab. Click on Print (or use the keyboard shortcut - Control + P) In the Print window, click on the Scaling option (it's the last option on the left) Click on any one of the options: Fit Sheet on One Page. Fir All Columns on One Page. Fit All Rows on One Page.

  17. Print Selected Worksheets on One Page in Excel & Google Sheets

    Right-click the sheet tabs and click Select All Sheets. This groups the worksheets together. Now, when you adjust any formatting or setup, it applies to all of the selected sheets instead of just one of them. Adjust the scaling as described above to fit one sheet wide and one sheet tall, or in Preview mode, to Fit Sheet on One Page.

  18. Print in Excel

    Print in Excel gives us an idea of the ways we can print the data from the worksheet in Excel, whether we want to print the entire worksheet, only a selected part of the worksheet, a dataset, or a cell range. We can open the Print option using the common way, i.e., " File - Print ", or using the shortcut keys "Ctrl+P".

  19. Video: Print worksheets and workbooks

    Click Print. To print the entire workbook, before you click Print, under Settings, click the arrow next to Print Active Sheets, click Print Entire Workbook. The print preview now shows the first page of the first worksheet, and Excel now tells you it'll print 28 pages. Click the Next Page arrow to view different pages, and click Print.

  20. Setting Print Ranges For Multiple Worksheets In Excel

    Open the Excel workbook that contains the multiple worksheets that you want to print. In the worksheet that you want to print, select the cell or range of cells that you want to include in your printout. Click on 'Page Layout' in the Ribbon. Select 'Print Area', followed by 'Set Print Area' from the dropdown menu.

  21. How to Change the Scale of a Worksheet in Excel

    If you want to print the entire worksheet, click the Print Area button again and select Clear Print Area. You can now print all of the worksheet. Changing the Scale of a Worksheet in Excel

  22. Print Worksheet in Excel

    Print Worksheet in Excel. MS Excel is powerful spreadsheet software that is widely used across the world. This is quite common when users share data from a spreadsheet or an entire workbook with others. Although there are many sharing options in Excel, there may be cases when we may need to print the data on paper to share with someone.

  23. Excel Tutorial: How To Print Selected Worksheets In Excel

    A. Step-by-step guide for printing the selected worksheets. 1. Open your Excel workbook and navigate to the bottom of the screen where the worksheet tabs are located. 2. Hold down the Ctrl key on your keyboard and click on the tabs of the worksheets you want to print. This will select multiple worksheets at once.

  24. How to Use TAKE in Excel to Extract Data

    Excel's TAKE function will let you extract the first, last, or specific columns or rows from a table. For example, you might want to extract the data from the last three days or display the top ranked individuals. ... First, create a place on your worksheet where you want the data to be extracted, and type an appropriate header. In our case, we ...

  25. Set or clear a print area on a worksheet

    What do you want to do? Set one or more print areas Add cells to an existing print area Clear a print area Set one or more print areas On the worksheet, select the cells that you want to define as the print area. Tip: To set multiple print areas, hold down the Ctrl key and click the areas you want to print. Each print area prints on its own page.

  26. gridline printing

    Print preview shows gridlines correctly after each row. Print-out shows gridlines only every other row. ... Excel Border print issues. by Shubro_paul on May 26, ... Excel worksheet Why won't my gridlines print. Have regular & double space gridlines printed . by gayescheffers375 on February 15, 2022. 673 Views

  27. How to a Take Screenshot in Excel: A Guide for Windows & Mac

    How to take a screenshot of an entire worksheet in Excel? To take a screenshot of an entire worksheet in Excel, you can use the Snipping Tool or the Snip & Sketch tool. Open the tool and select the entire worksheet. Save the screenshot and then insert it into your Excel worksheet. You can also the Windows Print screen key to take the screenshot.

  28. Vee_tech

    111 likes, 39 comments - vivien.oribhabor on January 29, 2023: " One of the most crucial task about a worksheet/workbook, is the Printing feature. Print ..." Vee_tech | Online Tutor | Excel Tips on Instagram: "🖨One of the most crucial task about a worksheet/workbook, is the Printing feature.