ExcelBanter - Adding a constant to several cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Adding a constant to several cells (https://www.excelbanter.com/excel-discussion-misc-queries/139003-adding-constant-several-cells.html)

Adding a constant to several cells

How do I add 100 to 20 cells radomly located on an excel spreadsheet?
--
Ed

Teethless mama

Adding a constant to several cells

enter 100 in a blank cell then copy select your target cells Paste
Special Add OK

"Ed" wrote:

How do I add 100 to 20 cells radomly located on an excel spreadsheet?
--
Ed

Adding a constant to several cells

Hi "Teethless mama",

Thanks for the help. Your answer solved my problem.
--
Ed

"Teethless mama" wrote:

enter 100 in a blank cell then copy select your target cells Paste
Special Add OK

"Ed" wrote:

How do I add 100 to 20 cells radomly located on an excel spreadsheet?
--
Ed

All times are GMT +1. The time now is 10:05 PM.