Locking Rows when sorting Excel 1997

  • Thread starter Thread starter Dan-Lambert
  • Start date Start date
D

Dan-Lambert

Hello I am currently trying to add 9 columns of collected data to an
existing data base in excel. The database consists of over 1400
property parcel descriptions sorted out in rows. The data was imported
from ArcView, a GIS program. The existing order of the data is random
as per the GIS program and is almost impossible to organize to input
the data. I was wondering if you could lock all the data within a row,
so when you use the sorting functions all the data within each row stay
the same.
 
Just make sure you have selected all 9 columns as your sort range. Sort on
one column and all rows remain "locked" together.

Gord Dibben XL2002
 
If you select all the data before sorting Excel will keep everything
in the rows together.

Regards
BrianB
 

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

lock rows on sort 8
Auto sorting? Auto lock? 1
Excel 2003 -- header row sorting 1
removing spaces in cells changes the way rows sort 1
Solution needed to sort via button after deleting rows 6
locking ranges in functions while re-sorting data 1
Sort on 3 columns when number of rows vary daily 1
unable to add row to Excel 2007 TABLE 3

Back
Top