![]() Repeat these steps for each worksheet you want to remove the print area from. To remove the print area from a worksheet, on the PAGE LAYOUT tab, click Print Area, and click Clear Print Area. On the PAGE LAYOUT tab, click Print Area, and click Add to Print Area. Select other cells on the same worksheet. We'll cover printing multiple worksheets a little later in this video. To create print areas on multiple worksheets, you use the same steps. Press the Ctrl+P keyboard shortcut to print.Ĭlick the arrow next to Print Active Sheets, click Print Selection. To print additional non-contiguous ranges, press and hold the Ctrl key, and select the additional ranges. Click a cell in the corner of the range, and drag the mouse over the remaining cells. You can also print specific cells in a worksheet by selecting the range of cells you want to print. If you are going to frequently print the same cells in a worksheet, you can configure them as the print area for the worksheet, so you don't have to select them every time you want to print. Press the Ctrl+P keyboard shortcut to print.Ĭlick the arrow next to Print Active Sheets, click Print Selection, verify the print preview contains only the cells you selected, and click Print. You can also print specific cells in a worksheet by selecting the range of cells you want to print.Ĭlick a cell in the corner of the range and drag the mouse over the remaining cells. In the Print worksheets and workbooks video earlier in this course, we printed a specific worksheet and an entire workbook. If your printer doesn't print on both sides, this option won't appear. Note that changing the printer may change some of your print options.Ĭlick the arrow next to Print One Sided and click one of the Print on Both Sides options. In the bottom right of the print preview, I click the Zoom to Page icon, to make it easier to review the worksheet, and the dates are visible.įrom the print preview, you can change many default print settings.Ĭlick in Copies and type the number of copies you want to print.Ĭlick the arrow next to the current printer and click the printer you want to use. ![]() Now all of the dates in column A are visible. Click and hold the left mouse button and drag it to the right to make the column wider. I point between columns A and B in the column header. If I don't fix this, they'll print this way. It is also a good idea to make sure all of the data in your worksheet is visible on the screen.įor example, some of the dates are too wide for column A, they appear as number signs. This view shows print related details, such as page breaks, and headers and footers.įor more information about headers and footers, see the link to Insert headers and footers in the course summary at the end of the course. When you work on a worksheet, you may want to view it in the Page Layout view to get a better idea of how it'll print.Ĭlick the VIEW tab, and click the Page Layout button. On the PAGE LAYOUT tab, in the Sheet Options group, check the Print box under Gridlines. Select the worksheet or worksheets that you want to print. Under Settings, click the arrow next to Print Active Sheets and select Selected Table. ![]() If you don't want to print only a defined print area, check the Ignore print area box.Ĭlick a cell within the table to enable the table. If a worksheet has defined print areas, Excel will print only those print areas. Under Settings, click the arrow next to Print Active Sheets and select Print Selected Table.Ĭlick the Print button. Also, select a specific range of cells to print, and print a table in a worksheet.Ĭlick the worksheet, and select the range of data that you want to print.Ĭlick FILE > Print. Use print preview to change many default print settings and see what you’ll print.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |