Hi! This is my first posting to this forum and hoping for some advice - I have opened a Calc file which was previously saved in Excel, everything looks fine and sorts well. However, when i add a new entry at the bottom of the sheet it isn’t included in the sort. What am I doing wrong?
isn’t included in the sort
What am I doing wrong
You ask what you may do wrong, but don’t describe what you are doing exactly, when you sort after having added a new entry. Or do you expect it to get sorted without taking further action?
I tab across the row and add my data, then I go to Data - Sort A-Z - Sort options - ticked range for the column Labels - Sort criteria Key 1 for my column and press ok everything else sorts expect the latest input.
I’ve checked the box under the General tab for Expend references when new columns/rows are inserted and run a sort, to no avail, it’s still not sorting any new data added.