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 kommentar(er)
