• Status: Solved
  • Priority: High
  • Security: Public
  • Views: 57
  • Last Modified:

Drag a formula to the last row faster

Drag a formula to the last row faster

I have an excel spreadshet with so many rows, I put a formula on the first cell and need to drag it all the way to the last row. It takes forever to drag it to the last row. I wonder if there is an easy way to do it.

Thank you
0
jskfan
Asked:
jskfan
2 Solutions
 
ShumsDistinguished Expert - 2017Commented:
Hi,

One way:
  1. Select the adjacent cell which has the longest row
  2. Press Cntrl+Down Arrow Key
  3. Move cursor to the cell where you have formula column
  4. Press Shift+Ctrl+Up Arrow Key
  5. Press Ctrl+D
Second Way:
  1. Select the adjacent cell which has the longest row
  2. Press Cntrl+Down Arrow Key
  3. Move cursor to the cell where you have formula column
  4. Press Shift+Ctrl+Up Arrow Key
  5. Navigate to Home/Fill
  6. Press Down
Third Way:
  1. Select the first cell with formula
  2. Select the lower right corner with + sign
  3. Double Click
2
 
Roy CoxGroup Finance ManagerCommented:
Select the cell with the formula, Hover the cursor over the bottom right corner and double click when the cursor turns to a cross hair shape (+). The formula will fill down to the bottom row  containing data. Note this will only work if he data is in a classic table format.

The best way is to use the Format as Table option introduced into newer versions of Excel. Read this and look at using calculated columns.

Introduction to Excel Tables
0
 
jskfanAuthor Commented:
Thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now