[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More


MS Office Tips

Published on
8,828 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

Starting with Angular 5

Learn the essential features and functions of the popular JavaScript framework for building mobile, desktop and web applications.

Join & Write a Comment

Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Learn how to collaborate with office 365 Office Online

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month