ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Numbering (https://www.excelbanter.com/new-users-excel/48898-numbering.html)

hayhider

Numbering
 

I am wanting to number the cells in a spreadsheet 1- 750. Is there way
to do that without having to type the numbers in each cell?


--
hayhider
------------------------------------------------------------------------
hayhider's Profile: http://www.excelforum.com/member.php...o&userid=18168
View this thread: http://www.excelforum.com/showthread...hreadid=473662


nuver


Enter 1 in the first cell and hit enter. Then while holding the
CntrllKey rest your mouse pointer over the right hnd bottom corner of
the cell containing the number you just entered. When te mouse pointer
turns to a plus sign click the mouse and hold it while still holding
down the Ctrl. You can drag this down as far as you want and it will
automatically fill the information for you.


--
nuver
------------------------------------------------------------------------
nuver's Profile: http://www.excelforum.com/member.php...o&userid=10036
View this thread: http://www.excelforum.com/showthread...hreadid=473662



All times are GMT +1. The time now is 12:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com