#HOW DO YOU CHANGE PRINT AREA IN EXCEL HOW TO#
#HOW DO YOU CHANGE PRINT AREA IN EXCEL PLUS#

It’s a great course, and will quickly get you up and running with dashboards. You could use this tip for tables on a dashboard too, and tomorrow is the deadline to register for Mynda Treacy’s upcoming Excel Dashboard Course. Then, click the Print button, to print the table.Change any other settings, such as scaling, or select a different printer.Under Settings, select “Print Selected Table”.On the Ribbon, click the File tab (or the Office button in Excel 2007).Select a cell in the table that you want to print.If you want to print just the selected table, but have a bit more control over the print options, follow these steps: Using the Print List button will automatically print the selected table from your default printer, without letting you set any other print options. Select any cell in a table, then click the command, to print just that table.

It shows up as “Print Table”, even though it’s called “Print List” in the Customize the Ribbon list. In the screen shot below, I created a Printing group on the Home tab, and add the command there. Use the Customize the Ribbon command, and you’ll find the Print List command in “Commands not in the Ribbon” However, the command is not on the Ribbon, so you can add it there (Excel 2010/2013), or put the command on the Quick Access Toolbar. This command used to be on the Lists toolbar, in Excel 2003. There is a Print List command in Excel, that prints just the table for the active cell. Or, set the print area for the table’s cell, and remember to remove the print area later.īut, if this is something that you have to do frequently, you can use a built-in Excel command.select all the cells, then go to the Print dialog box, and set it to just print the selection.I’d like to print just the list of Workdays, without any of the other data.

#HOW DO YOU CHANGE PRINT AREA IN EXCEL PLUS#

Print an Excel TableĪside from all the obvious benefits of using formatted Excel tables, there is another reason to use them – it’s very easy to print just the table, without anything else that’s on the worksheet.įor example, in the screen shot below, there are three tables on the sheet, plus a chart, and other text. The tables also expand and contract when you add or remove data, so they are perfect to use as the source data for a pivot table – you don’t have to manually adjust the range after updating the data. This automatically creates drop down lists in the heading cells, where you can sort and filter the data.

When you are working with lists in Excel, you can use the built-in Table feature, to make it easier to work with the data.

#HOW DO YOU CHANGE PRINT AREA IN EXCEL HOW TO#

See how to print Excel table only, without print area setup. Today, we’ll look at a time-saving Table trick that you might not know about.

How do you change print area in excel