Entering and Editing Worksheet Data
Michael Alexander, Dick Kusleika, John Walkenbach · 2018
This chapter describes what user needs to know about entering and modifying data in their worksheets. An Excel workbook file can hold any number of worksheets, and each worksheet is made up of more than 17 billion cells. A worksheet can also hold charts, diagrams, pictures, buttons, and other objects. Excel treats dates and times as special types of numeric values. Dates and times are values that are formatted so that they appear as dates or times. Excel provides a variety of number formatting options. The chapter explains how to use many of Excel's formatting options to improve the appearance and readability of user's worksheets quickly. A way to apply number formatting is to use shortcut keys. Excel offers a great deal of control over number formats through the use of the Format Cells dialog box.