Excel Tip: Quick Fill Down

Excel is THE tool for accountants. There is rarely a day that will go by without using Excel. Each Monday, this blog will post a time saving tip that is helpful. Enjoy the first tip!

In larger spreadsheets, I used to spend lots of time dragging the cursor down a column to extend a formula for hundreds of rows. This trick will save lots of frustration and TIME!

By simply double-clicking on the Fill Handle in the lower right-hand corner of the cell, the formula will copy down the column.

NOTE: The column to the left of the formula needs to contain data. If there is a blank cell in the column to the left, the formula will stop at that row. In other words, the data in the adjacent column must not contain empty cells within the data.

I hope this tip saves you as much time as it has saved me!

Leave a comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: