Microsoft Excel Question:

Download Job Interview Questions and Answers PDF

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?

MS Excel Interview Question
MS Excel Interview Question

Answer:

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.

Download MS Excel Interview Questions And Answers PDF

Previous QuestionNext Question
How can I enter the symbol for the new Euro currency in my spreadsheet?I have a spreadsheet where I want to sum cells from column E if the corresponding date in column A is within the last 60 days?