Excel question - locking rows ???
Excel question - locking rows ???
Author
Discussion

ItsTony

Original Poster:

960 posts

248 months

Sunday 20th July 2008
quotequote all
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.

Justayellowbadge

37,057 posts

273 months

Sunday 20th July 2008
quotequote all
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.

ItsTony

Original Poster:

960 posts

248 months

Sunday 20th July 2008
quotequote all
thanx

otolith

69,816 posts

235 months

Sunday 20th July 2008
quotequote all
From reading the title only, I could feel my "Excel Is Not A Database" rant brewing wink

im

34,302 posts

248 months

Sunday 20th July 2008
quotequote all
otolith said:
From reading the title only, I could feel my "Excel Is Not A Database" rant brewing wink
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.

Justayellowbadge

37,057 posts

273 months

Sunday 20th July 2008
quotequote all
im said:
otolith said:
From reading the title only, I could feel my "Excel Is Not A Database" rant brewing wink
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.
Oh dear.

Plotloss

67,280 posts

301 months

Sunday 20th July 2008
quotequote all
im said:
otolith said:
From reading the title only, I could feel my "Excel Is Not A Database" rant brewing wink
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.
That depends on what you define as a database.

By any reasonable technical definition its not, not even close.

otolith

69,816 posts

235 months

Sunday 20th July 2008
quotequote all
im said:
otolith said:
From reading the title only, I could feel my "Excel Is Not A Database" rant brewing wink
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.
That's because what most people need at home isn't a database; it's a spreadsheet.

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.

im

34,302 posts

248 months

Sunday 20th July 2008
quotequote all
Plotloss said:
im said:
otolith said:
From reading the title only, I could feel my "Excel Is Not A Database" rant brewing wink
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.
That depends on what you define as a database.

By any reasonable technical definition its not, not even close.
Without getting all technical, no...its not a relational or heirarchical (etc) database that can be queried using a Structured Query Language but...

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.

biggrin





Edited by im on Monday 21st July 10:37