top of page

Microsoft Excel articles et conseils

Excel Icon.png
Back Button

© 2019 DJH Training & Application Solutions Inc.

Excel for Microsoft 365 has changed the way comments work. Comments are now threaded, and allow you to have discussions with other people about the data. Notes are for making notes or annotations about the data, and work like comments used to work in earlier versions of Excel.

To print Comments or Notes, do the following:

In the Page Setup dialog box > Sheet tab, select an option in the Comments and notes drop-down:

Comments 1.png

OPTION 1 - AT END OF SHEET

This prints the Comments and Notes on a separate sheet and includes the cell address, the name of the person commenting and the Comment or Note.

Hint: If reviewing a hard copy of the file, print it with the row numbers and column letters by selecting the Row and column headings option to the left of the Comments and notes option.

Comments 2.png

OPTION 2 - PRINT NOTES AS DISPLAYED (NOT AVAILABLE FOR COMMENTS)

Display individual comments by right-clicking the cell and choosing Show/Hide Notes OR Display all Notes on the Review tab > Show all Notes.

(Note boxes may be resized, moved and formatted.)

Comments 3.png
bottom of page