+ Reply to Thread
Results 1 to 2 of 2

I'm doing a guest list for a party and would like to number the cells,how do i do it

Hybrid View

  1. #1
    Registered User
    Join Date
    04-06-2007
    Posts
    1

    Smile I'm doing a guest list for a party and would like to number the cells,how do i do it

    I am creating a guest list in Excel and would like to number it from 1-200. I know there is formula but I can't remember, please help. How do I do that again? Thank you.

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,887
    Are you saying you want a column of numbers from 1 to 200? If so, type the number 1 in cell A1, then type 2 in cell A2. Select both cells (A1 and A2), then using your mouse click the Fill Handle (lower right corner) of cell A2 and drag down to row 200.

    You'll have the numbers 1 to 200 in cells A1 to A200 without having to use formulas.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1