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. It’s yet another of many ways to adjust the appearance of your data on the physical page.Today, we’ll look at a time-saving Table trick that you might not know about. You can also change the way that your spreadsheet prints by adjusting the scale. If you want to change the workbook view for the entire workbook then you can right-click on any of the sheet tabs, choose the Select All Sheets option, then click the Page layout view button. If you have multiple sheets in your workbook for which you would like to change the print view then you can hold down the Ctrl key as you click each sheet tab whose print settings you want to adjust, then go to the View tab and click the Page Layout button. Excel users get in the habit of choosing to print active sheets or all the print areas of a worksheet, so it can be a difficult problem to troubleshoot when you can see all of your data on the screen, but you seem to have a weird page break pattern, or complete datasets being omitted when you go to print. Now when you go to print, only the print area that you specified will appear on the printed page, or in any of the view modes that involve printing, like Page Layout view or the Print Break Preview view.įamiliarizing yourself with print areas is a useful tool to have, as it can be the source of a lot of problems when the print area prints only a small part of the worksheet. You can create a print area in Excel by selecting the cells that you want to print, clicking the Page Layout tab at the top of the window, then clicking the Print Area button and choosing the Set Print Area option. It will not affect workbooks that you have already created, or ones that are sent to you by other people.Īnother way to control the data that prints in your spreadsheet is a print area. If you make this change then all future new workbooks that you create will use this default view. You can find this by going to File > Options to open the Excel Options window, then click the Default view for new sheets dropdown menu and select Print Layout View. Microsoft Excel also provides a way for you to set the default worksheet view. Our guide below will show you how to switch to that view from whatever view is currently set in your workbook. One way to do this is with the help of the Page Layout view in Excel 2013.Įxcel 2013 has several different view options that you will find to be effective in certain situations, but the Page Layout option is particularly useful when you are concerned about correctly fitting your rows and columns to the printed page. There are a few easy ways to force your Excel 2013 spreadsheet to fit on one page, which can help to solve many of the print problems that you might be having with your worksheets.īut many Excel jobs don’t fit into the same set of criteria or only some of your spreadsheet might be printing, so you may find yourself needing to see the current print layout of your data so that you can adjust it manually. You can switch to Print View in Microsoft Excel 2013 by going to the View tab, then clicking the Page Layout option in the ribbon. Often it can make things a bit easier when you can see how the worksheet will look when it prints. Working with data in Microsoft Excel can have an extra element of difficulty when printing is involved.