ABSTRACT

This chapter guides the users how to formatting the cells in Excel. Formatting is the term used for changing the appearance of text or numbers to assist in making data more meaningful. The Shift key and the Caps Lock key operate in the same way as on a typewriter, and enable capitals and other characters to be typed. It is possible to apply the same formatting to several non-adjacent cells at a time by holding down the Control key while selecting them. Although Excel is mainly about numbers users also need to add text to their work in order to explain it. Text in Excel is typed just as users would on a word processor, but the main purpose of the text is to label data. Comments frequently happen that users wish to make a note about the contents of a particular cell. This can be done very conveniently by selecting the cell and using the Menu Insert Comment functions.