Excel column-I need help

Copper Contributor

I'm trying to add a column to an existing excel document but the column will not move with the rows. It stays fixed in place when I try to rearrange the table. Please help!!

5 Replies

@Amie709 

 

Please help us help you by giving a more complete description. Maybe an image or two, or, far better, post a copy of the worksheet in question on OneDrive or Google Drive, and paste a link here that grants edit access.

But in particular, your description is hard to picture, hard to visualize...so a more clear description of

  • what you're starting with
  • what you're trying to accomplish

I can't share the content but picture it like a table of book entries. Each column represents a part of the book (title, author, number of pages, etc.). Those columns were already in the document and I am trying to add a column with publication date for the book. When I add the publication date for each book and then sort the table by column (for example, authors name A-Z) all the rows rearranged themselves like they are supposed to-except the one I created-that one doesn't move. 

@Amie709 

 

  • Was the pre-existing identified as an Excel table? (usually evident in rows that alternate in colors)
  • Where did you add the new column? (I'm presuming to the right or the left of the pre-existing.)
  • Is there any space (empty column) between the new and the pre-existing columns? (Note: columns may be hidden)
  • How are you selecting the columns to be sorted? 

 

I'm sure there are other questions I should be asking....You've done a good job of describing generally what it looks like, but these are procedural questions that I'm trying to get at. How you acquired the data in the first place; how it was set up (as Table or not); how the sort was first defined.....

 

In essence, and this may just be stating the obvious, Excel has to know that you mean for the new column to be included in the sort; this apparently isn't happening, so the question is why? And that's a procedural matter, I suspect, so we need to get a clearer picture of the procedural steps you've gone through.

the preexisting acted like a table. There was no difference in color but the rows stayed together if the table was rearranged. For example, sorted by chapter and then sorted by author-the other rows all moved together.

I added it to the right of the existing columns. No empty columns between the one I added and the ones already there and I'm assuming none hidden because there are no missing letters along the top (the A B C D etc that runs along the top).

@Amie709 

 

Can you add a column in the middle of the preexisting table? Then copy over the new data you've added? That would be the next thing to try.

 

I can't think of anything else from what you've told me. It's puzzling to me too.