How to expand columns when sorting

  • Thread starter Thread starter joe
  • Start date Start date
J

joe

On my computer with Office 2003 installed, when I want to sort on a
column, I select the column, click on Sort Ascending, Excel would
prompt me that it found data in the adjacent field and if I want to
expand the selection.

That's how sorting is done on my computer. Today I had to use someone
else's PC and it has Office 2003 too. However, when doing sorting, it
doesn't prompt me and just sort that column only. How to make Excel
prompt me for this?
 
First, I wouldn't let excel guess at my range to sort. I'd always select the
range and do Data|sort.

But when you selected that column, was it isolated (empty columns on each side)
from the other data?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mailing address block: sorting 1 row to columns 1
Data Sort Unique 5
Using a drop-down box to sort data based on seperate columns 2
MACRO RUN random percentage and copy of column values 1
Excel 2007 Sort-How to Retain Sort Order 3
Question on Sorting by (date, etc) 5
Sort cells and "Place in this document"-hyperlinks 1
How to paste absolute references or sort links 2

Back
Top