Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I protect cell numbering format ($) but allow editing? | Excel Discussion (Misc queries) | |||
Need Help with Excel page numbering | New Users to Excel | |||
Page Numbering | Excel Discussion (Misc queries) | |||
Numbering add in | Excel Discussion (Misc queries) | |||
Auto page numbering for several worksheets | Excel Worksheet Functions |