How to Print a Selection in Excel: Your Ultimate 2024 Guide

Printing a selection in Excel is a handy skill to have when you only need to print a specific part of your spreadsheet. It’s easier than you might think! Just select the cells you want to print, go to the ‘Print’ menu, choose ‘Print Selection’, and voila – only your chosen cells will be printed.

Step by Step Tutorial: How to Print a Selection in Excel

Printing only a selected area in Excel is useful when you have a large spreadsheet but only need to print a portion of it. The following steps will guide you through the process.

Step 1: Select the Cells You Want to Print

Click and drag your mouse over the cells you want to print.

Selecting the cells is the most crucial step. Make sure you’ve included all the data you need because only the highlighted cells will be printed.

Step 2: Access the Print Menu

Press ‘Ctrl + P’ on your keyboard or click on ‘File’ and then ‘Print’.

This will bring up the Print menu, which is where you can control all of your printing options.

Step 3: Choose ‘Print Selection’

Under the ‘Settings’ section, click on the drop-down menu and select ‘Print Selection’.

This ensures that Excel knows you only want to print the cells you’ve selected and not the entire worksheet.

Step 4: Finalize Your Print Settings

Adjust any additional settings such as the number of copies, orientation, and margins as needed.

You might need to tweak these settings depending on your specific printing requirements.

Step 5: Print Your Selection

Click the ‘Print’ button to print your selected cells.

After clicking ‘Print’, your selected cells will be sent to your printer, and you’ll have a physical copy of just the data you need.

After completing the action, your printer will start working, and you’ll soon have a printed copy of only the selected cells from your Excel spreadsheet. No more wasting ink and paper on irrelevant data!

Tips: How to Print a Selection in Excel

  • Always double-check the cells you’ve selected before printing to avoid errors.
  • Use the ‘Print Preview’ option to see exactly how your selection will look when printed.
  • Remember that any cell formatting will be reflected in the printout, so make sure it’s print-ready.
  • If you have headings or titles you want to include, make sure they’re within the selected range.
  • Consider setting the print area if you find yourself printing the same selection frequently.

Frequently Asked Questions

How do I select non-adjacent cells to print?

Hold down the ‘Ctrl’ key while clicking on the cells you want to include in your selection.

Can I save my selection so I don’t have to reselect it every time?

Yes, you can set a print area in Excel that saves your selection for future printing.

What if I want to print the entire spreadsheet after printing a selection?

Just go back to the ‘Print’ menu and choose ‘Print Entire Workbook’ or ‘Print Active Sheets’.

Can I print a selection from multiple sheets at once?

No, you must print selections from each sheet individually.

How can I avoid printing hidden rows or columns in my selection?

Ensure that all rows and columns you want to print are visible before making your selection.


  1. Select the cells you want to print.
  2. Access the Print menu.
  3. Choose ‘Print Selection’.
  4. Finalize your print settings.
  5. Print your selection.


Mastering how to print a selection in Excel can save you time, paper, and headaches. Whether you’re working on a budget, a project plan, or complex data analysis, sometimes all you need is a specific range of cells on paper. By following the straightforward steps outlined above, you can confidently print just what you need, ensuring that your presentations or handouts are concise and focused. Remember, the key is in the preparation—ensure your selection is exactly how you want it before hitting that print button. As technology continues to evolve, who knows what new features 2024 will bring to Excel? But for now, printing a selection is a breeze. Happy printing!

Get Our Free Newsletter

How-to guides and tech deals

You may opt out at any time.
Read our Privacy Policy