ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   when I sort it tells me to select a single cell, even though I did (https://www.excelbanter.com/excel-discussion-misc-queries/242866-when-i-sort-tells-me-select-single-cell-even-though-i-did.html)

boombox

when I sort it tells me to select a single cell, even though I did
 
Is this a glich? I'll select a single cell, click the sort button and I get
an error message. If I try to sort by a different column and then come back
to the one I want to sort, sometimes that works. But I very clearly only
have one cell selected. is this a bug?

Bob Umlas[_3_]

when I sort it tells me to select a single cell, even though I did
 
Is it a merged cell?

"boombox" wrote in message
...
Is this a glich? I'll select a single cell, click the sort button and I
get
an error message. If I try to sort by a different column and then come
back
to the one I want to sort, sometimes that works. But I very clearly only
have one cell selected. is this a bug?




boombox

when I sort it tells me to select a single cell, even though I
 
No, it's just a regular cell. Nothing special about it, sometimes it's blank
and sometimes not, but it doesn't seem to matter. I can click a cell with a
value and one with out, and I'll still get the message. I can try another
cell in a nother column that has the same properties (filled or unfilled) and
it will work, come back to the column and it does work. This happens when
the values are numbers, letters, email addresses, etc. Sometimes it will
work and sometimes I get the error message, often with the very same cell.

"Bob Umlas" wrote:

Is it a merged cell?

"boombox" wrote in message
...
Is this a glich? I'll select a single cell, click the sort button and I
get
an error message. If I try to sort by a different column and then come
back
to the one I want to sort, sometimes that works. But I very clearly only
have one cell selected. is this a bug?






All times are GMT +1. The time now is 09:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com