| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Editing multiple cells at the same time
Example:
Column A contains a list of numbers 5, 10, 15 and 20 in cells 1-4 In A6 i write =(A1) then copy it down to A9 to repeat the sequence. Now, if I try to transpose the list all the values change. I would like to know how, if possible, can I change them all together making them absolute values so they would read =$A$1 =$A$2 =$A$3 =$A$4 without doing them 1 at a time. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Editing multiple cells at the same time
Use FIND/REPLACE
Find: A Replace with: $A$ Replace All -- Gary''s Student - gsnu200909 "Darren" wrote: Example: Column A contains a list of numbers 5, 10, 15 and 20 in cells 1-4 In A6 i write =(A1) then copy it down to A9 to repeat the sequence. Now, if I try to transpose the list all the values change. I would like to know how, if possible, can I change them all together making them absolute values so they would read =$A$1 =$A$2 =$A$3 =$A$4 without doing them 1 at a time. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Editing multiple cells at the same time
Thankyou very much.
"Gary''s Student" wrote: Use FIND/REPLACE Find: A Replace with: $A$ Replace All -- Gary''s Student - gsnu200909 "Darren" wrote: Example: Column A contains a list of numbers 5, 10, 15 and 20 in cells 1-4 In A6 i write =(A1) then copy it down to A9 to repeat the sequence. Now, if I try to transpose the list all the values change. I would like to know how, if possible, can I change them all together making them absolute values so they would read =$A$1 =$A$2 =$A$3 =$A$4 without doing them 1 at a time. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying multiple cells out of multiple worksheets at same time. | Excel Discussion (Misc queries) | |||
| editing multiple cells with a macro | Excel Discussion (Misc queries) | |||
| editing and analysis of cells in multiple worksheets AND workbooks | Excel Discussion (Misc queries) | |||
| Date and time stamping multiple cells for multiple entries. | Excel Worksheet Functions | |||
| Editing multiple cells with one action???? | Excel Discussion (Misc queries) | |||
Linear Mode
