Works vs. Excel

  • Thread starter Thread starter nails
  • Start date Start date
N

nails

How do I want to present this.

Should a spreadsheet be set up in the same manner in both, or are the
different ducks so to speak.

What I do requires sorting several coloums, one at a time to get th
desired results I want.

This works fine in Works but is quite a different animal in Excel.

Should I be using filters, lists, or something else that is foreign t
me at this time.

ra
 
In Excel, if you want to easily sort columns separately, leave one or
more blank columns between them. Then, select a cell in the column that
you want to sort, and click the A-Z or Z-A button on the toolbar.

You can hide the blank columns, or make them very narrow, and they won't
be evident when printing.
 
As long as you select just the data you want to sort then you should be OK. If
Excel tries to help you and asks if you want to extend the selection just say
no.
 
Deb, Ken,

Sometimes I want to sort all the information and other times I don't.

The times I don't want to sort all the information (by saying all th
information means the information in the cells to the left and right o
the selected cells)
 
And both answers addressed that ;-)

If I have say 5 columns of data, A,B,C,D,E, and each cell in the range A1:E100
contains data, and I select just B1:B100 to sort and hit Data / Sort, I get
prompted with a message saying there is data either side of my selection, so do
I:-

a) want to expand my selection top include the other data

b) carry on with just what I have selected

It's my choice. I would never normally however, rely on Excel to expand it for
me, so if I wanted to sort it all, I would have selected it all to start with.
Debra's solution would prevent you from having to deal with the message, but you
get the extra columns - It's your choice, but both options will suffice for what
you have described.
 
Back
Top