How to Print Excel Columns

By Stephanie Ellen

Microsoft Excel spreadsheets can contain up to 16,384 columns of data. You may not want to print out an entire spreadsheet and waste a lot of paper. Excel has a way you can print out one or several columns. You don't even have to print the entire column of data--Excel can handle up to 1 million rows of data per column; You can select a small portion of the column to print instead.

Step 1

Click the column header for the column you want to print. For example, click "A." If you want to print more than one column, press the "Ctrl" key while making your selections.

Step 2

Click the "Microsoft Office" button, then mouse over "Print" and then click "Print."

Step 3

Click the "Selection" radio button under Print What.

Step 4

Click "OK" to print the columns.

Tips & Warnings

  • If you want to select a certain range within the columns, set the print area up instead of clicking on the column headers. To set a print area, highlight the cells you want to print, then click the "Page Layout" tab. Click "Print Area" and then click "Set Print Area."