Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
assistance need with excel doc
Hi guys
I am trying to copy rows which has minor function. These 5 rows have titles and a functions displaying items from another sheet. I tried to multiply (copy) these rows buy dragging the mouse down the sheet, but it makes copies with the function adding 5 instead of + 1. e.g "=Evaluation!C5&Evaluation!AY5&Evaluation!D5", the next set would be "=Evaluation!C10&Evaluation!AY10&Evaluation!D1 0" instead of "=Evaluation!C6&Evaluation!AY6&Evaluation!D6". I would like to know if I could copy these 5 rows a set adding + 1 for the formula instead of + 5? asssistance is highly appreciated, thanx Geno |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
assistance need with excel doc
Geno,
The easiest thing would be to select the cell with the formula, press F2 to enter edit mode, use Shift-home, then Ctrl-C to copy the formula string, select the cell ABOVE where you want the copy to be located, press F2 then Ctrl-V to paste the formula string, and then press Enter. Copy that cell and paste it one row down, and then delete it. Otherwise, you could use a macro, or use a formula like =OFFSET(Evaluation!$C$5,ROW(A5)/5-1,0) for each of your links. HTH, Bernie MS Excel MVP "GENO" wrote in message ... Hi guys I am trying to copy rows which has minor function. These 5 rows have titles and a functions displaying items from another sheet. I tried to multiply (copy) these rows buy dragging the mouse down the sheet, but it makes copies with the function adding 5 instead of + 1. e.g "=Evaluation!C5&Evaluation!AY5&Evaluation!D5", the next set would be "=Evaluation!C10&Evaluation!AY10&Evaluation!D1 0" instead of "=Evaluation!C6&Evaluation!AY6&Evaluation!D6". I would like to know if I could copy these 5 rows a set adding + 1 for the formula instead of + 5? asssistance is highly appreciated, thanx Geno |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell color assistance for excel | New Users to Excel | |||
Assistance with password in Excel | Excel Worksheet Functions | |||
How can I get assistance on Excel Formula? | Excel Worksheet Functions | |||
1-2-3 @ function to Excel Assistance | Excel Worksheet Functions | |||
Turn off Assistance pane in Excel | Excel Discussion (Misc queries) |