I want to add 25 to all of the cells in column A. I do not want a new column, I want to add it right to the cells in column A?

Submitted by: Administrator
Temporarily enter 25 in a cell in an out of the way place. Highlight that cell and hit Ctrl-C to copy the cell. Now, highlight your range of cells in column E. Select Edit>Paste Special. Click the add radio button and click OK. The contents of the clipboard (25) will be added to each cell in column A.
Submitted by: Administrator

Read Online Microsoft Excel Job Interview Questions And Answers