| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add $1 to a long row of #'s
C22 to C172 is a column, not a row
That range has 151 cells, not 150 Put 1 in a spare cell, copy it, then select the range of cells, and Edit/ Paste Special/ Add -- David Biddulph Par wrote: I have 150 numbers in a row C22 to C172. How do I add $1 to all those numbers without creating a new row? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Interrupting long calculations in Excel? Hi all, I am having a verylong calculation in Excel using VBA. Of course I know I can hit ESC orCTRL+BREAK to interrupt the VBA program. But I found due to too long runningprocess, the Excel window stop to | Excel Discussion (Misc queries) | |||
| Clearing cells takes long, long time | Excel Discussion (Misc queries) | |||
| Long Date - Long Date = text is days | Excel Discussion (Misc queries) | |||
| My If+If+If etc.. is too long! Anyone know a better way?! | Excel Worksheet Functions | |||
| How long until 5:00? | Excel Discussion (Misc queries) | |||
![David Biddulph[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
