OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Keeping records together on a spreadsheet

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
reblynferg
Newbie
Newbie


Joined: 07 Feb 2009
Posts: 3

PostPosted: Sat Feb 07, 2009 4:59 pm    Post subject: Keeping records together on a spreadsheet Reply with quote

I created a spreadsheet with a lot of data on it that I need to sort. My question is how do I keep ROWS together when I sort the column. I created a row with first, last names, addresses etc. and now I need to sort the town names and still keep the info together for each person. Is there a way I can do this? Should I have done something different?
Back to top
View user's profile Send private message
RickRandom
Super User
Super User


Joined: 27 Jan 2006
Posts: 1082
Location: UK

PostPosted: Sun Feb 08, 2009 12:12 am    Post subject: Reply with quote

Not quite sure how your data is arranged, but avoid using the A-Z buttons when sorting, they don't always work as you might expect. Always select the whole range you want to sort, then from the menu, Data, Sort, then select the column you want to sort on, select whether you have column headings or not, then sort.

Let us know how you get on.
Back to top
View user's profile Send private message
reblynferg
Newbie
Newbie


Joined: 07 Feb 2009
Posts: 3

PostPosted: Sun Feb 08, 2009 5:22 am    Post subject: Thank you! Reply with quote

Yay! That worked! Thank you so much! I was beating my head against the wall because I have over 400 records that I entered and needed to use.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group