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 |
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