Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Set whole column with function
Hopefully very basic question...just can't seem to figure it out.
How do I set whole column to be +20 of another column. For example - value of A1= 1/2/2007 then C1 = 1/22/2007 A3=5/5/2006 then C1=5/25/2007 Thank you! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Set whole column with function
=A1+20
"TypeType" wrote: Hopefully very basic question...just can't seem to figure it out. How do I set whole column to be +20 of another column. For example - value of A1= 1/2/2007 then C1 = 1/22/2007 A3=5/5/2006 then C1=5/25/2007 Thank you! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Set whole column with function
Thanks but thats not what I was looking for.
I want to set the whole column to do this. I don't want to have to type A1+20, A2+20, A3+20..etc all the way down the whole C column. There must be a way to set the whole column up at once. "Teethless mama" wrote: =A1+20 "TypeType" wrote: Hopefully very basic question...just can't seem to figure it out. How do I set whole column to be +20 of another column. For example - value of A1= 1/2/2007 then C1 = 1/22/2007 A3=5/5/2006 then C1=5/25/2007 Thank you! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Set whole column with function
In B1: =A1+20
Drag the Fill Handle to copy down as far as required "TypeType" wrote: Thanks but thats not what I was looking for. I want to set the whole column to do this. I don't want to have to type A1+20, A2+20, A3+20..etc all the way down the whole C column. There must be a way to set the whole column up at once. "Teethless mama" wrote: =A1+20 "TypeType" wrote: Hopefully very basic question...just can't seem to figure it out. How do I set whole column to be +20 of another column. For example - value of A1= 1/2/2007 then C1 = 1/22/2007 A3=5/5/2006 then C1=5/25/2007 Thank you! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Set whole column with function
Copy column A to column C.
Type 20 in an unused cell. Copy that cell. Select column C range of dates and EditPaste SpecialAddOKEsc. Re-format to date. Gord Dibben MS Excel MVP On Fri, 2 Mar 2007 20:49:11 -0800, TypeType wrote: Hopefully very basic question...just can't seem to figure it out. How do I set whole column to be +20 of another column. For example - value of A1= 1/2/2007 then C1 = 1/22/2007 A3=5/5/2006 then C1=5/25/2007 Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to set default column function | Excel Worksheet Functions | |||
abs function for column | Excel Discussion (Misc queries) | |||
How to replace column letter in refferences with a function using the old column letter? | Links and Linking in Excel | |||
How to replace column letter in refferences with a function using the old column letter? | Excel Worksheet Functions | |||
MAX Function and Corresponding Column | Excel Discussion (Misc queries) |