#1   Report Post  
hayhider
 
Posts: n/a
Default 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   Report Post  
nuver
 
Posts: n/a
Default


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I protect cell numbering format ($) but allow editing? Deb22 Excel Discussion (Misc queries) 6 September 22nd 09 07:37 AM
Need Help with Excel page numbering uclabennett New Users to Excel 0 October 5th 05 04:55 PM
Page Numbering Pam Coleman Excel Discussion (Misc queries) 1 July 29th 05 08:44 PM
Numbering add in Paul Excel Discussion (Misc queries) 2 March 23rd 05 02:46 PM
Auto page numbering for several worksheets Andy Excel Worksheet Functions 1 March 13th 05 04:41 AM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"