20 June 2011
Whether you are stepping up from Office 2000, XP or 2003, you will find that Office 2010 is significantly different. If you are upgrading from Office 2007 you will find there are some new features...
Posted by Sam Markham
16 June 2011
Whether you are stepping up from Office 2000, XP or 2003, you will find that Office 2010 is significantly different. If you are upgrading from Office 2007 you will find there are some new features...
Posted by Sam Markham
10 January 2011
Problem
A spreadsheet has one column that contains text that needs to be separated into two columns (such as splitting a full name column into separate first name and surname columns). How can the...
Posted by Sam Markham
3 June 2010
Put extra useful buttons (print and print preview) onto your quick access toolbar. Right click on the bar and choose Customise Quick Access Toolbar. You can then choose to add any button to this...
Posted by Sam Markham
3 June 2010
In the recently used files list, try clicking on the Mapping Pin. This 'locks' the file onto your recent list until you choose to remove it (by clicking the pin again).
Posted by Sam Markham
1 April 2010
Each new project site set up on SharePoint will have an email address associated with it so project-related e-mails can be sent to everyone on the team using the Team Discussion area.
A notice will...
Posted by Sam Markham
1 April 2010
To modify a form, locate the area in the site or sub-site where the form is used, then:
Site Actions > Site Settings
Click Site Libraries and Lists in the Site Administration column
Choose the area...
Posted by Sam Markham
1 April 2010
If you have accidentally deleted an item in a SharePoint list, you can restore it. Do this:
Click Recycle bin
Select the item
Click Restore...
Posted by Sam Markham
1 April 2010
Did you know you don't have to delete a document to upload a new version?
Follow the normal procedure to uploading a file (that is, Upload then Browse to choose the file name).
As long as the new...
Posted by Sam Markham
1 April 2010
Problem:
When you apply a filter to a list in SharePoint – say to show just your own documents, or just PowerPoint presentations – you are unable to save or copy a group of files....
Posted by Sam Markham
1 April 2010
If you use My Network Places to store and manage your frequently used document locations in SharePoint, you can point your Office applications, or Outlook, to open, save and even attach files...
Posted by Sam Markham
21 April 2009
[F11] Show the database window (Navigation pane in Access 2007)
[F2] Edit data in field
[Shift] + [F2] Display Zoom window...
Posted by Maggie Hill
21 April 2009
Double-click an image to replace it with a different one.
Posted by Maggie Hill
21 April 2009
[Ctrl] +[Shift] +W underline words only - not spaces
[Ctrl] +[Shift] +D double underline
[Ctrl] +[Shift] +[Space] non-breaking space
[Ctrl] +[Shift] + -- non-breaking hyphen]
Try this...
Posted by Maggie Hill
23 January 2009
[Ctrl] + 0 Fit to page
[Ctrl] + 1 Actual size
[Ctrl] + H Toggle reading mode on/off.
[F4] Toggle Navigation Pane on/off.
Posted by Greg Casewell
23 January 2009
To sort a menu alphabetically:
Press [Ctrl]+[Alt]+[Shift] before you click
Press [Tab] to show/hide all the panels, including the Toolbox.
Press [F7] to show/hide the layers...
Posted by Greg Casewell
22 January 2009
Press:
V to switch to the Selection tool
L to switch to Lasso tool
T to switch to the Text tool
[F5] to add a frame
[F7] to add a keyframe
Remember there’s ‘keystroke crossover’...
Posted by Greg Casewell
22 January 2009
Press [Ctrl] + [Shift] + [Space] to insert a non-breaking space.
Press [F12] to view a page in the primary browser
press [Ctrl] + [F12] to view a page in the secondary browser
Press [Ctrl] + [Alt]...
Posted by Greg Casewell
22 January 2009
Switch to a different tool temporarily:
For example, hold down [Space] to switch to the ‘Hand’ tool.
Hold down [Ctrl] to switch to the ‘Move’ tool.
Hold down [ALT] to...
Posted by Greg Casewell
16 January 2009
Problem:
How can I keep a record of who has opened my workbook?
Solution:
Create a tracking macro and attach it to the Open event of a workbook.
If you want to track who has saved it, attach...
Posted by Maggie Hill
16 January 2009
Really useful for getting data like filename into a cell.
Returns information about the formatting, location, or contents of a cell
=CELL("address",C17) – returns the address (useful for...
Posted by Maggie Hill
16 January 2009
Problem:
I have a very long list of items and want to be able to 'type ahead' and, of course, I can't! But it is really time consuming to scroll through to select an item.
Solution:
One solution...
Posted by Maggie Hill
16 January 2009
You would think this would be quite simple, but you can't specify >TODAY() as criteria.
Try this instead:
=COUNTIF(range, ">=" &...
Posted by Maggie Hill
16 January 2009
Problem:
Word automatically turns on and displays marked changes when you send a document to someone else - and even when you share it on a network.
Solution:
This not-very-helpful feature can be...
Posted by Maggie Hill
16 January 2009
Did you know...
If you type
DefInt I-N
in the declaration section at the top of a module, then you can use variables i j k l m and n anywhere in the module without defining them again.
Great...
Posted by Maggie Hill
