Posted to microsoft.public.excel.worksheet.functions

ant1983

external usenet poster

Posts: 12

Prob an easy one: How do i copy a formula EXACTLY as it is

Scenario:

A1 + A2 = A3

so in A3 i have "=A1+A2"

So if i want to copy that formula in lets say B3 then it would adapt the
reference so it would ready "=B1+B2"

I dont want that - how can i keep that original refernces wherever i copy
the formula?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Easy eay to copy / paste a formula in column	watermt	Excel Worksheet Functions	2	November 17th 09 03:22 PM
Copy/Paste cell down to next value- Easy question, can't figure it	J. Catz.	Excel Discussion (Misc queries)	2	November 4th 09 10:45 AM
Formula prob - or is it validation?	suewho	New Users to Excel	10	September 1st 08 04:50 PM
CSE Formula Prob	pdberger	Excel Worksheet Functions	4	February 16th 08 03:51 AM
date copy paste should be very easy	berk	Excel Discussion (Misc queries)	3	August 23rd 07 10:50 AM

All times are GMT +1. The time now is 06:56 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us