Solved

Excel - Copy Formulas in multiple columns

Posted on 2011-03-15
3
295 Views
Last Modified: 2012-05-11
Hi,

In a spreadsheet, I have formulas in Columns A - Q in row 1. I want to copy each of the columns formulas down to row 200000 in Excel 2007.

Currently, I can only do this one column at a time, but going to the cell locator box, typing A1:A200000, Ctrl D, and Enter.

Is there a way to achieve this for all columns at once?

Thank you
0
Comment
Question by:tahirih
  • 2
3 Comments
 
LVL 81

Accepted Solution

by:
zorvek (Kevin Jones) earned 500 total points
Comment Utility
I select cells A1:Q1, copy, select A2:Q200000, and paste.

Kevin
0
 
LVL 81

Assisted Solution

by:zorvek (Kevin Jones)
zorvek (Kevin Jones) earned 500 total points
Comment Utility
The same thing will work if you use your technique but enter A1:Q200000.

Kevin
0
 

Author Closing Comment

by:tahirih
Comment Utility
Thank you.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now