- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel
- 2007 January
- Copy Paste basics?

Subject: | Copy Paste basics? |

Posted by: | David W (dma…@speednetllc.com) |

Date: | 29 Jan 2007 |

I have been using excel for several years now and over the past few

years I've been running across the need to copy a value from one cell

to a selection of cells without the formula changing or a portion of

the formula. For example, cell A1 contains the formula =A2+A3. If I

copy that to cell B1 my formula changes to =B2+B3 which is the norm.

However I need to copy a formula and keep the cell names constant so

that when I copy to B1 it will equal A2+A3. another example would be I

want to multiply the contents of B3 by the contents of C2, D2, E2, and

F2 and have the result display in C3, D3, E3 and F3. Basically I need

the ability to multiply a series of cells by the value in a single

cell, without having to type the formula every time. Is this possible?

is it so basic and I'm just a moron? am I even making sense? Any help

would be appreciated.

- Re: Copy Paste basics? posted by KC Rippstein on Mon, 29 Jan 2007
- Re: Copy Paste basics? posted by Alan on Tue, 30 Jan 2007