none
Excel rows RRS feed

  • Question

  • I have a spreadsheet that collects data from our MAS90 database. I pull in the data into the spreadsheet and then I manually add data into cells at the end of the rows. When more records are added in the database, it moves the other data down in the spreadsheet as it is suppose to because it is sorted alphabetically. However, is doesn't move the manually added data down. How do I make those cells move with the others?

    https://www.dropbox.com/s/e6stvcwkkasmbhr/Inventory%20Check.xlsx

    More specifically, what happens is when I update the records, if anything was added in the database, columns A-D get updated. Those rows move down. However, the rows for columns E and beyond, don't. Then I have to go thru the stupid thing row by row to see where I have to add cells.

    Thanks.

    Wednesday, April 2, 2014 1:27 PM

Answers

  • TurkR,

    The blue/white shaded section, in the first four columns, of your worksheet is an independant section called a "Table".
    If you select any cell in the Table, you will see a highlighted additional tab in the Ribbon.
    After clicking the new tab, on the left side, a "Resize Table" option is displayed.  That should solve your problem.
    '---

    Jim Cone
    Portland, Oregon USA
    https://goo.gl/IUQUN2 (Dropbox)
    (free & commercial excel add-ins & workbooks)

    • Marked as answer by TurkR Wednesday, April 2, 2014 3:59 PM
    • Edited by James Cone Saturday, October 29, 2016 3:37 PM
    Wednesday, April 2, 2014 3:50 PM

All replies

  • TurkR,

    The blue/white shaded section, in the first four columns, of your worksheet is an independant section called a "Table".
    If you select any cell in the Table, you will see a highlighted additional tab in the Ribbon.
    After clicking the new tab, on the left side, a "Resize Table" option is displayed.  That should solve your problem.
    '---

    Jim Cone
    Portland, Oregon USA
    https://goo.gl/IUQUN2 (Dropbox)
    (free & commercial excel add-ins & workbooks)

    • Marked as answer by TurkR Wednesday, April 2, 2014 3:59 PM
    • Edited by James Cone Saturday, October 29, 2016 3:37 PM
    Wednesday, April 2, 2014 3:50 PM
  • That did it. Thank you.
    Wednesday, April 2, 2014 3:59 PM