Quote:
Originally Posted by Pecoflyer
1) Enter 1 in an empty cell somewhere and copy it.
Select the range or the cells you want increased.
Right Click - Paste Special -Check "add" - OK
2) In C1 enter =A1&B1 then drag down as needed or double click the cross-hair at the right lower corner of the selected cell
|
Thx!
1) is very useful when the number of cells to modify is not too large for click & drag (sometimes I need to handle up to a thousand cells in a single column).
2) Not sure what C1 is. The only better way I currently use is to combine the cells in the 1st row, and then click & drag the cross-hair down for all succeeding rows. But like again, that wouldn't be a good way for handling a very large number of rows.