Copying cells with Formulas

jrf001 · Mar 27th, 2002, 02:45 AM

Hi,

I have some cells with Data and Formulas that relate to other worksheets. I have positioned a Graph over the top to hide the cells, however when I print, the cells print also (right in the middle of the graph). I want to move the cells but when I do, it changes the cell reference. Can I copy the cells into another part of the worksheet, but not change the formula references.
PS I am pretty green so go easy on me.
cheers

Dave Hawley · Mar 27th, 2002, 02:49 AM

Hi

If you Cut the cells (not Copy) all references will automatically follow.

Tom Schreiner · Mar 27th, 2002, 02:52 AM

Hi
If you drag the cells in question, they will retain the correct references to the cells they are pointing to.
Select the cell(s) in question and place the mouse pointer on the bold outline of the selection, left-click-hold and drag.
Another option is to make your references static.
For example:
formula =A2
Make static
formula =$A$2
Or you can do what Dave said.
I did't know that Dave!
Have a nice day!
Tom

jrf001 · Mar 27th, 2002, 02:53 AM

Thanks again Dave...

I feel like a real idiot...DOH

Ian Mac · Mar 27th, 2002, 02:54 AM

Quote:

On 2002-03-27 01:52, TsTom wrote:
Hi
If you drag the cells in question, they will retain the correct references to the cells they are pointing to.
Select the cell(s) in question and place the mouse pointer on the bold outline of the selection, left-click-hold and drag.
Another option is to make your references static.
For example:
formula =A2
Make static
formula =$A$2
Or you can do what Dave said.
I did't know that Dave!
Have a nice day!
Tom

No they won't! the references will move accordingly

Tom Schreiner · Mar 27th, 2002, 02:59 AM

They keep the same reference Ian!

Ian Mac · Mar 27th, 2002, 03:03 AM

Quote:

On 2002-03-27 01:59, TsTom wrote:
They keep the same reference Ian!

Yes they will! Far to hasty this morning, Tout mon appologies!! I was also moving the Referenced cells.

Tom Schreiner · Mar 27th, 2002, 03:10 AM

No problem Ian
Just having fun here!
Bil ole Regards,
Tom

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 27th, 2002, 02:45 AM	#1
jrf001 New Member Join Date: Mar 2002 Posts: 19	Hi, I have some cells with Data and Formulas that relate to other worksheets. I have positioned a Graph over the top to hide the cells, however when I print, the cells print also (right in the middle of the graph). I want to move the cells but when I do, it changes the cell reference. Can I copy the cells into another part of the worksheet, but not change the formula references. PS I am pretty green so go easy on me. cheers

Mar 27th, 2002, 02:49 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi If you Cut the cells (not Copy) all references will automatically follow.

Mar 27th, 2002, 02:52 AM	#3
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi If you drag the cells in question, they will retain the correct references to the cells they are pointing to. Select the cell(s) in question and place the mouse pointer on the bold outline of the selection, left-click-hold and drag. Another option is to make your references static. For example: formula =A2 Make static formula =$A$2 Or you can do what Dave said. I did't know that Dave! Have a nice day! Tom

Mar 27th, 2002, 02:53 AM	#4
jrf001 New Member Join Date: Mar 2002 Posts: 19	Thanks again Dave... I feel like a real idiot...DOH

Mar 27th, 2002, 02:59 AM	#6
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	They keep the same reference Ian!

Mar 27th, 2002, 03:10 AM	#8
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	No problem Ian Just having fun here! Bil ole Regards, Tom