excel spreadsheet apply to mass cell at once HELP ME PLEASE?

Question

ok heres the problem i have a spreadsheet file. and its my inventory sheet. the prices i have on the sheet. i want to increase all the prices at once. increase $5.00 more. how can i do this. with out having to include a formula in the sheet.

so imagine column A: has prices........all i want to do is ADD 5 more buck to the prices in column A.

Answer 1

Here's a simplification of the previous answer.

1. Put a 5 in an empty cell.
2 Select the cell with the 5.
3. Edit > Copy
4. Select the range of cells whose value you want to change
5. Edit > Paste Special > operation Add

Answer 2

how many rows is column A?
lets assume 50 to make it easy.

1. find an empty column off on the right somewhere, or on a different sheet (it doesnt matter)

2. type the # 5 in the new column, and copy it
3. highlight 50 cells in the column and paste (you should end up with 50 rows of 5's)
4. hightlight all your 5's, and copy
5. right-click on the first price in column A

now heres the trick
6. on the drop down box...click "Paste Special..."
7. under "Operation" click the Add circle
8. click ok.

9. delete your column with all the 5's in it.

Answer 3

there's no way to do it without a formula.

if cell a1 is your price, in cell b1 type =a1+5, then copy the formula all the way down the list.

if you want to get rid of the formula in the end, copy all of column b, and in column a past the values (edit>paste special>values).

Answer 4

a million. variety B2*C2 into cellular D2 2. Press the enter key. 3. pass lower back to cellular D2 4. carry the **** key down 5. Press the down arrow as many circumstances as you want to attain the quantity of cells you want (or use the website DOWN key) 6. elect Fill Down from this gadget menu (or carry down the CTRL key, and press D) (that is a Fill Down shortcut) If the cells in columns B & C are empty, then the cellular in column D could desire to show 0 (except the the sheet is set to hid ZEROS.

Answer 5

You can create a macro...

Sub IncreaseVal()

For Each c In ActiveCell.CurrentRegion.Cells
c.Value = c.Value + 5
Next

End Sub

Before you run it, select the cells with the values you want to change.