Maintaining Column Relationships During Sorting

Yes, I have checked other threads and they do not answer my question. I know that I can use Ctrl+A then sort and the information in the rows should stay together, however for some reason now 2 of the columns are not staying with their rows. I have over 1200 rows and that I need to have stuck together. Now that I am in a new year, I am starting a new spreadsheet for the information and once again the information in these last 2 columns are not following (the columns in question are the ones in the red border in the picture). The 4 columns to the left all stay together whenever I sort them but the right 2 just stay in that position.

My question:

Is there a way to lock the information in the rows together actively and how do I do it? I did not make this spreadsheet, nor am I proficient in excel. What I don't understand is why in the previous version would these columns work during my sorting and all the sudden stop. I am adding information to this daily and all I want to do is be able to sort a column and have the rows stick together. I just want to be able to add data and be able to sort it while knowing that the data in the rows will always be locked together without having to go through a bunch of key strokes to ensure the cells stay together. I feel like this is a simple task for a program as robust as excel, however I can find nothing that helps me short of always having to perform extra key combinations prior to a sort.

Also, I will not be sorting from the last 2 columns, I just want the relevant information to be locked to the rest of the data in that row.

ExcelPic.jpg

From the image you posted, it appears that the two problem columns are not part of the filtered data range.
CTRL+A does not always select what you want, although it usually does a pretty good job.

I'd suggest:
• turn off the filtering
• manually select the range you want included in the filter/sort data
• turn filtering on
• sort your data.

Does that help?

If the issue is that new rows added to the data do not get included in the sorting/filtering process, then....
• convert your data to an Excel Table
...Select the current data list
...Home.Format_as_Table (follow the prompts)

Excel will treat the table as a cohesive data set, automatically expanding/contracting to accommodate the available data. Now, sorting/filtering will always include all of the data.

Does that help?