ChapterÂ 2.Â Adding Information to Worksheets
Now that youâve created a basic worksheet, and youâve become familiar with Excelâs spiffy interface, itâs time to get down and dirty by adding data to your spreadsheet. Whether you want to plan your household budget, build a sales invoice, or graph your soaring (or plunging) net worth, you first need to understand how Excel interprets the information you give it.
Depending on what kind of data you type into a cell, Excel classifies it as a number, a date, or a piece of text. In this chapter, youâll learn how Excel makes up its mind and how you can make sure it decides correctly.
After that, youâll learn how to use some of Excelâs best data-entry timesavers. Youâll zip around your worksheet with shortcut keys and the Go To feature, save time with AutoComplete and AutoCorrect, and use Excelâs new Flash Fill feature to automate tedious editing jobs. Youâll also master the indispensable Undo feature and Excelâs handy spell-checker. Finally, youâll consider a completely different editing task: adding a web-style hyperlink to your worksheet.
Adding Different Types of Data
One of Excelâs most important features is its ability to distinguish between different types of information. A typical worksheet contains both text and numbers. There isnât a lot you can do in Excel with ordinary text (other than alphabetize a list, perform a simple spell-check, and apply some basic formatting). On the other hand, Excel gives you a ...