Locking Rows when sorting Excel 1997

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.
 
G

Gord Dibben

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
 
B

BrianB

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

Linking Rows Between Sheets When Sorting 1
Hold conditional formatting when sorting filtered data 1
XY scatter plot with more than 32000 rows in Excel 2003 0
"Locking" Question Regarding Excel 2007 2
Sorting Groups of Rows 1
Need help with sort function and lots of data? 2
sort rows 4
sorting rows 7

Top