There are several quick shortcuts that can make your life easier in Microsoft Programs. These simple tips and tricks will your work more productive and you faster at completing your tasks!
(1) Creating Re-usable Scraps
You can create scraps
in Word, which are small blocks of text from a document. Highlight some text in an open document and drag it to the Desktop, and you will see it appear as a document scrap. You can arrange and rename your scraps on the Desktop, and simply drop them back into Word documents as you need them. The scraps can be pasted into most other applications too.
(2) Simultaneous Save
If you are working on several documents at once, you can save them all without closing Word in the process. Just hold down Shift
and click on the File
menu. You will see a new option Save All
. There is also an option to Close All
if you want to do so without closing Word.
(1) Display or hide all zero values on a worksheet
On the Tools menu, click Options, and then click the View tab.
Do one of the following:
To display zero (0) values in cells, select the Zero values check box.
(2) Replace error values when printing
To display zero values as blank cells, clear the check box.
Select the worksheet with the error you don't want to print.
On the File menu, click Page Setup, and then click the Sheet tab.
Under Print in the Cell errors as box, click <blank>, -- , or #N/A.
Print the Relationships
From the menu select Tools-->Relationships
From the menu select File-->Print Relationships
A new report with the database schema will appear. Print it
During a slide show, if you want to make a small pause and display a black screen, click on the B
key or the .
key on the keyboard. To go ahead and continue your presentation, click any key on the keyboard!
Enjoy these simple tricks and tips for all office applications! I hope you liked them!