MS Office Tips

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!

MS Word
(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.

MS Excel
(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.
To display zero values as blank cells, clear the check box.

(2) Replace error values when printing
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.

[b]MS Access[/b]
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

MS PowerPoint
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!

Comments (1)


Great tips! Thanks!

Have a question about something in this article? You can receive help directly from the article author. Sign up for a free trial to get started.