Excel Workbook For Dummies, 2nd Edition

Chapter 3

Formatting the Worksheet

IN THIS CHAPTER

Resizing columns and rows in a worksheet

Formatting cells with the Home tab of the Ribbon

Formatting cells with the Format Cells dialog box

Using cell styles

Using conditional formatting

Hiding columns and rows in a worksheet

Excel offers many ways to format a worksheet, but most of your formatting chores will involve changing the look of cells in the worksheet. The formatting you assign a cell not only affects the cell’s current contents but it also affects any content you subsequently enter into the cell. The exercises in this chapter give you a chance to practice widening and narrowing the columns and rows of a worksheet to suit the formatting and contents of its cells. In addition, you discover a full array of techniques for assigning formatting to cells in worksheets, using features found on the Home tab of the Ribbon as well as ...