Re: How do I add 100 to multiple cells?

Tech-Archive recommends: Speed Up your PC by fixing your registry

Thanks Daddylonglegs & Bob. I knew there was a way to do this. Thanks again.
--
Ed


"Bob Phillips" wrote:

Put 100 in a separate cell, then copy that cell

Select the cells to add to
Menu Edit>PasteSpecial
Click Add
OK

Clear the cell with 100 in it.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Ed" <Ed@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D5D03BA6-5413-4679-93A8-C4F34D9B6D52@xxxxxxxxxxxxxxxx

--
Ed



.

Relevant Pages

  • Re: Code to replace sumproduct
    ... replace SP with formulae than look at less cells. ... Bob Phillips Wrote: ... (replace somewhere in email address with gmail if mailing direct) ...
    (microsoft.public.excel.programming)
  • Re: Will SUMPRODUCT work for this?
    ... Bob Phillips ... (remove nothere from email address if mailing direct) ... > I'm currently using the following formula to calculate certain cells in ...
    (microsoft.public.excel.misc)
  • Re: get excel to automatically add fill color
    ... > some cells to be filled with color but they werent the right cells and ... > of conditional formatting but i just cant seem to hit on it.Bob Phillips ... >> Bob Phillips ... Now I want excel to ...
    (microsoft.public.excel.programming)
  • Re: Speeding up my Excel calculations.
    ... grouping dependent cells. ... Also, VLOOKUP can be a killer on large tables, so alternatives can often ... Bob Phillips ... Yesterday I learned that for complex worksheets, primary calculations ...
    (microsoft.public.excel.newusers)
  • Re: Speeding up my Excel calculations.
    ... I think I understand the concept, but as always I am having a hard time interpreting formulae. ... the VLOOKUP, which checks many cells is only invoked once, and then a much ... Bob Phillips wrote: ... set range, eg D7:D10000, for Sumproduct to search. ...
    (microsoft.public.excel.newusers)