Office 2016 Saturday, 24 June 2017 Outlook 2013/2016 – Unable to rotate attached image when forwarding attachments By default, when you open an attached image in Microsoft Outlook you are unable to use the rotate buttons, this... Excel 2016 – How to delete empty rows The following steps show how to remove empty rows from an Excel spreadsheet using Excel 2016. Note: this process does... 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 Excel 2016 – How to delete all empty columns The following steps show how to remove empty columns from an Excel spreadsheet using Excel 2016. Note: this process does... 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... Outlook 2016 – How to see folder for searched email Outlook has always been missing one important feature – the ability to see which folder an email is stored in.... 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... Microsoft Office version numbers The following table shows the version number for the last few versions of Microsoft Office. This is useful if you... Excel 2016 – Auto-sum not working until edit formula or save spreadsheet Problem When updating an Excel spreadsheet formulas do not update automatically as values are entered or updates. Instead the formula... Word 2016 – How to reduce file size by compressing images By default images added inside Word documents are not compressed, this can result in documents with embedded images getting extremely... 1 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 Outlook 2016 – How to launch in safe mode When Outlook is misbehaving – perhaps loading slow or a feature isn’t working as it should one of the first... 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 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... 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... Word 2016 – How to recover unsaved documents The following steps show how to recover an unsaved document in Word 2016. Open Word 2016 At the bottom left... 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... Excel 2016 – How to exclude (blank) values from pivot table If you need to create a pivot table chart on a range that includes blank rows you’ll end up with... Office 2016 – How to reset activation grace period If you’ve over used a trial install of Office you’ll find that it goes into a limited usage mode –... Word 2016 – How to add ALT text to images The following steps show how to add ALT text (alternative text) to images using Word 2016. The process is different... Excel 2016 – How to calculate age from date of birth The following formulas show how to calculate current age from a date of birth. Calculate age in years This formula... Excel 2016 – How to have pivot chart show only some columns The following steps show how to create a pivot table and chart that has two values (value and percent of... Excel 2016 – Formula to calculate age group from age The following formulas show how to calculate an age group from an age. This may be useful if you need... 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... PowerPoint 2016 – How to insert video into a slideshow Inserting a video into a PowerPoint slideshow allows you to create a single presentation file without having to keep the... 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... Excel 2016 – What is #DIV/0! error and how to fix it? The #DIV/0! error message means “divide by zero” – a division which is mathematically impossible, hence the error. When you see... Word 2016 – How to restrict/un-restrict formatting changes Microsoft Word has the ability to restrict a document so only existing styles can be applied to content – with... Excel 2016 – How to edit worksheet header/footer The following steps show how to edit a worksheet header/footer in Microsoft Excel. With the Excel document open, click on... PowerPoint 2016 – How to auto-play embedded video The following steps show how to set an embedded video to automatically play when the slide is loaded. If you... Excel 2016 – How to filter pivot table data The steps below will show how to hide data from a pivot table based on the value. In this example... 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... Excel – How to calculate the difference between two dates The following formulas show how to calculate the difference between two dates. The difference can be measured by: days months... 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... Excel – How to convert negative/positive numbers The following steps show how to bulk convert negative or positive numbers. Negative numbers (-1) become positive numbers (1) Positive... How to create named cell references in Excel 2016 Cell references in Excel formulas typically use their position in the worksheet – e.g. A2 for a single cell or... Word 2016 – Merge field codes always displayed Problem Any Word document opened that has merge fields – displays the full merge field code. For example, a field...
Outlook 2013/2016 – Unable to rotate attached image when forwarding attachments By default, when you open an attached image in Microsoft Outlook you are unable to use the rotate buttons, this...
Excel 2016 – How to delete empty rows The following steps show how to remove empty rows from an Excel spreadsheet using Excel 2016. Note: this process does... 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
Excel 2016 – How to delete all empty columns The following steps show how to remove empty columns from an Excel spreadsheet using Excel 2016. Note: this process does...
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...
Outlook 2016 – How to see folder for searched email Outlook has always been missing one important feature – the ability to see which folder an email is stored in....
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...
Microsoft Office version numbers The following table shows the version number for the last few versions of Microsoft Office. This is useful if you...
Excel 2016 – Auto-sum not working until edit formula or save spreadsheet Problem When updating an Excel spreadsheet formulas do not update automatically as values are entered or updates. Instead the formula...
Word 2016 – How to reduce file size by compressing images By default images added inside Word documents are not compressed, this can result in documents with embedded images getting extremely... 1
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
Outlook 2016 – How to launch in safe mode When Outlook is misbehaving – perhaps loading slow or a feature isn’t working as it should one of the first...
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
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...
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...
Word 2016 – How to recover unsaved documents The following steps show how to recover an unsaved document in Word 2016. Open Word 2016 At the bottom left...
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...
Excel 2016 – How to exclude (blank) values from pivot table If you need to create a pivot table chart on a range that includes blank rows you’ll end up with...
Office 2016 – How to reset activation grace period If you’ve over used a trial install of Office you’ll find that it goes into a limited usage mode –...
Word 2016 – How to add ALT text to images The following steps show how to add ALT text (alternative text) to images using Word 2016. The process is different...
Excel 2016 – How to calculate age from date of birth The following formulas show how to calculate current age from a date of birth. Calculate age in years This formula...
Excel 2016 – How to have pivot chart show only some columns The following steps show how to create a pivot table and chart that has two values (value and percent of...
Excel 2016 – Formula to calculate age group from age The following formulas show how to calculate an age group from an age. This may be useful if you need...
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...
PowerPoint 2016 – How to insert video into a slideshow Inserting a video into a PowerPoint slideshow allows you to create a single presentation file without having to keep the...
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...
Excel 2016 – What is #DIV/0! error and how to fix it? The #DIV/0! error message means “divide by zero” – a division which is mathematically impossible, hence the error. When you see...
Word 2016 – How to restrict/un-restrict formatting changes Microsoft Word has the ability to restrict a document so only existing styles can be applied to content – with...
Excel 2016 – How to edit worksheet header/footer The following steps show how to edit a worksheet header/footer in Microsoft Excel. With the Excel document open, click on...
PowerPoint 2016 – How to auto-play embedded video The following steps show how to set an embedded video to automatically play when the slide is loaded. If you...
Excel 2016 – How to filter pivot table data The steps below will show how to hide data from a pivot table based on the value. In this example...
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...
Excel – How to calculate the difference between two dates The following formulas show how to calculate the difference between two dates. The difference can be measured by: days months...
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...
Excel – How to convert negative/positive numbers The following steps show how to bulk convert negative or positive numbers. Negative numbers (-1) become positive numbers (1) Positive...
How to create named cell references in Excel 2016 Cell references in Excel formulas typically use their position in the worksheet – e.g. A2 for a single cell or...
Word 2016 – Merge field codes always displayed Problem Any Word document opened that has merge fields – displays the full merge field code. For example, a field...