Build a sequence of numbers, text or dates quickly

You can build a sequence of numbers, text or dates within excel very quickly.  Simply enter the sequence you want to repeat as the example below:

5
10

Now drag over the two or more cells containing the pattern of sequence you want to create and select the black fill handle at the bottom right and drag down to create a sequence as below:

5
10
15
20
25
30
And so on …

VIDEO TIP BELOW



Stop your headings from disappearing with freeze panes

When you create a list in excel that ends up being quite large scrolling up and down can result in you not being able to see your headings.  This means that the information you see might not make a lot of sense.

To correct this you can use freeze panes.  Select the cell below the section you want to freeze and:

In Excel 2007 click View -> Window -> Freeze Panes
In Excel 2000 – 2003 click Window -> Freeze Panes

This function toggles on and off so to unfreeze panes use the same menu option and instead of freeze panes the option will be called unfreeze panes.

VIDEO TIP BELOW



Shortcut for inserting the dollar symbol into your Formulas $$

Instead of physically typing the dollar symbol into your cell reference when creating a formula, simply click on the part of the formula that you need the dollar symbols to be in and press F4 on your keyboard. If you continue to press F4 you will find that Excel will cycle through the different options for the dollar sign. E.g. $A$1 -> $A1 -> A$1 and back to A1.

This tip also works with refernces to other Excel Sheets or Workbooks.

VIDEO TIP BELOW



We are offering some FREE webinars too (see below)