How To Print Only Certain Columns In Excel?

Do you ever need to print only certain columns in Excel? Maybe you have a table with a lot of data, and you only need to print a few columns. Or maybe you have a chart, and you only want to print the data that’s used to create the chart.

Whatever the reason, printing only certain columns in Excel is easy to do. In this article, I’ll show you how to print only the columns that you want, using both the print dialog box and the keyboard shortcuts.

I’ll also provide some tips on how to print your worksheets more efficiently. So if you’re ready to learn how to print only certain columns in Excel, read on!

Step	Action	Explanation
1	Select the columns you want to print.	You can do this by clicking on the column headers or by using the keyboard shortcuts CTRL+A to select all columns or CTRL+SHIFT+arrow keys to select a range of columns.
2	Click the “Print” button.	This will open the Print dialog box.
3	Click the “Options” button.	This will open the Print Options dialog box.
4	Select the “Print selected columns only” checkbox.	This will ensure that only the selected columns are printed.
5	Click the “OK” button.	This will print the selected columns.

Excel is a powerful spreadsheet program that can be used to create and manage data. One of the most common tasks that users need to do is print spreadsheets. However, sometimes you may only want to print certain columns of data. This can be done by using the Print Selection feature.

In this tutorial, we will show you how to print only certain columns in Excel. We will cover the following topics:

• Selecting the columns you want to print
• Using the Print Selection feature
• Printing multiple columns at once

Selecting the columns you want to print

The first step is to select the columns you want to print. To do this, click on the first cell in the column you want to print. Then, hold down the Shift key and click on the last cell in the column you want to print. The columns will be highlighted.

You can also select multiple columns by clicking on the first cell in the first column, holding down the Ctrl key, and clicking on the last cell in the last column.

Using the Print Selection feature

Once you have selected the columns you want to print, you can use the Print Selection feature to print them. To do this, click on the File tab and then click on Print. In the Print dialog box, click on the Selection button. This will print only the selected columns.

You can also use the Print Selection feature to print a specific range of cells. To do this, click on the Home tab and then click on the Select button. In the drop-down menu, click on Select Range. This will open the Select Range dialog box. In the dialog box, enter the range of cells you want to print and then click on OK.

Printing multiple columns at once

You can also print multiple columns at once by using the Print Area feature. To do this, click on the Home tab and then click on the Print Area button. In the drop-down menu, click on Set Print Area. This will open the Set Print Area dialog box. In the dialog box, select the columns you want to print and then click on OK.

The columns you selected will now be added to the Print Area. You can print the Print Area by clicking on the File tab and then clicking on Print. In the Print dialog box, click on the Print button.

In this tutorial, we showed you how to print only certain columns in Excel. We covered the following topics:

• Selecting the columns you want to print
• Using the Print Selection feature
• Printing multiple columns at once

We hope this tutorial was helpful. If you have any questions, please leave a comment below.

How To Print Only Certain Columns In Excel?

Excel makes it easy to print only the columns you want. You can use the following methods to print specific columns in Excel:

• Use the Print Ranges feature.
• Use the Page Setup dialog box.
• Use a third-party add-in.

In this article, we will show you how to use each of these methods to print only the columns you want in Excel.

Use the Print Ranges feature

The Print Ranges feature allows you to print a specific range of cells, including columns. To use the Print Ranges feature, follow these steps:

1. Select the columns you want to print.
2. Click the File tab.
3. Click Print.
4. Click the Print button.

In the Print dialog box, you will see a list of all the ranges that are currently selected. To print only the selected columns, click the Print Selection button.

Use the Page Setup dialog box

You can also use the Page Setup dialog box to print only the columns you want. To use the Page Setup dialog box, follow these steps:

1. Click the File tab.
2. Click Page Setup.
3. Click the Sheet tab.
4. In the Print Area section, click the Select button.
5. Select the columns you want to print.
6. Click OK.

The columns you selected will now be printed when you print the worksheet.

Use a third-party add-in

If you need to print only the columns you want on a regular basis, you may want to consider using a third-party add-in. There are a number of add-ins available that can help you print specific columns in Excel.

One popular add-in is the Print Range Plus add-in. This add-in allows you to print a specific range of cells, including columns, with just a few clicks. To learn more about the Print Range Plus add-in, visit the following website:

[https://www.extendoffice.com/product/excel-addins/print-range-plus.html](https://www.extendoffice.com/product/excel-addins/print-range-plus.html)

These are just a few of the ways to print only the columns you want in Excel. By using one of these methods, you can easily print the data you need without having to print unnecessary columns.

How do I print only certain columns in Excel?

There are a few ways to print only certain columns in Excel.

1. Use the Print dialog box.

1. Select the cells you want to print.
2. Click the File tab.
3. Click Print.
4. In the Print dialog box, click the Page Setup tab.
5. In the Print Area section, click Select.
6. In the Selection dialog box, click Columns.
7. Select the columns you want to print.
8. Click OK.
9. Click OK in the Print dialog box.

2. Use the Print Selection button.

1. Select the cells you want to print.
2. Click the Print Selection button on the Home tab.

3. Use the Print Area feature.

1. Select the cells you want to print.
2. Click the Home tab.
3. In the Cells group, click Format.
4. Click Print Area.
5. In the Print Area dialog box, click Set Print Area.
6. Click OK.

Now, when you print your worksheet, only the selected cells will be printed.

4. Use a third-party add-in.

There are a number of third-party add-ins available that can help you print only certain columns in Excel. One popular option is the Print Range add-in. This add-in allows you to quickly and easily select the columns you want to print, and then print them with a single click.

What if I want to print only the first 10 columns in a worksheet?

There are a few ways to do this.

1. Use the Print dialog box.

1. Click the File tab.
2. Click Print.
3. In the Print dialog box, click the Page Setup tab.
4. In the Print Area section, click Select.
5. In the Selection dialog box, click Rows.
6. Type `10` in the Number of rows box.
7. Click OK.
8. Click OK in the Print dialog box.

2. Use the Print Selection button.

1. Click the Home tab.
2. In the Cells group, click Format.
3. Click Print Area.
4. In the Print Area dialog box, click Set Print Area.
5. In the Rows box, type `10`.
6. Click OK.

3. Use the Print Area feature.

1. Select the first 10 rows in your worksheet.
2. Click the Home tab.
3. In the Cells group, click Format.
4. Click Print Area.
5. In the Print Area dialog box, click Set Print Area.
6. Click OK.

Now, when you print your worksheet, only the first 10 rows will be printed.

What if I want to print only the last 10 columns in a worksheet?

There are a few ways to do this.

1. Use the Print dialog box.

1. Click the File tab.
2. Click Print.
3. In the Print dialog box, click the Page Setup tab.
4. In the Print Area section, click Select.
5. In the Selection dialog box, click Rows.
6. Type `-10` in the Number of rows box.
7. Click OK.

In this blog post, we have discussed how to print only certain columns in Excel. We first discussed the different ways to select columns in Excel, and then we showed you how to use the Print Selection feature to print only the selected columns. We also showed you how to use the Print Area feature to print only a specific range of cells, including columns. Finally, we discussed how to use the Page Setup dialog box to print only the columns that you want.

We hope that this blog post has been helpful. If you have any questions, please feel free to leave them in the comments section below.