All commands (icons) that deal with comments are found in the Review tab, Comments group.
To insert a new comment:
1. Select the cell where you want to insert the comment.
2. Click New Comment.
3. A new comment will be created. Type the required text then click outside the comment box.
4. The comment box will disappear but a small indicator will show [...]
To print comments in Excel 2007:
1. Show all comments or just the comments you want to print. How?
2. In the Page Layout tab, Page Setup group, click the dialog box launcher (see the mouse pointer in the image below).
3. The Page Setup window will open.
4. Click on the Sheet tab.
5. In the Comments box, select As displayed on sheet or [...]
To change page orientation in Excel 2007 :
1. Switch to the Page Layout tab.
2. In the Page Setup group click Orientation.
3. Select the required orientation (Portrait or Landscape) from the options shown.
4. You can click Office Button –> Print –> Print Preview to verify your selection.
To repeat column titles (heading rows) in every page in Excel 2007 follow these steps:
1. Switch to the Page Layout tab.
2. In the Page Setup group click Print Titles.
3. The Page Setup window will open with the Sheet tab selected.
4. In the Sheet tab click the text box titled: Rows to repeat at top
5. Now go to your worksheet and [...]
To insert the current date in worksheet footer, follow these steps:
1. In the File menu click Page Setup. The Page Setup window will open.
2. Select the Header/Footer tab.
3. Click the Custom Footer button. The Footer window will open.
As you can notice the footer is divided into three sections; left, center and right. Above those sections there is a [...]
To insert page number in worksheet footer, follow these steps:
1. In the File menu click Page Setup. The Page Setup window will open.
2. Select the Header/Footer tab.
3. Click the Custom Footer button. The Footer window will open.
As you can notice the footer is divided into three sections; left, center and right. Above those sections there is a number [...]
If you are getting blank pages when you are printing a worksheet, then there are a number of possibilities:
1. You have some ‘unnoticed’ text in one of the cells, e.g. ‘.’ or ‘,’.
2. You have cells that contain text, but the text color is the same as the cell background color.
3. You have a cell with a formula [...]
If you have a workbook with a number of worksheets, some visible and other hidden, and you want to print only the hidden sheets, then you can use the macro shown below.
Because Excel will not allow the macro to be printed while it is hidden, this macro will make the sheet visible, print it and [...]
If you have a workbook with a considerable number of worksheets, some visible and other hidden, and you want to print only the visible sheets, then you can use this macro:
Sub PrintVisibleSheets()
‘***************************************************
‘Print only visible sheets in the active workbook [...]
To print all worksheets in a workbook then :
1. In the File menu click Print.
2. The Print window will open.
3. At the bottom of the Print window find a section labeled: Print what .
4. Click on the radio button labeled: Entire workbook.
5. Click OK.
Applies to Excel 2003
