EXCEL : Select all cells that contain comments
CTRL + SHIFT + O
Try it out.
--------------------------------------------------------------------------------------
EXCEL: Download and Play Fun Games on Excel
https://docs.google.com/file/d/0B4jM6Io8KxDUUXZ6MkFUYlhVMUE/edit
--------------------------------------------------------------------------------------
WORD : Shortcut to insert comment
Alt + Ctrl + M
Try it out.
--------------------------------------------------------------------------------------
EXCEL : Use 'Wrap Text' to accommodate sentences / long words in one cell.
Text in cell longer than the width of the column? And constraints on column width?
Use Alt + H + W.
Try it out.
--------------------------------------------------------------------------------------
EXCEL : Shortcut to add FILTER on the table head
Ctrl + Shift + L
Try it out.
--------------------------------------------------------------------------------------
Select some text in Word and press Shift+F3 to quickly change the case of the selection. It toggles between UPPERCASE, lowercase and Camel Case (first letter in capital) and should come handy if you’ve accidentally left the CAPS LOCK key on while typing.
--------------------------------------------------------------------------------------
Most people use the Cut-Paste (Ctrl-x Ctrl-v) route to move text from one location to another within a Word document but there’s an alternate way as well. Highlight any block of text, press F2 and then place the cursor at the spot where you wish to move that text. Press Enter and the selection will be moved.
--------------------------------------------------------------------------------------
There’s a Lorem Ipsum generator built inside Word to help you insert filler text anywhere inside the document. Type =rand(p,l) and press Enter to insert ‘p’ number of paragraphs each having ‘l’ lines. For instance, =rand(3,6) will generate 3 dummy paragraphs with 6 lines each.
CTRL + SHIFT + O
Try it out.
--------------------------------------------------------------------------------------
EXCEL: Download and Play Fun Games on Excel
https://docs.google.com/file/d/0B4jM6Io8KxDUUXZ6MkFUYlhVMUE/edit
--------------------------------------------------------------------------------------
WORD : Shortcut to insert comment
Alt + Ctrl + M
Try it out.
--------------------------------------------------------------------------------------
EXCEL : Use 'Wrap Text' to accommodate sentences / long words in one cell.
Text in cell longer than the width of the column? And constraints on column width?
Use Alt + H + W.
Try it out.
--------------------------------------------------------------------------------------
EXCEL : Shortcut to add FILTER on the table head
Ctrl + Shift + L
Try it out.
--------------------------------------------------------------------------------------
Select some text in Word and press Shift+F3 to quickly change the case of the selection. It toggles between UPPERCASE, lowercase and Camel Case (first letter in capital) and should come handy if you’ve accidentally left the CAPS LOCK key on while typing.
--------------------------------------------------------------------------------------
Most people use the Cut-Paste (Ctrl-x Ctrl-v) route to move text from one location to another within a Word document but there’s an alternate way as well. Highlight any block of text, press F2 and then place the cursor at the spot where you wish to move that text. Press Enter and the selection will be moved.
--------------------------------------------------------------------------------------
There’s a Lorem Ipsum generator built inside Word to help you insert filler text anywhere inside the document. Type =rand(p,l) and press Enter to insert ‘p’ number of paragraphs each having ‘l’ lines. For instance, =rand(3,6) will generate 3 dummy paragraphs with 6 lines each.
0 comments:
Post a Comment