You can remove a print area by selecting (File > Print Area > Clear Print Area). The select (File > Print) and make sure the "Selection" is checked in the Print What options. If not then the entire worksheet is printed. If you have then this range of cells is printed. If you change the "Print What" option buttons to Active sheet(s) then Excel will automatically check if you have a named range called "Print_Area" defined on those worksheets. This will create a named range "Print_Area" automatically that will be used when printing. To only print part of a worksheet highlight the cells you want to print and select (File > Print Area > Set Area). The dashed lines are the default breaks that Excel inserts automatically. The solid lines are breaks that you have manually inserted. If they are moved they are displayed as solid lines (because they then become manual breaks) It is possible to also drag the print boundaries to include more or fewer columns or rows in your print area.ĭotted lines show where automatic breaks will occur You can drag the blue page breaks with your mouse to customise the printable area. You can adjust the page breaks in several ways. It is just an alternative way to look at your worksheet. It is possible to make other worksheet changes while working in this view, such as changing content, increasing column widths, removing rows etc. To view these automatic page breaks select (Tools > Options)(View tab, Page Breaks). When you have finished you can select (View > Normal).Įxcel will insert page breaks for you automatically. The White area denotes the area that will be printed.ĭefining a Print Area lets you restrict the cell range that is printed. This lets you see the print area clearly with all the page breaks identified. You can see the range of cells that will be printed by selecting (View > Page Break Preview). Step 2: Click the Page Layout tab at the top of the window.The Print Area is the area or range of cells that will be printed.Ī page break defines where one page ends and another one begins. Step 1: Open the spreadsheet in Excel 2010. Once you have completed these steps, your entire spreadsheet will be printable. The steps in this article will assume that you are currently attempting to print a spreadsheet, but that only a subset of the cells in that spreadsheet are being printed. How to Clear the Print Area in Excel 2010 (Guide with Pictures) Fortunately you can undo a print area that has been set by following our simple tutorial below. This occurs because the last editor set a print area, which changes the data that Excel thinks you want to print. One common issue that can arise is when you are trying to print your spreadsheet, but only part of the sheet is printing. Many of these formatting choices are invisible, and it can be difficult to undo a setting when you are working on a file that was edited or created by someone else. This formatting can affect the data contained within your cells, the way that the data looks in those cells, or even the way that a spreadsheet prints out on paper. You can apply a lot of different formatting to a document in Microsoft Excel 2010. Our guide continues below with additional information on Excel not printing all rows, including pictures of these steps. Click the Print Area button and select Clear Print Area.3 Additional Sources How to Fix Excel Not Printing All Rows
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |