-->

How to number in excel?

 How to number in excel?

  1. Open the Excel spreadsheet you want to number.

  2. Select the cells where you want to add numbers.

  3. Right-click on the selected cells, and click on "Format Cells" from the context menu.

  4. In the "Format Cells" dialog box, click on the "Number" tab.

  5. Select the "Number" category from the list of options.

  6. Click on "OK" to apply the number format to the selected cells.

  7. To add a sequence of numbers, click on the first cell in the series, and then press "Ctrl + Shift + Right arrow" to select all the cells you want to fill with numbers.

  8. Type the first number in the series and press the "Ctrl + Enter" keys. Excel will automatically fill the selected cells with the numbers in the series.

  9. If you want to number the rows, select the row number column and right click to format the cell as number and you will have your rows numbered.

Note: You can also use the "AutoFill" feature by dragging the fill handle to the right or down to copy the first number to the other cells.

Related Posts:

Disqus Comments
Powered by Blogger.

Search This Blog

  • ()

About Us

About Us
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's.

Main Tags

© 2017 Quick Hacks - Template Created by goomsite - Proudly powered by Blogger