Office tips that tricks...

[Andrew Pratt]

Since we all likely use MS office daily how about posting some of those little tricks you've come across?

To get us started here's two I use a lot...

The first regards using Word to select collumns of text. To do this simply click where you'd like to begin selecting and then hold down the "alt" key and use the mouse to select a collumn of data. This is very useful for adding in a space between fields that need formating or to remove the damn >>>> in forwarded emails.

The second one involves adding text to a powerpower show on the fly. During a slide show pressing Cntl and "p" will change the mouse pointer into a "pen" so you can draw on the screen. This can be useful to make a point of something etc. These scribbles aren't saved and are removed as soon as you move off that slide.

[Burke Strickland]

One fairly basic feature of the more recent versions of Office that gets overlooked by a lot of folks is the context-sensitive shortcut menu that pops up with a "right click" of the mouse. Saves hunting around the regular command menus for some often-used commands and in some cases allows avoiding the keyboard in favor of the mouse. (If your hand is already on the mouse, that's convenient.)

[Andrew Pratt]

Another goodie in Excel is that the control key and tilda together will toggle between showing all the forulas and the results...handy if you need to see what's going on at a glance.