How to add the same value to an entire column of numbers??

B

Brita

I have a spreadsheet with numbers in the columns...I want to add 25 to every
cell. How is that down? I use to know how!
 
M

Max

One way ..

Enter 25 into an empty cell > copy it
Select the range to be added
Right-click on the selected range
Choose Paste special > Check "Add" > OK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Excel does not accept text format! 0
How can the font and size of (all) citation numbers be altered? 1
Indenting every other paragraph in Word at the same time? 0
Finding the proper style field and the numbered paragraph value within the style 0
How to remove a bracket that is itallicised for an entire document 1
Two columns followed by single page-width column on same page 0
Paragraph numbering in Word 1

Top