Incidentally, an Excel cell can hold up to 32,767Ī worksheet can span up to 256 columns andĦ5,536 rows (giving you a grand total of 16,777,216 Figure 1-2 shows this cell, which looks like a Third column), and row 6 (the sixth row). The smallest unit in your worksheet is the cell. ), while rows are identified with numbers The grid divides your worksheet into rows and Learn how to enter information in the Excel window and how to open Quick tour of Excel as you start creating aĬomplete in this chapter. The best way to avoid potential headaches like these is to take a The feature you’re hunting for desperately. Others can be supremely annoying-especially when Excel hides Some of the features are genuinely useful, while

Hide advanced options, lists that complete themselves, animatedĪssistants, and every imaginable type of button, toolbar, andĭockable window. As a result, Excel is packed full of timesavingįeatures-some nifty, some just quirky-like menus that With the latest version of Excel, and then tweaks the program to make Gathers a group of spreadsheet novices, watches them fumble around Usability tests, which are aimed at figuring out how easy-or So what has Microsoft been doing ever since? The answer,Īt least in part, is spending millions of dollars on so-called By 1993, Excel had morphed into anĪll-purpose number-cruncher, and it quickly eclipsed competingĪlthough Microsoft is reluctant to admit it, most ofĮxcel’s core features were completed six or seven

Version of Excel for the Macintosh in 1985 and added a version for

Chapter 1. Creating and Navigating WorksheetsĮxcel has a long and colorful history.

Convert lotus 123 excel 2003