How to number cells vertically in Excel

We do the numbering of objects, items, and equipment to make them easy to count and easy to compute the sum of their value. Numbering is the process of allocating numeral values to objects, items, and any property to get the value of the items in figures.

Numbering mostly dictates the majority of activities that we get involved in and do generally for a living. To account for work, payment of bills, the food we eat, etc. rely on numbers or numeric figures as most people may say.

Numbering is vital in all aspects of life, once we do numbering in Excel sheets; the data becomes clearer to understand and also helps the viewer avoid unnecessary repetition of data. In any numbered work you just visit the marked numbers that have errors and leave the others thus enabling data analysts to take less time in error detection and correction.

Again it is easy to refer to the data you wish to look into when the data is numbered unlike having to go row per row or column per column searching for the data you want to view or make changes.

To do vertical numbering in excel sheets we have to follow some of the steps. These steps will include the following scenarios.

Step 1

Open a blank excel sheet to enter data on the columns but leave column A empty.

If you already have an existing excel sheet, right-click on cell A1 and select insert from the list of options that appears.

A window will appear once you click on insert, select the option of the entire column from the radio buttons.

Step 2

In the next step, insert 1 in cell A2 and 2 in cell A3. Select the two values that you have just inserted. Drag downwards the small box at the bottom right of cell A3 to cell A12, you should do something like the one below.

You realize after you drag, the numbering of the cells from A2 to cell A12 is done. The subjects have been numbered vertically in that case scenario.