Skip to content
Last updated: Sunday, 23 October 2022
Problem Formatting documents in Word can be extremely frustrating. Often Word completely disregards the ‘repeat header row’ setting – leaving...
Problem When attempting to install Office 2013 you receive an error message which reads: Setup Error We can't install the...
Here’s a useful tip if you ever need to combine multiple CSV files into one CSV file. For example, if...
If you need to create a pivot table chart on a range that includes blank rows you’ll end up with...
The following steps show how to remove the link between a Word document and a mail merge data source. When...
Problem When running a mail merge in Microsoft Word some merge fields change format. For example, the font or size...
If you see the following message when opening a Word document it means the document has been linked to another...
Problem When copying and pasting a table in Microsoft Word, the pasted table seems to not appear. When looking closer...
I use Microsoft Word’s mail merge feature often. It works great for connecting into a database and spitting out all...
The steps below show how to paste comma-separated values directly into an Excel 2013 file. This method uses a built...
Problem: When Microsoft Outlook is connected to an Exchange server it prompts for a username and password. When your username...
In Outlook when you send an email the address is remembered and added to an ‘auto-complete’ list. The next time...
If you’ve found a black line at the top of bottom of your document and you can’t work...
Problem The email signature in new emails is the correct colour, for example black, but when replying to emails the...
When Microsoft Word 2013 refuses to spell check it’s usually because it’s been disabled for the selected language in the...
The following steps show how to split comma separated values from one column into many. In this example we’ll focus...
By default when saving a CSV file in Excel, each column will be separated using a comma as the delimiter...
Problem Using Word 2013, a paragraph is breaking onto a new page automatically rather than splitting across two pages. This...
One of the more annoying ‘features’ of Word 2013 is ‘Reading View’ – where any document you open that is...
Problem When using Outlook 2013 connected to an Exchange service and using cache mode not all emails are available through...
The following table shows the version number for the last few versions of Microsoft Office. This is useful if you...
One of the many subtle changes in Office 2013 is removing the split window option from the toolbar in Word...
The following steps detail how I recover DOCX files that have become corrupted. This process will only work for DOCX...
Problem Word 2013 introduced a new feature – the ability to open and edit PDF files. This issue is is...
When connected to an Exchange server, Outlook will automatically synchronize the address book once every 24 hours. However, if you...
Problem When viewing emails in Outlook, embedded images do display. Instead a square and a red X are seen. Solution The...
Problem When attempting to insert a hyperlink in a message you find that the options are greyed out and you...
Problem: When using Outlook 2013 in cached mode you’re unable to delete a folder. When you try you see the...
Problem After migrating from an earlier version of Office to Office 2013 some Access databases do not load or do...
When creating reports in Access 2013 you’ll notice that the report data appears to have a mind of its own when...
If you see the following message when opening a Word document it means the document has been linked to another...
If your work schedule runs in week numbers or you regually need to count out week numbers then this tip...
The file that stores the auto-complete list can be found in the user profile using this path: %USERPROFILE%\AppData\Local\Microsoft\Outlook\RoamCache This will...
The steps below detail how to take a column of values, some that are duplicates, and to list the unique...
The following process shows how to fill missing numbers in a range. For example, if we had an excel table...
A drop down list allows you to enter data into an Excel spreadsheet from a pre-set list of entries. This...
We’ve all been there – having sent an email without an attachment, with a typo or to the wrong person...
By default Outlook 2013 blocks a large number of attachments based on their file extension (the part after the file...
In access 2013 you can use a ‘line’ object to draw horizontal or vertical lines. Typically you would draw a...
To add a new paragraph inside a cell all you need to do is hold Alt and press Enter on...
The following keyboard commands can be used to display merge tags. How to show a specific merge tag Select the...
The following steps show how to add the From field to the Outlook 2013 message window. It applies to new...
When creating a table in Microsoft Access it is important that the table is correctly setup with a primary key...
These steps detail how to check the size of a mailbox using Outlook 2013. The same steps can be used...
Unlike previous versions of Microsoft Word, the on screen page ruler is not enabled by default. To enable it you...
Word 2013 offers an accessibility checker to assess your documents and suggest changes that will make the document more...
Unlike previous versions of Word, Word 2013 doesn’t provide a menu option for changing the case of any select text...
These steps show how to remove a delegate using Outlook 2013. Delegate access is typically done for a calendar, allowing...
Outlook 2013 (as well as 2007 and 2010) has the ability to remember the email addresses you use, then list them...
Problem By default bullet and numbered lists have a ‘tab’ indent before each item. However, this can be customised on...
Problem When clicking on web links in Outlook messages or Word documents you see the following message This operation has...
Since Office 2007, Word has offered the two ways to compare two Word documents for differences. This is useful if...
The following steps show how to recover an unsaved document in Word 2013. Open Word 2013 At the bottom left...
The following steps detail how to make a report in Microsoft Access 2013 grow to use more than the default...
Word has a handy keyboard command which allows you to change the text case of selected text. It allows you...
The steps below show how to remove a background colour that has been applied to an email you received and...
The steps below show how to link a Word document with an Excel spreadsheet. This allows the data in the Excel...
The default Office 2013 colour design and colour palette is arguably the blandest yet. Fortunately there are options to customise...
Outlook 2013 has introduced a new feature called 'message preview' which allows you to display the first 1, 2 or...
To disable the Reading View. With Word 2013 open Go to File -> Options -> General Uncheck Open E-Mail attachments...
With Outlook 2013 open, click on the ‘File’ menu Click on ‘Options’ On the left hand menu, click ‘Mail’ and...
To view header information in Outlook 2013: Open the email in a new window (this is important – the same...
New to Office 2013, when you open an Office product (Word, PowerPoint, Excel etc) you see a start up screen...
When Microsoft Word 2013 refuses to spell check it’s usually because it’s been disabled for the selected language in the...
if you've previously used Outlook 2007 or 2010 and have made the jump to 2013 you will notice that if...
The steps below detail how to open Outlook as a shared mailbox, so that the shared mailbox is the primary...
The steps below show how to embed an Excel spreadsheet in a Word document. This allows the data in the Excel spreadsheet...
The list below details the attachments that are blocked by default by Outlook 2013. To unblock the attachments, see Outlook...
The following steps detail how to tell which version of Office 2013 you have installed. It will show you how...
The following Excel formulas allow you to take a coumn with a full names (first name and last name) and separate the first and...
The following Excel formulas show how to calculate the number of days for: Days until date Days between dates Days...
The following formula will count unique numbers in a column – it does not count text. =SUM(IF(FREQUENCY(A2:A10,A2:A10)>0,1))
The following steps show how to add the BCC field to the Outlook 2013 message window. It applies to new...