Excel 2010 Formatting Tables

Author: mety Nagm Labels::

Excel 2010

Formatting Tables


Lesson 14
Once you have entered information into a spreadsheet, you may want to format it. Formatting your spreadsheet can not only improve the look and feel, but also make it easier to use. In a previous lesson, we discussed many manual formatting options such as bold and italics. In this lesson, you will learn how toformat as a table, to take advantage of the tools and predefined table styles available in Excel 2010.

Formatting Tables

Launch video!Watch the video (2:37). Need help?
Watch the video to learn about formatting tables in Excel 2010.

To Format Information as a Table:

  1. Select the cells you want to format as a table. In this example, an invoice, we will format the cells that contain the column headers and the order details.
    Selecting cells to format as a tableSelecting cells to format as a table
  2. Click the Format as Table command in the Styles group on the Home tab. 
    Format as Table commandFormat as Table command
  3. A list of predefined table styles will appear. Click a table style to select it. 
    Selecting a table styleSelecting a table style
  4. A dialog box will appear, confirming the range of cells you have selected for your table. The cells will appear selected in the spreadsheet, and the range will appear in the dialog box.
  5. If necessary, change the range by selecting a new range of cells directly on your spreadsheet.
  6. If your table has headers, check the box next to My table has headers
    Creating a tableCreating a table
  7. Click OK. The data will be formatted as a table in the style that you chose.
    Data formatted as a tableData formatted as a table
Tables include filtering by default. You can filter your data at any time using the drop-down arrows in the header. To learn more, review our Filtering Data lesson.
To convert a table back into "normal" cells, click the Convert to Range command in the Tools group. The filters and the Design tab will then disappear, but the cells will retain their data and formatting.

Modifying Tables

To Add Rows or Columns:

  1. Select any cell in your table. The Design tab will appear on the Ribbon.
  2. From the Design tab, click the Resize Table command.
    Resize Table commandResize Table command
  3. Directly on your spreadsheet, select the new range of cells that you want your table to cover. You must select your original table cells as well.
    Selecting a new range of cellsSelecting a new range of cells
  4. Click OK. The new rows and/or columns will be added to your table.
    After adding new rowsAfter adding new rows

To Change the Table Style:

  1. Select any cell in your table. The Design tab will appear.
  2. Locate the Table Styles group. Click the More drop-down arrow to see all of the table styles.
    The More drop-down arrowThe More drop-down arrow
  3. Hover the mouse over the various styles to see a live preview.
  4. Select the desired style. The table style will appear in your worksheet.
    After changing the table styleAfter changing the table style

To Change the Table Style Options:

When using an Excel table, you can turn various options on or off to change its appearance. There are six options:Header RowTotal RowBanded RowsFirst ColumnLast Column, and Banded Columns.
  1. Select any cell in your table. The Design tab will appear.
  2. From the Design tab, check or uncheck the desired options in the Table Style Options group.
    Table style optionsTable style options
Depending on the Table Style you're using, certain Table Style Options may have a different effect. You may need to experiment to get the exact look you want.



Blog Archive

Powered by Blogger.

I made these pages for me and my friends to help solving the problem we face regarding Computer & internet, if anyone wants me to answer a question or find out about some information please send me email and I will try to reply.*P.S. some of the article I wrote and the other I found on the internet I posted them in sprit of learning and shearing, please forgive me if you found something you don’t want to be in my blog, email me and I will delete them. Thank you for your interest in my pages.امل نجم Amal Nagm

banner 1 banner 2