To start with, select the data you want to include in the outline, as we've done below.
This will be important to know if you don't have sums (or totals as in the last section) in your worksheet, which are required to create outlines automatically.
How to change print area in excel 2013 how to#
Now let's learn how to create one manually. In the last section, we learned how to let Excel do all the work in creating an outline. If you want to hide that data again, click on the minus sign in the outline above column E.
How to change print area in excel 2013 plus#
We can click on the plus sign above column E, which represents the Q1 total to see all the data for Q1. You can also use the plus and minus signs in the outline to expand or collapse data.
If we click 2, we see our quarterly totals along with our Total column. If we click 1, all the columns but the Total column is hidden. In our outline, you can see 1, 2, and 3 in the row headings. To automatically create an outline in Excel 2013, move your cursor anywhere in the data. You can see our cursor below.Īs long as you have subtotals in your worksheet, it will become outlined, as shown below:Īs we said at the beginning of the section, outlining groups sections of a sheet together so you can hide them if you want. Watch this short video to see the steps for adding the Print List command to the Ribbon, and printing the selected table.Outlining groups sections of the sheet together so you can hide them.īelow we have a worksheet that contains sales amounts for different employees in different months. It also contains quarterly totals, then a grand total. 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. 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. 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.
0 kommentar(er)
