10 Excel Quick Tips
Part one of a ten-part series of blogs

Some tasks in Excel always seem to take longer than they should - if only you knew a bunch of quick shortcuts to speed up the simple things. Read on to see how much time you could save!

  1. Excel Quick Tip #1 - Copying a Formula (this blog)
  2. Excel Quick Tip #2 - Putting Dollar Signs in a Formula
  3. Excel Quick Tip #3 - Adding Totals to Columns
  4. Excel Quick Tip #4 - Selecting a Table
  5. Excel Quick Tip #5 - Sorting a List
  6. Excel Quick Tip #6 - Creating Range Names
  7. Excel Quick Tip #7 - Creating a Chart
  8. Excel Quick Tip #8 - Copying a Worksheet
  9. Excel Quick Tip #9 - Entering Today's Date
  10. Excel Quick Tip #10 - Copying Days and Months

Posted by Andrew Gould on 02 December 2011

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Excel Quick Tip #1 - Copying a Formula

There are many ways to copy a formula down a column in Excel, but by far the quickest is to simply double-click on the AutoFill Handle.  To do this:

  1. Select the cell containing the formula you want to copy.
  2. Hover the mouse cursor over the AutoFill Handle.
The AutoFill Handle

Hover the mouse cursor over the bottom right-hand corner of the selected cell.

  1. Double-click on the AutoFill Handle to copy the formula down.
Copied formula

Excel will stop copying on the row before the next blank cell in the adjacent column.

 

You can see this technique in action in this video.

  1. Excel Quick Tip #1 - Copying a Formula (this blog)
  2. Excel Quick Tip #2 - Putting Dollar Signs in a Formula
  3. Excel Quick Tip #3 - Adding Totals to Columns
  4. Excel Quick Tip #4 - Selecting a Table
  5. Excel Quick Tip #5 - Sorting a List
  6. Excel Quick Tip #6 - Creating Range Names
  7. Excel Quick Tip #7 - Creating a Chart
  8. Excel Quick Tip #8 - Copying a Worksheet
  9. Excel Quick Tip #9 - Entering Today's Date
  10. Excel Quick Tip #10 - Copying Days and Months
This blog has 0 threads Add post