![]() Or say, you want to have a group review of the equations in your worksheet, to make sure they are correct.īut you don't want to click in every cell that has a formula to do the review. If you don't, you can find one by clicking options such as Clip Art and Bing Image Search.īrowse or search to find the image you want, click it, and your worksheet now has a watermark that says "Confidential". On the PAGE LAYOUT tab, click Background. There isn't a watermark feature in Excel, but you can come pretty close. You want to put a watermark on your worksheet that says "Confidential". Now when you print the worksheet, the headings are printed. On the PAGE LAYOUT tab, under Headings, check Print. It makes it easier to discuss a print-out if the rows and columns don't have some sort of sequential IDs. This is 1, 2, 3 and so-on for rows and A, B, C, and so on for columns. Now when you print the worksheet, the gridlines are printed and it is easier to read. To print gridlines in a worksheet, on the PAGE LAYOUT tab, under Gridlines, check Print. On the screen, by default, the worksheet's pages have gridlines, making it easier to read across rows and down columns.īut when you print, by default, the gridlines are not printed. Click As displayed on sheet.Ĭlick Print Preview, and in print preview you can see the comments on the worksheet. You have the options to print them At end of sheet or As displayed on sheet. Click Print Titles.Ĭlick the Comments down-arrow. ![]() To print the comments as they display on the worksheet, you first have to display them.Ĭlick the REVIEW tab, and click Show All Comments. When you print a worksheet, you can print the comments at the end of the worksheet or as they display on the worksheet. ![]() When I point to the red indicator in the corner of this cell, the comment appears. If you have frozen or locked panes and want to print the top or left pane on every page, see the course summary at the end of the course for a link to the Freeze or lock panes course. You can also select Columns to repeat at left to have columns repeating on the left of every page.Ĭlick Print Preview, and in print preview you can see that the header will print at the top of every page. The entire row is automatically filled in for me. Click in Rows to repeat at top, and then click any cell in row 1. You won't have to keep flipping back to to remember what data was in a column.Ĭlick the PAGE LAYOUT tab, and click Print Titles. Since the worksheet is longer than a page, printing the header row on every page makes the worksheet easier to read. The first row of this worksheet has labels for the columns. You can even mimic a watermark and print it. Here are a few more things you can do with printing in Excel, including printing headings, gridlines, row and column headings, and formulas.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |