Making your worksheet look a bit fancier

At this point, you have a functional worksheet—but it could use some help in the appearance department.
Converting this range to an “official” (and attractive) Excel table is a snap:

  1. Move to any cell within the range.
  2. Choose Insert?Tables?Table. Excel displays its Create Table dialog box to make sure that it guessed the range properly.
  3. Click OK to close the Create Table dialog box. Excel applies its default table formatting and also displays its Table Tools?Design contextual tab. Your screen should look like Figure 12-11.
  4. If you don’t like the default table style, just select another one from the Table Tools? Design?Table Styles group. Notice that you can get a preview of different table styles by moving your mouse over the ribbon. When you find one you like, click it, and that style will be applied to your table.

FIGURE 12-11
Your worksheet, after converting the range to a table.

Add to Technorati Favorites


// Related Posted - GOOGLE!

Loading



Related Websites
No comments yet.

Leave a comment

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>