Excel question - locking rows ???
Discussion
ItsTony said:
Hi,
Just a quick question please.
I have a set of data that includes address's, telephone numbers etc. How do I lock the row of information so the address will stay with the telephone number when I rearrage the address row into alphabetical order.
Thanx in advance.
Highlight the whole sheet (top left cell) before you sort.Just a quick question please.
I have a set of data that includes address's, telephone numbers etc. How do I lock the row of information so the address will stay with the telephone number when I rearrage the address row into alphabetical order.
Thanx in advance.
im said:
otolith said:
From reading the title only, I could feel my "Excel Is Not A Database" rant brewing 
Its a very basic database - but still a database - its no Access I'll grant you but its fine for what most peeps require at home.
By any reasonable technical definition its not, not even close.
im said:
otolith said:
From reading the title only, I could feel my "Excel Is Not A Database" rant brewing 
Its a very basic database - but still a database - its no Access I'll grant you but its fine for what most peeps require at home.
I'm willing to accept that there are databases which are not relational databases (ODBMS/ORDBMS for example), but I don't think Excel is such a thing. It's a desktop spreadsheet application.
Plotloss said:
im said:
otolith said:
From reading the title only, I could feel my "Excel Is Not A Database" rant brewing 
Its a very basic database - but still a database - its no Access I'll grant you but its fine for what most peeps require at home.
By any reasonable technical definition its not, not even close.
For Mrs Smith from Hornchurch a housewife in her early forties who wants to create a christmas card list of names, addresses, telephone numbers, relationships etc and has a base knowledge of Excel but doesn't have the time or perhaps aptitude to learn Access (etc) its fine.
It'll sort records by criteria, you can do some basic querying, blah blah.
For business use it's possibly not a 'database' and for the geek its definately not - but in the world of ordinary people in their ordinary homes once data is entered onto the spreadsheet is a database.
And of course lets not forget the word 'Database' isn't an entirely computer related term and actually existed pre-modern computers. I give you 'Websters New World Dictionary of Computer Terms' description - please pay particular attention to the 2nd sentance:
Database: A collection of related information about a subject organized in a useful manner that provides a base or foundation for procedures, such as retrieving information, drawing conclusions and making decisions. Any collection of information that serves these purposes qualifies as a database, even if the information isn't stored on a computer. In fact, important predecessors of today's sophisticated business database systems were files kept on index cards and stored in file cabinets. Information is usually is divided into data records, each with one or more data fields.
When used by Mrs Smith Excel fits this definition.
Should Mrs Smith get curious then "Microsoft Excel includes worksheet functions that analyze data stored in lists or databases. Each of these functions, referred to collectively as the Dfunctions (an abbreviation of the term 'Database Functions'), uses three arguments: database, field, and criteria. These arguments refer to the worksheet ranges that are used by the function." (c) Microsoft
I hope your happy - you've now managed to turn me into a geek - although to be fair, in the late 90's I did teach Microsoft Office in a training college so am a little geeky already.

Edited by im on Monday 21st July 10:37
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff


