Excel prints display all annotation method illustrations

How Excel prints annotations, this small function is often used, such as some handouts, reports, etc., will need to use, the following small series for everyone to introduce Excel print display all annotation methods, take a look at it ~!

Software Name:

Microsoft Office Word, Excel, ppt2007 Compatibility Pack (compatible 2003 patch package)

Method/Step

1, open the file, and then decide to select the cells you want to display the annotation,

2, I do the test here directly to show all the comments, this display annotation if there is not understand can see back to my previous experience of writing,

3, to determine the good display of the annotation, click the "page Layout"

4, in the "page layout", click on the "page settings" next to the small icon,

5, in the pop-up settings, select "Sheet", and then in the print bar, the "annotation" to select "as shown on the worksheet" so that is actually done,

6, OK, we can also use Print Preview to see the effect of the upper left corner menu--"print"--"Print preview"

7, through the "Print preview" You can see the effect, so as to determine if you want.

The above is the Excel print display all annotation method Introduction, hoped can be helpful to everybody!