Mr Excel on Excel

[ljksr1937]

I have the book and I cannot find p 129 Adding, Subtracting, Multiplying and Dividing without using formulas. I am runing Microsoft EXCEL 2002 Version. I have spreadsheet Assuistant also installed.

 

[MrExcel]

Try this:
1) Enter a column of numbers in A2:A10
2) Enter more numbers in B2:B10
3) Select cells B2:B10
4) Use Edit - Copy
5) Select cells A2:A10
6) Use Edit - PasteSpecial
7) You will now have the dialog box displayed on page 129. In the operation section, click either Add or Subtract or Multiply, etc.

Bill

 

[shades]

Seems to be a minor error on page 376. In paragraph 1 below the Excel insert, the second line has "left arrow" but I think it should be "right arrow" to select all the months.