egyptopf.blogg.se - Slide sorter on excel for mac

The entire row or just a portion of the row as shown here. In Word, use the little-known SHIFT-ALT-UP-ARROW and SHIFT-ALT-DOWN-ARROW to very speedily slide rows (or selected chunks Paste the data into a Microsoft Word document, where it automatically becomes a table and retains all your formatting.

It is best to note the size of the range, e.g., 118 rows x 5 columns

Copy the relevant chunk of rows and columns out of your speadsheet.

Involves moving the data to Word, employing the Word command and then Microsoft Word has a feature which Excel is lacking. I found a more direct answer to your question from this site:

In dealing with similar cases in the past, where I could not just sort by a row, I found way to generate a column with a formula result that was something I could sort on.