Software

Ask something
Discussion Locked

excel "sort "question

0 helpful
5 replies

by sw723

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am trying to soret a spreadsheet by certain columns, but when i go to sort under data it does not show the columns i want to sort by, it only shows 1st 5 columns.

help

5 replies

by dklippert

When sorting, only select on cell in the table.
To troubleshoot, choose one cell in the list and hit Ctrl+*
This will show you the "Current Region".
I might posit that you have an empty row between 5 and 6.

by salamander

If you click the "Select All" button (the blank space above row 1 and to the left of column A, your entire worksheet will be selected. When you then go to Data > Sort, all columns in your worksheet will be shown as options to sort by.

This discussion is closed to new replies.