27-03-2014, 04:36 PM
Formatting Worksheets
Formatting Worksheets.pdf (Size: 1.78 MB / Downloads: 79)
INTRODUCTION
Excel makes available numerous formatting options to give your
worksheet a polished look. You can change the size, colour and
angle of fonts, add colour to the borders and backgrounds of
cells, and have the format of a cell change, based on its value.
You will see that some of the formatting features in MS Excel are
same as you have used in MS Word.
OBJECTIVES
After going through this lesson you would be able to:
use autoformat features
format data and worksheets
use format painter
use formulas and functions
USING FORMATTING TOOLBAR
Formatting helps to make our work more presentable. It also
helps the viewer/reader to understand the worksheet more
easily with respect to its purpose.
Home Tab and the Formatting Tools
Home tab provides the quick access to the most commonly used
options with respect to the formatting requirements. You can
select a cell or a range and then use the tool as per the need like
Font, Alignment or Number groups. To understand the proper
and best use of such tools, only way is to use them and
experience their effect. Some of the controls are further
expandable like drop-down lists etc. If you see some small arrow
along with a button. The button will expand to display the
available choices.
Number tab
The data type can be selected from the options on this tab. Select
the range you would like to format and click on one of the
Category number as shown in Figure 7.2 to apply that style to your
numbers. Select General if the cell contains text and number and
it does not have any specific number format. If you select
Number Category you can represent numbers as integers,
decimals with number of decimal as option etc. For example, if
you want to restrict the number of decimals to 2, choose Number
Category and then decimal places as 2. You may try the other
options in your computer.
Dates and Times
If you enter the date “January 1, 2001” into a cell on the
worksheet, Excel will automatically recognize the text as a date
and change the format to “1-Jan-01”. To change the date format,
select the Number tab from the Format Cells window. Select
“Date” from the Category box and choose the format for the date
from the Type box. If the field is a time, select “Time” from the
Category box and select the type in the right box. Date and time
combinations are also listed. Press OK when finished.
FORMAT PAINTER
A handy feature on the standard toolbar for formatting text is the
Format Painter. If you have formatted a cell with a certain font
style, date format, number format, border, and other formatting
options, and want to format another cell or group of cells the same
way, place the cursor within the cell containing the formatting you
want to copy. Click the Format Painter button in the clipboard
group of Home tab(notice that your pointer now has a paintbrush
beside it). Highlight the cells you want to apply the same
formatting. The formatting will change accordingly.