Shortcut in Excel

What is the shortcut to copy anything from one cell to the next 200 rows in the same column? I use shift + Page down but it takes me a while. Is there a way I can do it just in one click?
mustish1Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Wayne Taylor (webtubbs)Commented:
No, you'll need several clicks. First, select the last cell (that you want to copy) and the next 200 cells down. Then from the Home tab, select Fill > Down. Alternatively, use the keyboard shortcut Ctrl+D.
1
AlanConsultantCommented:
Hi mustish1,

As mentioned above, there is no 'single click' way to do that, since there is no way for Excel to know that you want to fill down 200 cells, rather than 100 or 500 or whatever.

This is what I usually do (I'll assume your original cell to be copied is A1, and you want to copy that down to A2:A201):

Copy A1 (Ctrl-C
GoTo A201 (F5, A201, Enter)
Select A201 to A1 (Hold down Shift + Ctrl + UpArrow)
Paste (Ctrl-V)

Open in new window

This assumes all the cells below the source cell down to the end of the range you want to paste to are all empty.

I never use the mouse in Excel unless I have to - it just kills productivity.

Alan.
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Roy CoxGroup Finance ManagerCommented:
Whats in the adjacent cells? If they contain data in a table format down to the 200th Row then hover the cursor over the bottom left corner of the first cell to copy and double click. The contents will copy down to the end of the data
1
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.

Shaun VermaakTechnical Specialist/DeveloperCommented:
You can use named ranges if you are working with the same ranges frequently (click on the image if gif don't play automatically)
NamedRange.gif
1
Rob HensonFinance AnalystCommented:
@Roy - Bottom right, not left.
1
Rob HensonFinance AnalystCommented:
As per Alan's suggestion the F5 key can be used to take the cursor to a specific cell or range but the method below will reduce the number of key strokes.

If you are in A1 and know that you need to select from A1 to A201. With the cursor in A1, press F5 and type A201 in the range box at the bottom of the pop-up window. Before pressing Enter or Clicking OK, press and hold the Shift key and then press Enter; A1 to A201 will then be selected.
1
mustish1Author Commented:
Thank You
0
Roy CoxGroup Finance ManagerCommented:
Pleased to help
1
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
VB Script

From novice to tech pro — start learning today.

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.