I want to highlight, for example, rows 5-15 across columns C, D, and E, and sort only that block in ascending order by one of the columns. The trick is that I want all included columns to follow suit so that the data maintains integrity within rows.
Usually when you sort ascending or sort descending it's by highlighting an entire column, and you're given an option to expand the selection, which would sort your entire spreadsheet based on the new order.
Am I able to sort only a block, without choosing the entire column?
Best Answer
The only solution I found is to cut and paste the highlighted portion to a new sheet and then sort it over there, once sorted copy/cut and paste it back to the original location.