Google Sheets and Excel provide functions and mathematical formulas to manipulate data. If you have cells in excel or Google Sheets containing large numbers, you can divide the cells by 1000 to make the data look smaller. In this tutorial, we will learn how to divide all cells in a column by 1000 in both google sheets and excel. In both sheets, we have two alternative ways to divide data in a cell.
In Google Sheets;
Table of Contents
We can use the formula function provided by google sheets to divide cells by any number. Alternatively, we can key in a formula manually.
1. Open Google Sheets on google chrome or your preferred browser.
2. Select the first cell of the column where you want your final output to be displayed after division.
3. Click the More options icon (with three dots) at the end of the menu bar and then the formula dropdown with a sigma icon.
4. An options pane appears. Scroll down and look for the Operator option and click on it.
Another option pane pops up. Now select DIVIDE.
5. A formula appears at the selected cell. Now click the cell which contains the data you want to divide(divided), enter a comma, then type ‘1000‘(divisor) to divide the cell by 1000 and click Enter.
Now the cell is divided by 1000. You do not have to repeat the same steps in every cell to divide them by 1000.
Just click on that we have entered the formula. Place your cursor at the bottom right of the cell until the cursor turns to a plus (+) sign, then drag it down to the last cell to autofill the quotient.
Now you are done! All your cells have been divided by 1000.
1. Open your Microsoft excel from the Microsoft office applications.
2. Type the number 1,000 in an empty cell. Copy the number to your clipboard by clicking CTRL+V on your keyboard, or click the Home tab on the menu bar and then click copy.
3. Select all the cells that you want to divide by 1000. To select multiple cells, hold CTRL,
Click each cell you want to highlight, and release the CTRL-key.
4. From the Home tab, click the dropdown icon labeled Paste, then Paste Special.
5. A Paste Special pane opens up. In the operations group, click to check the Divide Radio button and then click OK.
And now, all the cells have been divided by 1,000.