Microsoft Office Tutorials and References
In Depth Information
Cell Formatting from the Home Tab
Banded Rows to have Excel apply shading to every other row in the
table.
First Column to have Excel display the row headings in the first column
of the table in bold.
Last Column to have Excel display the row headings in the last column
of the table in bold.
Banded Columns to have Excel apply shading to every other column in
the table.
Whenever you assign a format in the Table Styles gallery to one of the data
tables in your workbook, Excel automatically assigns that table a generic
range name (Table1, Table2, and so on). You can use the Table Name text box
in the Properties group on the Design tab to rename the data table to give it a
more descriptive range name. (See Chapter 6 for all you need to know about
naming cell ranges.)
When you finish selecting and/or customizing the formatting of your data
table, click a cell outside of the table to remove the Table Tools contextual
tab (with its Design tab) from the Ribbon. If later, you decide that you want
to further experiment with the table’s formatting, click any of the table’s cells
to redisplay the Table Tools’ Design tab at the end of the Ribbon.
You can also use the Tables option on the Quick Analysis tool to format your
worksheet data as a table. Simply select the table data (including headings)
as a cell range in the worksheet and then click the Tables option on the Quick
Analysis tool, followed by the Table option below at the very beginning of the
Tables’ options. Excel then assigns the Table Style Medium 2 style to your
table while at same time selecting the Design tab on the Ribbon. Then if you’re
not too keen on this table style, you can use Live Preview in the Tables Styles
gallery on this tab to find the table formatting that you do want to use.
Cell Formatting from the Home Tab
Some spreadsheet tables or ranges within them require a lighter touch than
the Format as Table command button offers. For example, you may have a
data table where the only emphasis you want to add is to make the column
headings bold at the top of the table and to underline the row of totals at the
bottom (done by drawing a borderline along the bottom of the cells).
The formatting buttons that appear in the Font, Alignment, and Number
groups on the Home tab enable you to accomplish just this kind of targeted
Search JabSto ::




Custom Search