Numbering

H

hayhider

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

nuver

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Finding the proper style field and the numbered paragraph value within the style 0
Paragraph numbering in Word 1
How can the font and size of (all) citation numbers be altered? 1
Finding the right style field in VBA 0
Cannot Put A Border Around Numbered Text. What To Do? 0
How to count the numbers in a Word document? 0
Page numbering with Merged Document and IF statements 1

Top