Excel - Dragging a formula to the Right or Down Side

Hi Experts

I have an excel sheet in which I have the data for a large number of items. Many times I have to apply the same formula on large cell ranges. I find it pretty hard to drag the mouse to large ranges, and I have to do such thing quite often.

Please suggest some easy method by which the formula given in Cell B1 can be easily dragged to the right hand side for the last cell located at -
Row B - column number 120
Row B - column number 180
Row B - column number 550

I do not want to manually drag the formula cell to those 3 locations manually.

Please suggest some short cut keys or some other method. And what if I had to drag the formulas down and not towards the right hand side ? I know, simply clicking on the bottom right corner of the cell, copies it ALL THE WAY DOWN to the last cell in the adjacent column, but what if I have to move it down to just specific cells like -

Column B - Row 50
Column B - Row 220
Column B - Row 785

Please suggest various methods by which this could be done.
Any ideas are most welcome.

I am using the following software versions -
Microsoft SQL Server Management Studio version- 12.0.2000.8,
Microsoft Office 2016 x64
and Windows 7 x64

Thanks

Microsoft Excel

Last Comment

Richard Daneke

8/22/2022 - Mon

SOLUTION

Rgonzo1971

9/12/2016

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

happy 1001

9/14/2016

ASKER

Thanks for the suggestions @Rgonzo1971

I thought that maybe I should upload the sample file itself, so that I can express my requirement properly. As I need to find the method, which could be used, when we do not know the exact end point beforehand.

In the attached sample file, I need to drag to the Right Hand, the formulas in the cells H11 and H12 respectively. And drag formulas to the downside, in case of cell H29. I have highlighted these cells differently, so you could understand it in an instant.

Please suggest which method would work in these cases.

Thanks a lot
Dragging-the-Formula-to-Right-Side.xlsx

Rgonzo1971

9/14/2016

If you have a help like in cell H11 un can select H10 CTRL+Arrow-Right Arrow-Down
Ctrl+Shift+Arrow Left and then Ctrl+R to fill to the right

happy 1001

9/15/2016

ASKER

Thanks for your comments @Rgonzo1971, but unfortunately it is not working.

Can some other expert please give it a try. The above mentioned solution is not working for me. When I do it, it simply takes me to the Very Right Hand Side of the complete worksheet, which is column named XFD in my case.

Please someone suggest a working solution in the sample file.

Thanks a lot

All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat

William Peck

Rgonzo1971

9/15/2016

You have to use the Ctrl Arrows where the cells are populated

happy 1001

9/15/2016

ASKER

Yes I used Ctrl arrow. Can someone please check if I am the only one who is not being able to get it to work, or if this method does not works on other machines as well ?

Thanks a lot

Rgonzo1971

9/15/2016

is your scroll lock on?

⚡ FREE TRIAL OFFER

Try out a week of full access for free.

Find out why thousands trust the EE community with their toughest problems.

happy 1001

9/19/2016

ASKER

no the scroll lock is not on.

Rgonzo1971

9/19/2016