Microsoft Office Tutorials and References
In Depth Information
Chapter 3: Making It All Look Pretty
Chapter 3
Making It All Look Pretty
In This Chapter
Selecting the cells to format
Formatting data tables with the Format as Table command button
Using various number formats on cells containing values
Adjusting column width and row height in a worksheet
Hiding columns and rows in a worksheet
Formatting cell ranges from the Home tab of the Ribbon
Formatting cell ranges using Styles and the Format Painter
Formatting cells under certain conditions
In spreadsheet programs like Excel, you normally don’t worry about how
the stuff looks until after you enter all the data in the worksheets of your
workbook and save it all safe and sound (see Chapters 1 and 2). Only then do
you pretty up the information so that it’s clearer and easy to read.
After you decide on the types of formatting that you want to apply to a
portion of the worksheet, you can select all the cells to beautify and then click
the appropriate tool or choose the menu command to apply those formats to
the cells. However, before you discover all the fabulous formatting features
you can use to dress up cells, you need to know how to pick the group of
cells that you want to apply the formatting to — that is, selecting the cells or,
alternatively, making a cell selection .
Be aware, also, that entering data into a cell and formatting that data are
two completely different things in Excel. Because they’re separate, you can
change the entry in a formatted cell, and new entries assume the cell’s
formatting. This enables you to format blank cells in a worksheet, knowing that
when you get around to making entries in those cells, those entries
automatically assume the formatting you assign to those cells.
Search JabSto ::




Custom Search