|
Hi,
In this section I'll be including more tips and tricks, along with some advice and stories from the world of PCs.
SP asked: When I open a Word attachment in Outlook, Word starts in Reading Layout. Can I start Word normally?
Sean’s answer: Yes, no problem. In Word 2003, on the Tools menu, choose Options, click the General tab, and then untick the Allow starting in Reading Layout check box.
In Word 2007, click the Office Button, choose Word Options at the bottom right corner of the menu. Click Popular in the left hand panel, then untick Open e-mail attachments in Full Screen Reading view.
For those people that enjoy playing with our computer’s settings, Windows 7 and Vista have a hidden "God Mode" feature that lets us access all of the system's control panels from within a single icon and folder.
I wouldn’t recommend doing this on a Work’s computer though – settings for these machines are often protected.
To enable this feature, simply make a new folder in Windows 7 (for example on the Desktop) and use this name:
GodMode.{ED7BA470-8E54-465E-825C-99712043E01C}
The icon changes to represent a Control Panel.
Though I’ve not tried it, this trick is also supposed to work in Vista, although there are warnings on the Internet that it can cause 64-bit versions of that operating system to crash.
Ok, so I guess there are a lot of people that know the SUM function. Here are a few more that can help on your spreadsheets. I'm using B10:B30 as a sample range, make sure you change this to match your needs.
=sum(B10:B30)
Adds the numbers in the range B10:B30
=average(B10:B30)
Works out the average of the numbers in the range B10:B30
=count(B10:B30)
Counts how many numbers there are in the range B10:B30
=countA(B10:B30)
Counts how many filled cells there are in the range B10:B30
=max(B10:B30)
Returns the highest number in the range B10:B30
=min(B10:B30)
Returns the lowest number in the range B10:B30
Hope this helps.
| 
Blog
