Office 2013 Saturday, 23 August 2014 Outlook 2013 – How to clear the auto-complete cache Outlook 2013 (as well as 2007 and 2010) has the ability to remember the email addresses you use, then list them... Excel 2013 – How to paste comma-separated values The steps below show how to paste comma-separated values directly into an Excel 2013 file. This method uses a built... Outlook 2013 – Not showing old emails that are on the server Problem When using Outlook 2013 connected to an Exchange service and using cache mode not all emails are available through... Word 2013 – How to remove links to other files If you see the following message when opening a Word document it means the document has been linked to another... 2 How to remove mail merge data source from Word document The following steps show how to remove the link between a Word document and a mail merge data source. When... 1 Word 2013 – How to recover corrupt DOCX documents The following steps detail how I recover DOCX files that have become corrupted. This process will only work for DOCX... 5 How to export Outlook auto-complete to Excel list In Outlook when you send an email the address is remembered and added to an ‘auto-complete’ list. The next time... Fix Outlook images not displaying in emails Problem When viewing emails in Outlook, embedded images do display. Instead a square and a red X are seen. Solution The... Outlook 2013 – How to force a manual Global Address Book (GAL) update When connected to an Exchange server, Outlook will automatically synchronize the address book once every 24 hours. However, if you... 1 Microsoft Office version numbers The following table shows the version number for the last few versions of Microsoft Office. This is useful if you... Outlook 2013 – How to check the size of a mailbox These steps detail how to check the size of a mailbox using Outlook 2013. The same steps can be used... Outlook 2013 – How to add From field to message window The following steps show how to add the From field to the Outlook 2013 message window. It applies to new... Word 2013 – How to remove mystery line at top of bottom of document If you’ve found a black line at the top of bottom of your document and you can’t work... 4 Outlook 2013 – How to recall sent messages We’ve all been there – having sent an email without an attachment, with a typo or to the wrong person... [SOLVED] Word 2013 – Word cannot start the converter PDF files Problem Word 2013 introduced a new feature – the ability to open and edit PDF files. This issue is is... Word 2013 – Unable to insert hyperlink into message Problem When attempting to insert a hyperlink in a message you find that the options are greyed out and you... Word – mail merge field changes format (font/size) when merged Problem When running a mail merge in Microsoft Word some merge fields change format. For example, the font or size... 1 Access 2013 – How to fix broken references Problem After migrating from an earlier version of Office to Office 2013 some Access databases do not load or do... Outlook 2013/2016 – Where is the auto-complete list stored? 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... Word 2013 & 2016 – Table ‘repeat header row’ not working Keeping true to being the source of much frustration for anyone wanting to do complicated formatting, Word 2013 has at... 13 [SOLVED] How to uninstall ‘Office 15 Click-to-Run Extensibility Component’ Problem When attempting to install Office 2013 you recieve an error message which reads: Setup Error We can't install the... 16 Outlook 2013 – How to add week numbers to the calendar If your work schedule runs in week numbers or you regually need to count out week numbers then this tip... 1 Word – how to mail merge many records to individual documents I use Microsoft Word’s mail merge feature often. It works great for connecting into a database and spitting out all... Word 2013 – How to disable update linked document message If you see the following message when opening a Word document it means the document has been linked to another... 1 Outlook 2013 – How to remove mailbox delegate These steps show how to remove a delegate using Outlook 2013. Delegate access is typically done for a calendar, allowing... Access 2013 – How to auto-increment table primary key When creating a table in Microsoft Access it is important that the table is correctly setup with a primary key... Outlook/Word 2013 – How to disable Reading View for read-only Word documents One of the more annoying ‘features’ of Word 2013 is ‘Reading View’ – where any document you open that is... 6 Outlook 2013 – Error: Outlook is syncronizing local changes made to changes in this folder Problem: When using Outlook 2013 in cached mode you’re unable to delete a folder. When you try you see the... 1 Excel 2013/2016 – How to change CSV delimiter character By default when saving a CSV file in Excel, each column will be separated using a comma as the delimiter... [SOLVED] Word 2013 – Spell check not working When Microsoft Word 2013 refuses to spell check it’s usually because it’s been disabled for the selected language in the... 7 [SOLVED] Outlook 2013 – Email signature changing colour for replies Problem The email signature in new emails is the correct colour, for example black, but when replying to emails the... Access 2013 – How to draw a vertical margin line when fields can grow In access 2013 you can use a ‘line’ object to draw horizontal or vertical lines. Typically you would draw a... Outlook 2013 – How to unblock ‘potentially unsafe’ attachments By default Outlook 2013 blocks a large number of attachments based on their file extension (the part after the file... 1 Word 2013 – How to enable the page ruler Unlike previous versions of Microsoft Word, the on screen page ruler is not enabled by default. To enable it you... Word 2013 – How to enable spell checking for all new documents When Microsoft Word 2013 refuses to spell check it’s usually because it’s been disabled for the selected language in the... Word 2013 – How to split window and view two sections of document at the same time One of the many subtle changes in Office 2013 is removing the split window option from the toolbar in Word... 3 Word 2013 – How to compare two document for differences Since Office 2007, Word has offered the two ways to compare two Word documents for differences. This is useful if... [SOLVED] Word 2013 – Paragraph moving to next page Problem Using Word 2013, a paragraph is breaking onto a new page automatically rather than splitting across two pages. This... Excel 2013 – How to create drop down lists A drop down list allows you to enter data into an Excel spreadsheet from a pre-set list of entries. This... Excel 2016 – Fill in missing numbers in a range The following process shows how to fill missing numbers in a range. For example, if we had an excel table... Excel 2013 – How to start new paragraph in a cell (add a line break) To add a new paragraph inside a cell all you need to do is hold Alt and press Enter on... Excel 2013/2016 – How to split comma separated values into columns The following steps show how to split comma separated values from one column into many. In this example we’ll focus... Access 2013 – How to make report fields grow (multi-line field) The following steps detail how to make a report in Microsoft Access 2013 grow to use more than the default... Word 2013 – How to recover unsaved documents The following steps show how to recover an unsaved document in Word 2013. Open Word 2013 At the bottom left... Outlook/Word 2013 – Unable to open links Problem When clicking on web links in Outlook messages or Word documents you see the following message This operation has... Word – Table won’t paste in new location Problem When copying and pasting a table in Microsoft Word, the pasted table seems to not appear. When looking closer... Word 2013 – How to change text case – Title, CAPS, lower-case Unlike previous versions of Word, Word 2013 doesn’t provide a menu option for changing the case of any select text... Excel 2013 – How to select unique values from column The steps below detail how to take a column of values, some that are duplicates, and to list the unique... Word 2013 – How to link an Excel spreadsheet The steps below show how to link a Word document with an Excel spreadsheet. This allows the data in the Excel... Access 2013 – Change Order By for report data When creating reports in Access 2013 you’ll notice that the report data appears to have a mind of its own when... Outlook 2013 – How to change the colour scheme The default Office 2013 colour design and colour palette is arguably the blandest yet. Fortunately there are options to customise... Excel – how to separate first name and last name from a full name The following Excel formulas allow you to take a coumn with a full names (first name and last name) and separate the first and... Outlook 2013 – How to remove background colours or stationery templates in replies The steps below show how to remove a background colour that has been applied to an email you received and... Outlook 2013 – How to view email header info (MX records) To view header information in Outlook 2013: Open the email in a new window (this is important – the same... Word 2013 – How to embed an Excel spreadsheet The steps below show how to embed an Excel spreadsheet in a Word document. This allows the data in the Excel spreadsheet... Outlook 2013 – How to open Outlook as shared mailbox The steps below detail how to open Outlook as a shared mailbox, so that the shared mailbox is the primary... Outlook 2013 – How to turn off message preview Outlook 2013 has introduced a new feature called 'message preview' which allows you to display the first 1, 2 or... Word 2016 – How to show merge tags The following keyboard commands can be used to display merge tags. How to show a specific merge tag Select the... Outlook 2013 – List of blocked attachments The list below details the attachments that are blocked by default by Outlook 2013. To unblock the attachments, see Outlook... Word 2013 – Accessibility checker – What is ‘unclear hyperlink text’ Word 2013 offers an accessibility checker to assess your documents and suggest changes that will make the document more... 1 Word 2016 – How to change text case Word has a handy keyboard command which allows you to change the text case of selected text. It allows you... How to tell which version of Office 2013 you have installed The following steps detail how to tell which version of Office 2013 you have installed. It will show you how... Outlook 2013 – Automatically ‘Pop Out’ / Open replies and forwards in new window if you've previously used Outlook 2007 or 2010 and have made the jump to 2013 you will notice that if... Word 2013 – How to disable the start up screen New to Office 2013, when you open an Office product (Word, PowerPoint, Excel etc) you see a start up screen... Word 2013 – Disable Reading/Protect Mode To disable the Reading View. With Word 2013 open Go to File -> Options -> General Uncheck Open E-Mail attachments... Excel 2013 – Formula to count unique numbers in column The following formula will count unique numbers in a column – it does not count text. =SUM(IF(FREQUENCY(A2:A10,A2:A10)>0,1)) Outlook 2013 – How to create an email signature With Outlook 2013 open, click on the ‘File’ menu Click on ‘Options’ On the left hand menu, click ‘Mail’ and... Outlook 2013 – How to add BCC field to message window The following steps show how to add the BCC field to the Outlook 2013 message window. It applies to new...
Outlook 2013 – How to clear the auto-complete cache Outlook 2013 (as well as 2007 and 2010) has the ability to remember the email addresses you use, then list them...
Excel 2013 – How to paste comma-separated values The steps below show how to paste comma-separated values directly into an Excel 2013 file. This method uses a built...
Outlook 2013 – Not showing old emails that are on the server Problem When using Outlook 2013 connected to an Exchange service and using cache mode not all emails are available through...
Word 2013 – How to remove links to other files If you see the following message when opening a Word document it means the document has been linked to another... 2
How to remove mail merge data source from Word document The following steps show how to remove the link between a Word document and a mail merge data source. When... 1
Word 2013 – How to recover corrupt DOCX documents The following steps detail how I recover DOCX files that have become corrupted. This process will only work for DOCX... 5
How to export Outlook auto-complete to Excel list In Outlook when you send an email the address is remembered and added to an ‘auto-complete’ list. The next time...
Fix Outlook images not displaying in emails Problem When viewing emails in Outlook, embedded images do display. Instead a square and a red X are seen. Solution The...
Outlook 2013 – How to force a manual Global Address Book (GAL) update When connected to an Exchange server, Outlook will automatically synchronize the address book once every 24 hours. However, if you... 1
Microsoft Office version numbers The following table shows the version number for the last few versions of Microsoft Office. This is useful if you...
Outlook 2013 – How to check the size of a mailbox These steps detail how to check the size of a mailbox using Outlook 2013. The same steps can be used...
Outlook 2013 – How to add From field to message window The following steps show how to add the From field to the Outlook 2013 message window. It applies to new...
Word 2013 – How to remove mystery line at top of bottom of document If you’ve found a black line at the top of bottom of your document and you can’t work... 4
Outlook 2013 – How to recall sent messages We’ve all been there – having sent an email without an attachment, with a typo or to the wrong person...
[SOLVED] Word 2013 – Word cannot start the converter PDF files Problem Word 2013 introduced a new feature – the ability to open and edit PDF files. This issue is is...
Word 2013 – Unable to insert hyperlink into message Problem When attempting to insert a hyperlink in a message you find that the options are greyed out and you...
Word – mail merge field changes format (font/size) when merged Problem When running a mail merge in Microsoft Word some merge fields change format. For example, the font or size... 1
Access 2013 – How to fix broken references Problem After migrating from an earlier version of Office to Office 2013 some Access databases do not load or do...
Outlook 2013/2016 – Where is the auto-complete list stored? 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...
Word 2013 & 2016 – Table ‘repeat header row’ not working Keeping true to being the source of much frustration for anyone wanting to do complicated formatting, Word 2013 has at... 13
[SOLVED] How to uninstall ‘Office 15 Click-to-Run Extensibility Component’ Problem When attempting to install Office 2013 you recieve an error message which reads: Setup Error We can't install the... 16
Outlook 2013 – How to add week numbers to the calendar If your work schedule runs in week numbers or you regually need to count out week numbers then this tip... 1
Word – how to mail merge many records to individual documents I use Microsoft Word’s mail merge feature often. It works great for connecting into a database and spitting out all...
Word 2013 – How to disable update linked document message If you see the following message when opening a Word document it means the document has been linked to another... 1
Outlook 2013 – How to remove mailbox delegate These steps show how to remove a delegate using Outlook 2013. Delegate access is typically done for a calendar, allowing...
Access 2013 – How to auto-increment table primary key When creating a table in Microsoft Access it is important that the table is correctly setup with a primary key...
Outlook/Word 2013 – How to disable Reading View for read-only Word documents One of the more annoying ‘features’ of Word 2013 is ‘Reading View’ – where any document you open that is... 6
Outlook 2013 – Error: Outlook is syncronizing local changes made to changes in this folder Problem: When using Outlook 2013 in cached mode you’re unable to delete a folder. When you try you see the... 1
Excel 2013/2016 – How to change CSV delimiter character By default when saving a CSV file in Excel, each column will be separated using a comma as the delimiter...
[SOLVED] Word 2013 – Spell check not working When Microsoft Word 2013 refuses to spell check it’s usually because it’s been disabled for the selected language in the... 7
[SOLVED] Outlook 2013 – Email signature changing colour for replies Problem The email signature in new emails is the correct colour, for example black, but when replying to emails the...
Access 2013 – How to draw a vertical margin line when fields can grow In access 2013 you can use a ‘line’ object to draw horizontal or vertical lines. Typically you would draw a...
Outlook 2013 – How to unblock ‘potentially unsafe’ attachments By default Outlook 2013 blocks a large number of attachments based on their file extension (the part after the file... 1
Word 2013 – How to enable the page ruler Unlike previous versions of Microsoft Word, the on screen page ruler is not enabled by default. To enable it you...
Word 2013 – How to enable spell checking for all new documents When Microsoft Word 2013 refuses to spell check it’s usually because it’s been disabled for the selected language in the...
Word 2013 – How to split window and view two sections of document at the same time One of the many subtle changes in Office 2013 is removing the split window option from the toolbar in Word... 3
Word 2013 – How to compare two document for differences Since Office 2007, Word has offered the two ways to compare two Word documents for differences. This is useful if...
[SOLVED] Word 2013 – Paragraph moving to next page Problem Using Word 2013, a paragraph is breaking onto a new page automatically rather than splitting across two pages. This...
Excel 2013 – How to create drop down lists A drop down list allows you to enter data into an Excel spreadsheet from a pre-set list of entries. This...
Excel 2016 – Fill in missing numbers in a range The following process shows how to fill missing numbers in a range. For example, if we had an excel table...
Excel 2013 – How to start new paragraph in a cell (add a line break) To add a new paragraph inside a cell all you need to do is hold Alt and press Enter on...
Excel 2013/2016 – How to split comma separated values into columns The following steps show how to split comma separated values from one column into many. In this example we’ll focus...
Access 2013 – How to make report fields grow (multi-line field) The following steps detail how to make a report in Microsoft Access 2013 grow to use more than the default...
Word 2013 – How to recover unsaved documents The following steps show how to recover an unsaved document in Word 2013. Open Word 2013 At the bottom left...
Outlook/Word 2013 – Unable to open links Problem When clicking on web links in Outlook messages or Word documents you see the following message This operation has...
Word – Table won’t paste in new location Problem When copying and pasting a table in Microsoft Word, the pasted table seems to not appear. When looking closer...
Word 2013 – How to change text case – Title, CAPS, lower-case Unlike previous versions of Word, Word 2013 doesn’t provide a menu option for changing the case of any select text...
Excel 2013 – How to select unique values from column The steps below detail how to take a column of values, some that are duplicates, and to list the unique...
Word 2013 – How to link an Excel spreadsheet The steps below show how to link a Word document with an Excel spreadsheet. This allows the data in the Excel...
Access 2013 – Change Order By for report data When creating reports in Access 2013 you’ll notice that the report data appears to have a mind of its own when...
Outlook 2013 – How to change the colour scheme The default Office 2013 colour design and colour palette is arguably the blandest yet. Fortunately there are options to customise...
Excel – how to separate first name and last name from a full name The following Excel formulas allow you to take a coumn with a full names (first name and last name) and separate the first and...
Outlook 2013 – How to remove background colours or stationery templates in replies The steps below show how to remove a background colour that has been applied to an email you received and...
Outlook 2013 – How to view email header info (MX records) To view header information in Outlook 2013: Open the email in a new window (this is important – the same...
Word 2013 – How to embed an Excel spreadsheet The steps below show how to embed an Excel spreadsheet in a Word document. This allows the data in the Excel spreadsheet...
Outlook 2013 – How to open Outlook as shared mailbox The steps below detail how to open Outlook as a shared mailbox, so that the shared mailbox is the primary...
Outlook 2013 – How to turn off message preview Outlook 2013 has introduced a new feature called 'message preview' which allows you to display the first 1, 2 or...
Word 2016 – How to show merge tags The following keyboard commands can be used to display merge tags. How to show a specific merge tag Select the...
Outlook 2013 – List of blocked attachments The list below details the attachments that are blocked by default by Outlook 2013. To unblock the attachments, see Outlook...
Word 2013 – Accessibility checker – What is ‘unclear hyperlink text’ Word 2013 offers an accessibility checker to assess your documents and suggest changes that will make the document more... 1
Word 2016 – How to change text case Word has a handy keyboard command which allows you to change the text case of selected text. It allows you...
How to tell which version of Office 2013 you have installed The following steps detail how to tell which version of Office 2013 you have installed. It will show you how...
Outlook 2013 – Automatically ‘Pop Out’ / Open replies and forwards in new window if you've previously used Outlook 2007 or 2010 and have made the jump to 2013 you will notice that if...
Word 2013 – How to disable the start up screen New to Office 2013, when you open an Office product (Word, PowerPoint, Excel etc) you see a start up screen...
Word 2013 – Disable Reading/Protect Mode To disable the Reading View. With Word 2013 open Go to File -> Options -> General Uncheck Open E-Mail attachments...
Excel 2013 – Formula to count unique numbers in column The following formula will count unique numbers in a column – it does not count text. =SUM(IF(FREQUENCY(A2:A10,A2:A10)>0,1))
Outlook 2013 – How to create an email signature With Outlook 2013 open, click on the ‘File’ menu Click on ‘Options’ On the left hand menu, click ‘Mail’ and...
Outlook 2013 – How to add BCC field to message window The following steps show how to add the BCC field to the Outlook 2013 message window. It applies to new...