Tag: Excel Tips

Posted on

Automatically Numbering Rows

Have you ever wanted to automatically number rows of data in Excel?
One way to do this is by using the Row function.

For example, type a heading such as ID into A1 then in A2 type the formula

=Row()-1

 

In this example suppose you want the numbers to be inserted automatically as you add new rows of data. This can be done by turning the data into an ExceI Table.

Click Home, Format as Table.

Select Table Tools Design then tick Total Row.

When you insert a new in the Total Row a new ID number will be inserted.

Note:The ID numbers will be updated if you sort, insert or delete rows of data.

 

Posted on

Change the Colour of 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!