The AutoSum tool is already fast, but even quicker just try selecting a cell at the bottom of a column of figures and press Alt+=, which inserts the =Sum() function (just like AutoSum does).
If you really only use one sheet and not the default three that Excel creates with any new workbook you can customise this to suit your way of working. Change Excel’s default settings by going to the File menu > Options > General. Look in the section ‘When creating new workbooks’ and change ‘Include this […]
If you want to insert a CD but not use it right away you can bypass Autorun. Hold the Shift key down while inserting a CD (will also work with a USB drive).
Don’t want to leave any trace of your online Christmas shopping (cookies are not saved and browsing and search history is automatically wiped out). Try an InPrivate Browsing session by hitting Ctrl+Shift+P if using either Internet Explorer or Firefox. Google Chrome calls it ‘incognito mode’. You’ll see a small icon in the top-right corner. Select then click “New […]
Encrypted mail. Need to send an email containing sensitive information quickly and easily? Visit Hushmail and click the Try Hushmail button to create an account. Log in, draft your email, add attachments, provide a security question and answer, then click Send (and perhaps call the recipient to make sure he or she knows the correct […]
Print a group of email messages at the same time by selecting multiple emails while holding down the Ctrl key and then selecting File > Print > Memo Style > Print.
Add to Amazon Wish List is a browser addon that lets you add anything you want to your Amazon wish lists. Useful with Christmas round the corner! http://www.amazon.com/wishlist/universal/ref=wl_eywl_uwl
To find your last edit, press Shift+F5.
The Clipboard keeps a copy of the past 24 items you have copied. To view (and paste) any of these items, from the Home tab, click the down arrow icon in the lower-right corner of the Clipboard group.
Mistakenly closed a workbook without saving? You can sometimes recover your work in Excel 2010. Go to File, Info, click the Manage Versions button and select Recover Unsaved Workbooks. Excel 2010 automatically keeps a copy of many (but not all) unsaved workbooks for a few days.