Home / Blog / How to Print a Specific Selection of Cells in Excel

How to Print a Specific Selection of Cells in Excel

Microsoft Excel Logo

Generally you need to print solely a selected choice of cells on a worksheet. However once you print in Microsoft Excel, all information on a worksheet is printed by default. This text will present two methods to print a specific vary.

Printing a Particular Collection of Cells in Microsoft Excel

This primary possibility is the quickest technique to print a specific vary of cells.

Choose and spotlight the vary of cells you need to print.

Selecting the range of cells to print

Subsequent, click on File > Print or press Ctrl+P to view the print settings.

Print settings in Excel

Click on the listing arrow for the print space settings after which choose the “Print Choice” possibility.

Print selection on a worksheet

The preview will now present solely the chosen space. Click on “Print” to complete the method.

Setting the Print Space in Microsoft Excel

In case you print the chosen space steadily, you’ll be able to set the chosen vary because the print space. This selection will prevent from needing to pick out the vary every time you print.

Choose the vary of cells you need to set because the print space. Subsequent, click on Web page Format > Print Space > Set Print Space.

Setting the print area

The print space is now set.

The following time you print (File > Print or press Ctrl+P), this space shall be printed by default.

To take away a print space, click on Web page Format > Print Space > Clear Print Space.

RELATED: Why Do You Want Formulation and Features?

About Alan Murray

Check Also

How to Clean Your Headphones and Earbuds

Evgeny Karandaev/Shutterstock So, you’ve cleaned your cellphone, keyboard, and mouse, however what about your headphones? …

Leave a Reply

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