Monthly Archives: March 2015

Excel – How to split a column in 2 or 3

Do you have a column containing a full name, like this:-


….that you’d prefer to have separated into first and last name ?

It’s very simple to separate them using a few steps in Excel. Here’s how:- Read the rest of this entry

Using Excel’s Autofill feature to save time

If you need to fill in a range of headings, or a column of data, Autofill can really save you time. It can be used for consecutive numbering, days of the week, months of the year, years (such as 2014, 2015 …..) and much more. As long as you have at least the first 2 entries, Excel can generally guess how to continue the series.

Here’s an example of how you begin:-

Freeze panes - 1 Read the rest of this entry

MS Office – Quick Access Toolbar tip

By default, the Quick Access Toolbar is within the program’s Title Bar (as you’ll see in the screenshot below).

MS Office - Quick Access Toolbar 1A

Many users find the Quick Access Toolbar easier to use in a slightly different position – underneath the Ribbon as you can see here:- Read the rest of this entry