Tag Archives: YA

Excel Courses – Change the Colour of the Tabs in an Excel 2010 Worksheet

Here’s a brief tip on how to instantly brighten up your Excel spreadsheet with very little effort.

By changing the colours of the tabs, your Excel Worksheet will change from being dull and boring to exciting and colourful! It will also help in organization, being particularly useful when organizing all your Excel Worksheets relating to a paricular period or year, for example.

Click the Cells group in the Home tab, open Format options and then select a colour of your choice from the pop up menu which appears.

 

Another and probably even quicker way of doing this is:

Right click a tab

Select Tab Colour

And choose your favourite colour!


Excel Courses – View two Excel 2010 Workbooks at the same time

Here’s how to view two Excel 2010 workbooks at the same time, side by side, a very useful tip when you want to compare data without having to go back and forth!

1) Open both Excel workbooks

2) Select Window then select Compare Side by Side with (Spreadsheet 2)

 

3) When you have finished, select Window again and click Close Side by Side

Excel Courses – Filtering Data in an Excel 2010 Worksheet

When you have an Excel Worksheet with masses of data, it’s not going to be easy to sift through it. So, in order to view sections of data, you can use the filter tool. Select the cells you want to filter (no need to select the column headers), then click the Home tab on the Ribbon, click Sort and Filter (you will find this in the Editing Section) then click Filter.

You will now see arrows in the top row of all the columns. If you click on an arrow, it will give you some filtering options so you can sort your data into ”Smallest to Largest” or ”Oldest to Newest” and so on..


To turn off the filtering, go back to the Home tab and click the Filter button again.

Excel Courses – Rotating Text For Better Effects in Excel 2010

If you want to make your Excel Worksheet appear a little less dull, or maybe you want to draw attention to a certain section of text, why not try rotating the text.

And here’s how you can do it..

- Select the cell with the text in you would like to rotate.

- Click the Home tab on the Ribbon

- Then click a button which has the letters ”ab” (otherwise known as the ”Orientation” button)

- A pop up menu will then appear giving you choices on different rotations.

- If you want more control over the rotation, click Format Cell Alignment. Here, you can enter the number of degrees you wish to rotate the text.

It’s a simple as that but can add a whole new style to your Excel Worksheet.