miercuri, 17 iunie 2009

Shortcuts comments in Excel with keyboard

The comments shortcuts:

-insert/edit: shift+F2
-delete : menu; m (press the menu key (or shift+F10) and then m)

-list cells with comments: Ctrl + Shift + ' (apostrophe)

- selects all cells that contain comments: CTRL+SHIFT+O.

To delete ALL comments in a sheet:

1. Press F5 to open the Go To dialog box, and click Special.
2. In the Go To Special dialog box, select Comments.
3. Click OK. All cells containing Comments are selected.
OR
Skip steps 1 through 3 and press Ctrl+Shift+O (the letter O, not the number zero) to select all Comments.
4. Press Shift+F10 or right-click, and select Delete Comment from the shortcut menu.
(thx to http://exceltip.com/st/Deleting_All_Cell_Comments_in_a_Sheet/189.html)

Niciun comentariu:

Trimiteți un comentariu