How can I subtract 25 from ever cell in a worksheet with out haveing t do it cell by cell. :confused
A apbart01 Sep 11, 2004 #1 How can I subtract 25 from ever cell in a worksheet with out haveing t do it cell by cell. :confused
A Aladin Akyurek Sep 11, 2004 #2 Enter 25 in an unused cell. Copy this cell. Select the target cells you want to modify. Run Edit|Paste Special|Subtract.
Enter 25 in an unused cell. Copy this cell. Select the target cells you want to modify. Run Edit|Paste Special|Subtract.
G Guest Sep 11, 2004 #3 Put 25 in an empty cell....copy this cell....select the cells you want to work with...hit Paster Special/subtract
Put 25 in an empty cell....copy this cell....select the cells you want to work with...hit Paster Special/subtract
J John Sep 12, 2004 #4 Type 25 in another cell, and then select the cell, select copy, edit menu, paste special, select value, and operations subtract
Type 25 in another cell, and then select the cell, select copy, edit menu, paste special, select value, and operations subtract
