How do I use the MOD formula to do the same action to a column?

A

ali55

I am trying to divide a whole column of numbers by the same divisor and I am
stuck. The solution is gone from my brain.
 
D

Duke Carey

If you want to divide them in place, put your divisor in an empty cell, copy
it, select the cells to be divided, and use Edit>Paste Special>Divide.
 

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
Two columns followed by single page-width column on same page 0
Format column widths from one table to a separate table on same page 1
Formula for calculating target hours against actual hours 12
MOD function 0
AppleScript - How do I select a text ? 1
Word does random actions (Mac) 0
How can the font and size of (all) citation numbers be altered? 1

Top