Something that I see repeatedly is people opening an Excel file when they want to type in a table of information. They do this even if the table contains no numbers, there are no calculations required and some of the cells contains whole sentences and paragraphs. A common scenario is people using spreadsheets for tracking tasks.
One reason is that Excel and other spreadsheet programs have sophisticated table manipulation capabilities such as sorting and filtering. And because they have unlimited columns, they don’t run out of space on the right side. But frequently, people don’t need the advanced functions and they face the following problems when using a spreadsheet:
- Not enough room in a cell to type more than a few words.
- Each cell doesn’t have the easy editing capabilities of a word processor.
- Formatting the table for a better printed layout is often tough.
Using tables in a word processor like Microsoft Word or Open Office is sometimes superior for text-only tables. Word even has sorting for tables if that is what you are interested in. It is easy to add differently formatted text. Tracking editing changes by multiple users is also possible.
I recently noticed a friend adding a serial number column as the first column in an Excel sheet. This is obviously redundant and can introduce errors if done manually. But this behavior illustrates that people are not used to taking advantage of Excel’s capabilities (even those highly visible) and are, on net, hindered by its disadvantages.