MS Office Tips

Published on
8,798 Points
4 Endorsements
Last Modified:
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!
1 Comment

Author Comment

Great tips! Thanks!

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Join & Write a Comment

Overview of OneDrive and collaboration.
See the Basics of Office 365's Note Taking app, OneNote

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month