Category Archives: Excel

Upgrading to Office 2013 – Why are the Ribbon commands hidden?

1uIf you have recently upgraded to Office 2013 you will have noticed that the Ribbon is collapsed by default, and only the Ribbon tabs are visible. As a result one of the first questions I get asked when doing upgrade training is “why are the Ribbon commands hidden and how do I get them back”? Continue reading Upgrading to Office 2013 – Why are the Ribbon commands hidden?

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

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)