| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Adding the same number to each cell in a column
I'm a new Excel user. How do I add the value 1.5 to each cell in a column?
|
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Adding the same number to each cell in a column
One way:
Enter 1.5 in a blank cell. Copy the cell. Select the cells to be added to. Choose Edit/Paste Special, selecting the Add and Values radio buttons. In article , BrendaC wrote: I'm a new Excel user. How do I add the value 1.5 to each cell in a column? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Adding the same number to each cell in a column
Try this:
Enter 1.5 in a blank cell and select that cell From the Excel main menu: <edit<copy Next....select the cells you want to add the 1.5 to Then...<edit<paste special....Check: Add Click [OK] Does that help? *********** Regards, Ron XL2002, WinXP "BrendaC" wrote: I'm a new Excel user. How do I add the value 1.5 to each cell in a column? |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Adding the same number to each cell in a column
BrendaC
In an empty cell some where place 1.5. Copy that cell .... select the column you want to add to and right click, select paste specialadd and ok out. Mike Rogers "BrendaC" wrote: I'm a new Excel user. How do I add the value 1.5 to each cell in a column? |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Adding the same number to each cell in a column
Thanks so much for the great help - it worked!
"Ron Coderre" wrote: Try this: Enter 1.5 in a blank cell and select that cell From the Excel main menu: <edit<copy Next....select the cells you want to add the 1.5 to Then...<edit<paste special....Check: Add Click [OK] Does that help? *********** Regards, Ron XL2002, WinXP "BrendaC" wrote: I'm a new Excel user. How do I add the value 1.5 to each cell in a column? |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Adding the same number to each cell in a column
Thank you very much - it was easy to do and worked!
"JE McGimpsey" wrote: One way: Enter 1.5 in a blank cell. Copy the cell. Select the cells to be added to. Choose Edit/Paste Special, selecting the Add and Values radio buttons. In article , BrendaC wrote: I'm a new Excel user. How do I add the value 1.5 to each cell in a column? |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Adding the same number to each cell in a column
Thanks for taking the time to help - it worked!
"Mike Rogers" wrote: BrendaC In an empty cell some where place 1.5. Copy that cell .... select the column you want to add to and right click, select paste specialadd and ok out. Mike Rogers "BrendaC" wrote: I'm a new Excel user. How do I add the value 1.5 to each cell in a column? |
|
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Adding the same number to each cell in a column
BrendaC
I am glad it worked for you. Thanks for posting back. Mike Rogers "BrendaC" wrote: Thanks for taking the time to help - it worked! "Mike Rogers" wrote: BrendaC In an empty cell some where place 1.5. Copy that cell .... select the column you want to add to and right click, select paste specialadd and ok out. Mike Rogers "BrendaC" wrote: I'm a new Excel user. How do I add the value 1.5 to each cell in a column? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding Row Number to Column | Excel Worksheet Functions | |||
| Adding Column Heading w/o Using a Row Number | Excel Discussion (Misc queries) | |||
| Manually number row without adding column | Setting up and Configuration of Excel | |||
| Adding up number of yes, no, maybes in a column | Excel Worksheet Functions | |||
| Adding number to each cell in a column | Excel Discussion (Misc queries) | |||
Linear Mode
