lock rows on sort

  • Thread starter Kenneth C. Benson
  • Start date
K

Kenneth C. Benson

I'm working on a large table (about 2000 rows, 50 columns). I frequently
have to sort the entire table based on one column, and I keep forgetting
and sort just the column, disassociating the rest of the data from that
column.

Is there a way to lock rows so that I can't make this mistake, so that
whenever I sort a column it sorts the whole table based on that column?

Ken Benson
 
R

RagDyer

Assign a short name to the entire datalist, like say "lst",
and then just click on that name in the name box before you start any sort.
 
T

TedMi

To ensure that the name remains valid as the list grows, read up on how to
organize the list - look up "list" in Excel's Help index.
-TedMi
 
S

Shane Devenshire

Hi,

Maybe the easiest solution is not to select the column but to select a
single cell in the column you want to sort on. This works if
1. you have no data touching the data range that you don't want to sort
2. there are no completely blank rows within the data
3. there are no completely blank columns within the data.

The general rule is either select all the data or just a single cell,
anything else is bad news.

If this helps, please click the Yes button

Cheers,
Shane Devenshire
 
S

SmartbizAustralia

If the header rows are on the first, then always select the columns
then let the sort let you choose the column.

Otherwise, record the sorting as a macro....making sure you always
include all the rows...e.g. the last rows in case you add more..

Regards,
Tom Bizannes
Excel Development
Sydney,Australia
http://www.macroview.com.au
 
C

Cindy Schmit

I am working on a spreadsheet tracking items of jewelry I've ordered that includes the date, website, item number, they jewelry type, the jewelry description, the cost, the cost of shipping for the item, the total cost, the date the item was received and a picture of the item.

I want to lock each row but even though I've locked the picture in place some of them still float around.

Can you help me?

Thank you!
 
G

Gord

The pictures will sort with the appropriate rows if.....IF.......they
lie entirely within the confines or the cell boundaries.


Gord Dibben Microsoft Excel MVP
 

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

Top