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?
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?
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks