Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel as a database and sorting information
Hi,
If I want to use the excel spreadsheet as a sort of database how can I sort the rows so that the records with a particular piece of information are at the top of the list? Can I tie a set of cells in a row together so that they will not be broken up by accidentally sorting a column on its own ather than the whole sheet? Regards Steve |
#2
|
|||
|
|||
Don't sort a database, use filters, Auto and/or Custom!
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- ##### wrote in message ... Hi, If I want to use the excel spreadsheet as a sort of database how can I sort the rows so that the records with a particular piece of information are at the top of the list? Can I tie a set of cells in a row together so that they will not be broken up by accidentally sorting a column on its own ather than the whole sheet? Regards Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SORTING question | New Users to Excel | |||
How to sort/update large excel db | Excel Discussion (Misc queries) | |||
How to find the minimum value in a database with multiple values . | Excel Discussion (Misc queries) | |||
Question on sorting dates | Excel Discussion (Misc queries) | |||
does cell formating move with sorting | Excel Discussion (Misc queries) |