by Lars Vogel

Follow me on twitter

Lars Vogel on Google+

Microsoft Applications

Lars Vogel

Version 1.1

07.08.2011

Revision History
Revision 0.1 01.09.2007 Lars
Vogel
Created
Revision 0.2 - 1.1 12.07.2008 - 28.09.2010 Lars
Vogel
bugfixes and enhancements

Using Microsoft

This article captures some settings / features in Microsoft Windows which I find useful.


Table of Contents

1. Shortcuts
1.1. Windows
1.2. Outlook
2. Windows Settings
2.1. Environment Variables
2.2. Search (Microsoft and Google)
2.3. Turn of the dynamic menus
3. Excel
3.1. Simultaneously editing of one excel spreadsheet
3.2. Dropdown List
4. Winword
4.1. Add Macrobuttons
5. Powerpoint
5.1. Apply master layout to slide
6. Appendix: Additional Windows Settings
6.1. Language Settings for Office
6.2. Language Settings
6.3. Map a network drive
6.4. Create a link toolbar
7. Thank you
8. Questions and Discussion
9. Links and Literature

1. Shortcuts

1.1. Windows

  • WindowsKey + d - Hide / restore all applications

  • WindowsKey + m - Minimize all applications

  • WindowsKey + r - Open the run dialog

  • WindowsKey + Pause - Opens the settings dialog

.

1.2. Outlook

Table 1. Shortcuts

Shortcut Description
Cntr+1 / Cntr+2 / Cntr+3 /Cntr+4 Switch to Mail / Calendar / Contacts / Tasks
Cntr+n Neu Email
Cntr+Enter Send Email
Cntr+r Reply Email
Alt+F4 Close Email
Cntr+Shift+r Reply to all
Cntr + Q Mark as read
Cntr + U Mark as unread


2. Windows Settings

2.1. Environment Variables

To set the windows environment variables, select Control Panel -> System -> Advanced ->Button "Environment Variables".

To check the content of a variable, open a command shell (Start-> Run-> cmd) and type echo%VARIABLE_NAME%

2.2. Search (Microsoft and Google)

The following search term will work on Microsoft search and may work on Google Desktop search.

Table 2. Search

Command Description
mars to:Jim Messages with the keyword "mars" to the user Jim.
attachment:mars All emails which have an attachment named mars
mars filetype:jpg mars stuff with pictures
from:Jim created: 23.04.2007 Stuff from Jim created on 23.04.2007
"mars rover" Email with the phrase "mars rover"
mars +photos -rover mars +photos -rover


2.3. Turn of the dynamic menus

If you don't what dynamic menus in in Windows -> Programs, select Settings -> Taskbar and Start Menu -> Tab Start Menu -> Classic and press Customize.

If you don't like the dynamic menus in winword / excel / powerpoint, select tools -> customize and then select "Always show full path name".

3. Excel

3.1. Simultaneously editing of one excel spreadsheet

Excel allows to edit it with several persons at the same time. To activate this, select the following.

3.2. Dropdown List

4. Winword

4.1. Add Macrobuttons

Go to the menu entry Macro and click on it. Select the macro you want to assign to a push button, hold left mouse button and drag it to the menu.

In customizing click on the macro button and press the right mouse button. Rename the button to a reasonable name.

5. Powerpoint

5.1. Apply master layout to slide

Press Ctrl + Space to apply the master slide layout to the slide.

6. Appendix: Additional Windows Settings

6.1. Language Settings for Office

To change the language in which office works, select the following.

6.2. Language Settings

Control Panel -> Regional and Language Settings -> Languages Click on Details and then Key Settings

6.3. Map a network drive

You can map a network driver to a local driver which make it easier to access it.

6.4. Create a link toolbar

If you want to have quick access to your folders / network drivers you can create your own toolbar and put your links into it.

Right click on the toolbar and select toolbar -> own toolbar.

Right click on the toolbar and select toolbar -> own toolbar.

You can now pull the new toolbar on your desktop and then position it for example at the top of your screen. Fill the folder with links and you will have easy access to your folders.

7. Thank you

Please help me to support this article:

Flattr this

8. Questions and Discussion

Before posting questions, please see the vogella FAQ. If you have questions or find an error in this article please use the www.vogella.de Google Group. I have created a short list how to create good questions which might also help you.

9. Links and Literature

No resources listed yet.