Tech Support
Local Repair
Reviews & Ratings

Join | Answer Questions | Sign In

Help me with
Search
Home | Business and Productivity Software | Want to copy formula int...
Business and Productivity Software
Problem for Business and Productivity Software
Generic problem for all Business and Productivity Sof...

Want to copy formula into multiple exc...




By anurag_2003 on Jul 29, 2009

" "
Want to copy multiple formula into multiple excel sheets. Can we use macros for it?
Ads by Google

Solution #1

posted on Aug 08, 2009
Not Rated)

danilomanjr
danilomanjr

Rank: Wiz 
Rating: 80%, 19 votes
why not? however, you can also insert an apostrophe (') at the start of the equation before copying the entire formula so that the formula will be treated as a text thus preserving all cell references. dont forget to remove the apostrophes after you have pasted them though for the formulas to work again.
Was this helpful?
Yes
No

This Problem Also Relates To: Sony Media Software Pictures Sound Effects Series - Volumes 1 to 5 Volume License (SSDS2000) Sony American Idol Extreme Music Creator Promo/Demo License for PC (2205808) Apple iPlayMusic Beginner Guitar Lessons Full Version for Mac Encore Mavis Beacon Teaches Typing Deluxe 20 Full Version for PC Encore Family Tree Maker 2008 Deluxe for PC (705381148500) Encore 3D Home Architect Home & Landscape Deluxe Suite Version 9 for PC (705381139102) Microsoft Access 2000 (077-01277) for PC

Popular Solutions for Business and Productivity


Office Professional 2007 Full Version for PC
Microsoft Office Professional 2007 Full Version for PC
Need a prod key for home and student 2007
I just bought a new laptop vista already has home and student 2007 on it and it keeps...
1 Solution

MobileLists (950142) for PC, Mac
Handmark Software MobileLists (950142) for PC, Mac
any solutions for sigmatel s90 mobile...
any solutions for sigmatel s90 mobile invalid sim message
2 Solutions

Office Home and Student 2007 Spanish Version: Windows
Microsoft Office Home and Student 2007 Spanish Version:...
wrong code entered. I have an unused one...
I bought my wife a new laptop and it had a trial version of the office student...
1 Solution

iWork 09 Family Pack Full Version for Mac
Apple iWork 09 Family Pack Full Version for Mac
ok. I downloaded the trial version of iwork...
ok. I downloaded the trial version of iwork 09 and have been using it for writing...
1 Solution

Photoshop CS4 Extended Full Version Volume License for PC
Adobe Photoshop CS4 Extended Full Version Volume License for...
i cant install the adobe photoshop cs4...
i cant install the adobe photoshop cs4 becouse i dont i have a license serial...
3 Solutions

Questions and Unsolved Problems for Business and Productivity


Microsoft EXCEL 2004 for Mac
Microsoft EXCEL 2004 for Mac

Good morning,

Answer
Good morning, I am attempting to open a file created in Microsoft Excel that is/was on a thumbdrive.... (More)

Punch Software Landscape Deck and Patio Designer 12 - Windows for PC (97500)
Punch Software Landscape Deck and Patio Designer 12 -

How can I get the Live View to show...

Answer
How can I get the Live View to show the picture? It's black unless I hold the mouse button down over... (More)


Didn't find what you were looking for?

Describe your Business and Productivity... problem:

Select a Category:





Ads by Google



Ask our Experts

Ask

 

Solve Your Problem Now!
Chat Live with an Expert
Chat Now
Top Business and... Experts
smb_146
Rank:
Guru
Computer Software
Expert

Rating:
98%, 370 votes


ikkenom
Rank:
Wiz
Computer Software
Expert

Rating:
79%, 863 votes


cameleon_one
Rank:
Wiz
Computer Software
Expert

Rating:
82%, 76 votes


Find more Business and... Experts
Top Computer & Laptop Repairmen
in , CA
LaptopOnCall Inc.
(513) 874-3306
We fix and repair laptop motherboard no video, no...
LaptopOnCall Inc.

A+ Rated Oceanside...
(877) 934-6198
Send your laptop to us and we will diagnose the...
A+ Rated Oceanside Computer Sales & Service, LLC

See More
Get Listed!

       
Solve Your Problem Now!
Chat Live with an Expert
Chat Now

Insert Link
Insert Image
Insert You-Tube clip
Insert List
Insert List
Spell Check

What is this?



Select