Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pasting formulas problem
Trying to copy formulas but don't want to have to readjust them when i've
finished. Is there any way to prevent this? eg: Row 1: =sheet!A1 pasted to: Row 3: =sheet!A3 but I want: Row 3: =sheet!A1 Trying to create a timesheet file, quite complex and want to minimise the workload! |
#2
|
|||
|
|||
I have found that if I put a # in front of the formula to copy
(#=sheet!A1) then remove the # after pasting it keeps the formula references the same. Hope this helps, Dennis |
#3
|
|||
|
|||
Hi
Change the formula a bit =Sheet!$A$1 Or, when you are coping the formula to singel cell, and don't want to use absolute references for some reason: Select the cell with original formula, select the formula in formula bar (at top of Excel window, below menus), and copy it. Select the cell you want to copy the formula in, point with mouse into formula bar, and paste the formula in. -- When sending mail, use address arvil<attarkon.ee Arvi Laanemets "HHTV Rich" <HHTV wrote in message ... Trying to copy formulas but don't want to have to readjust them when i've finished. Is there any way to prevent this? eg: Row 1: =sheet!A1 pasted to: Row 3: =sheet!A3 but I want: Row 3: =sheet!A1 Trying to create a timesheet file, quite complex and want to minimise the workload! |
#4
|
|||
|
|||
Thanks.
I searched a bit harder around here and found a similar solution. Worked like a dream! :) "den4673" wrote: I have found that if I put a # in front of the formula to copy (#=sheet!A1) then remove the # after pasting it keeps the formula references the same. Hope this helps, Dennis |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy and pasting graphs to PowerPoint | Excel Discussion (Misc queries) | |||
Sum Product Problem | Excel Discussion (Misc queries) | |||
Baffling formula problem | Excel Discussion (Misc queries) | |||
Paper Tray selection Problem, | Excel Discussion (Misc queries) | |||
Formulas stop calculating at random times when editing a few spreadsheets. | Excel Discussion (Misc queries) |