1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel 2007 Change Left Side Numbering - HELP!!

Discussion in 'Business Applications' started by phil18646, Jan 1, 2010.

Thread Status:
Not open for further replies.
Advertisement
  1. phil18646

    phil18646 Thread Starter

    Joined:
    Mar 29, 2006
    Messages:
    124
    I have been using Excel (now 2007) to keep records of items that we give free after a certain amount of purchases are made. Each year I simply carry over to the new year and delete all those who received the free item so that I start with a clean slate.

    I did this yesterday and now noticed that the numbering on the far left column skips the number I deleted and although there are perhaps 30 names there - the numbers are showing up to 237.

    How do I change the numbers so that they run consecutively from 1 to 30.....please...in layman terms please!

    Thanks..
     
  2. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    64,689
    First Name:
    Wayne
    are you sure you do not have any filters or subtitles on
     
  3. phil18646

    phil18646 Thread Starter

    Joined:
    Mar 29, 2006
    Messages:
    124
    How would I know that?
     
  4. phil18646

    phil18646 Thread Starter

    Joined:
    Mar 29, 2006
    Messages:
    124
    You are RIGHT!!! I did have a filter on - Thank YOU!!!
     
  5. phil18646

    phil18646 Thread Starter

    Joined:
    Mar 29, 2006
    Messages:
    124
    Whoops - Wrong. I used the Filter to filter out the items that were given away in 2009 so I could start over in 2010 BUT then when I took the filter out the numbers were correct but then all the 2009 data appeared again!
     
  6. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    64,689
    First Name:
    Wayne
    so you need to delete the 2009 data (if you need it - copy onto a new sheet) and then sort the rows to get them sequential

    Or sort the data so the 2009 is at the end of the spreadsheet
     
  7. phil18646

    phil18646 Thread Starter

    Joined:
    Mar 29, 2006
    Messages:
    124
    I did sort the 2009 data - saved - so how do I sort the rows???
     
  8. phil18646

    phil18646 Thread Starter

    Joined:
    Mar 29, 2006
    Messages:
    124
    They are all in alphabetical order - I just want them numbered 1 - 30
     
  9. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    64,689
    First Name:
    Wayne
    did you delete the 2009 rows, that may do it anyway with out the sort
    otherwise just sort with column A - that should do it if there is no 2009 data in the sheet

    make sure you have a copy ....... so you can go back if you make any mistakes

    can you post a sample or remove sensitive info and post a copy
     
  10. phil18646

    phil18646 Thread Starter

    Joined:
    Mar 29, 2006
    Messages:
    124
    I did a sort on the 2009 - how do I do a delete??? With the sort I went to Sort And Filter and told it to delete the empty shipping lane...How do I post a sample?
     
  11. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    64,689
    First Name:
    Wayne
    to post a sample
    you will see a button called "go advanced" at the bottom of the text box
    click on that
    then you should see
    manage attachments
    there you can upload a xlsx file
     
  12. phil18646

    phil18646 Thread Starter

    Joined:
    Mar 29, 2006
    Messages:
    124
    I am SO sorry - I do not see a button called go advance...
     
  13. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    64,689
    First Name:
    Wayne
    bottom of the text box you reply in
    two buttons
    "post Quick reply" and "Go Advanced"
     
  14. phil18646

    phil18646 Thread Starter

    Joined:
    Mar 29, 2006
    Messages:
    124
    Did I do this right?
     

    Attached Files:

  15. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    64,689
    First Name:
    Wayne
    so you want to remove all the rows that have a date in column D date shipped
    so sort the spreadsheet by column D

    that should put all the dates together - then you can click on the 1st row (the actual number ) that has a date shipped
    Hold the shift key and click on the last row
    that should highlight all the rows with a date shipped
    then keep the mouse on the number and right click
    delete rows
    they should all now be gone

    I have attached the file with all "date shipped" blank

    I have saved as a xls file, as i only have open office available on this PC NO Excel
     

    Attached Files:

  16. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/890117

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice