+ Reply to Thread
Results 1 to 2 of 2

Easy question for a noob

  1. #1
    Registered User
    Join Date
    02-17-2006
    Posts
    1

    Easy question for a noob

    Well this is my first time using excel so i just need something basic as a grid and being able to input my information to it

    Question:

    how do i make a x and y colum to be custom with simple numbers and negative numbers that follow after that. say 1000 down to 0 then down to -1000 for the x column, then the same for y.

  2. #2
    Pete_UK
    Guest

    Re: Easy question for a noob

    Assume you want to use column A for your x values. In cell A1 enter the
    value 1000, then highlight cells A1 to A2001 and Edit | Fill | Series,
    check Linear and set a step value of -1. Click OK then you have your x
    values. If you want the same in column B for the y values, you can
    follow the same steps. A quicker way, though, is to highlight column A
    (click the A in the column identifier), then click <copy> then click in
    cell B1 and press <enter>.

    Hope this helps.

    Pete


+ 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