Text box

S

sunderland27

i want to include a note pad or text box, everytime a new date is created.
so that our employess could add text and comments next to the date. what
should i do?
 
R

rajkohli

Click on the Cell where date has been inserted. From the Insert menu click
Comments. Type the text you want.

When you will move your mouse pointer near that cell it will show the
inserted comment. To see all the comments at once, click View - Comments.

If the information was useful to you then let us know.
 
S

sunderland27

are we able to print comments?

rajkohli said:
Click on the Cell where date has been inserted. From the Insert menu click
Comments. Type the text you want.

When you will move your mouse pointer near that cell it will show the
inserted comment. To see all the comments at once, click View - Comments.

If the information was useful to you then let us know.
Click to expand...
 
R

rajkohli

Yes, you can print the comments.

1. Click the worksheet.
2. If you want to print the comments in place on the worksheet, display the
comments you want to print.
3. To display an individual comment, right-click its cell and then click
Show Comment on the shortcut menu. To display all comments, click Comments on
the View menu. Move and resize any overlapping comments as necessary.
a. Click the border of the comment box so that handles appear:
b. Do one or more of the following:
To move the comment, drag the border of the comment box.
To change the size, drag the handles on the sides and corners of the
comment
box.

4. On the File menu, click Page Setup, and then click the Sheet tab.
Do one of the following:
To print the comments where they appear on the worksheet, click As
displayed on sheet in the Comments box.

To print the comments at the end of the sheet, click At end of sheet in the
Comments box.

Click Print.

If the information was useful to you then let us know.
 
Top