Tag Archives: Tutorial

Excel – hiding, unhiding and finding hidden Columns and Rows

SharynAvatarBlog120x120You can easily hide rows and columns in Excel.  However sometimes it isn’t obvious where columns and rows have been hidden.

In this tutorial I show you how to hide and unhide columns and rows and how to easily locate where columns and rows have been hidden in a worksheet. Continue reading Excel – hiding, unhiding and finding hidden Columns and Rows

Upgrading – customising the Quick Access Toolbar and Ribbon

Office2010Let’s face it, upgrading to a newer version of  MS Office offers so many fabulous features that we really shouldn’t grizzle. However I’m sure you will agree with me that one of the most frustrating things about upgrading to is trying to locate the command buttons you use most often. And just when you think you their new location sorted you lose them again! Continue reading Upgrading – customising the Quick Access Toolbar and Ribbon

Outlook Categories – using colour to organise messages, tasks and appointments

1oCategories allow you to quickly organise your Outlook items using colour coding. If you have recently upgraded from an earlier version of Outlook you may have made use of coloured flags to organise your items. Coloured flags are now replaced by Categories. Continue reading Outlook Categories – using colour to organise messages, tasks and appointments

Excel – Copying or moving entire worksheets between workbooks

1xI’ve had a number of requests to cover copying entire worksheets between files. The number one problem seems to be when the data is pasted into the new worksheet Excel doesn’t resize the column widths to fit the pasted data. Instead the columns seem to reset themselves back to the default width. Possibly the best way to avoid this happening is to use the Move and Copy command in Excel. Continue reading Excel – Copying or moving entire worksheets between workbooks

Excel – Working with merged cells (merging and fixing problems)

1xEver tried to centre a heading over the top of a number of columns? It can be a little frustrating, especially when you can’t quite get it to sit as you would like. Last month saw me running multiple Stage 1 Excel courses and it reminded me that this problem frustrates so many. I love hearing the “oh wows” when I show the class how the Merge and Center command allows you to easily centre headings over tables of data. Continue reading Excel – Working with merged cells (merging and fixing problems)

Word – adding the document filename and pathname in a Header or Footer

SharynAvatarBlog120x120Today I delivered Office 2010 upgrade training and during the session I was asked to demonstrate how to add the file name and path name of a Word document into a Header or Footer. Unfortunately this isn’t a simple “one-click” process so I thought it would be an excellent tutorial to share.

Continue reading Word – adding the document filename and pathname in a Header or Footer