Microsoft Office Tutorials and References
In Depth Information
Expanding (or Shrinking) a Table
the next. If you choose 2 for First Row Stripe and Second Row Stripe, each band of shading
is applied to two rows at a time.
Custom styles appear at the top of the Table Styles Gallery. If you right-click on a saved
custom table style, you’ll notice that Modify and Delete options are available via the right-click
menu; these options cannot be used with predeined table styles.
Fonts and colors in custom table styles behave unexpectedly
Although the Format Cells dialog box for each table element includes a Font tab, most
of the options on that tab are unavailable. You can change the font style and color, but
the actual font and font size are determined by the current theme. To apply a table
font that is not part of the current theme, you must select the entire table and apply
the font formatting manually. In addition, if you choose a background or ill color from
the selections on the Fill tab, these colors change when you change the theme. To
apply a specific color to part of the table and ensure that the color remains unchanged
when the theme changes, you must use the More Colors option and define that color
Expanding (or Shrinking) a Table
Although you can define a table by selecting a range of any size, the most common and
useful scenario defines a table using the current region, which is demarcated by blank cells
(or the worksheet’s edge) on the top, bottom, and sides. To add a row to the table, click in
the cell in the lower right corner of the table range (if your table has a Total row, use the
row above it), and then press Tab. Excel adds a new row using the colors, fonts, and
shading from the current table style and moves the active cell to the first column in the newly
created row. If your table includes a Total row, it shifts down to accommodate the new row
as well.
To expand a table manually, look in the lower right corner of the table for a small
triangular handle. Make sure that that cell is not selected, and then aim the mouse pointer at the
handle until the pointer turns into a two-sided diagonal arrow. Drag down to add rows to
the table, shifting the Total row down if necessary. Drag the handle to the right to add one
or more columns (each new column gets a generic heading that you can change later when
you’re ready to enter data).
You can also drag the table sizing handle up or to the left to remove rows or columns from
the defined table range. Any data currently contained in those cells remains.
Search JabSto ::

Custom Search