Method 2 – Dividing a Column by a Number with the Paste Special Method Steps: Copy the cell containing the number by which the column will be divided. To open thePaste Specialoption, select all cells in the column and pressCTRL + ALT + V. You can also open thePaste Specialoption by ...