Bookmark page
Printable version
Course updates
|
RSS feeds
Hints and tips home » Excel hints and tips » Copying Formulae Quickly
Copying Formulae Quickly
There is a quicker way of copying a formula down a column.
Just point and double click on the black autofill handle in the right hand corner of a cell.
This will work providing you have some data in the column to the left of the column.
Sandy
Added by Sandy on 17th December 2007
More Excel hints and tips, like:
- Copying the same value, label or formula quickly into a range of selected cells.
- Apply currency format quickly in Excel
- Recovering Unsaved Work in Excel 2010
 |
Four Electronic Tools For Better Time Management Before you plan on better time management, it might be an idea to see what tools you already have at your disposal. Here are four ways you could use electronics - that you probably already own - to improve your time management even more. » Article: Time management london |
» Forum post: Excel in general |
|
How do you ensure that when Excel opens, it has today's date and it updates the date as and when you access the programme every single day?
Use the keyboard shortcut Ctrl+9 to hide selected rows and Ctrl+0 to hide selected columns. The good thing about this shortcut is that you do not need to select entire rows or columns. For example, select B3:D3 then press Ctrl+0 to hide columns B to D.
