Scribd
Upload
271 views

Excel Table Styles - Easy Excel Tutorial

Excel Table Styles

Uploaded by

Jamalodeen Mohammad
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
271 views

Excel Table Styles - Easy Excel Tutorial

Excel Table Styles

Uploaded by

Jamalodeen Mohammad
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 6

Excel Table Styles - Easy Excel Tutorial http://www.excel-easy.com/examples/table-styles.

html

Excel Easy
#1 Excel tutorial on the net Excel Introduction Basics Functions Data Analysis VBA 300 Examples Ask us

Table Styles
Quickly format a range of cells by choosing a table style. You can also create your own table style. Quickly format
Chapter
a cell by choosing a cell style.

1. Click any single cell inside the data set. Tables

Learn more, it's easy

Structured References

Table Styles

Download Excel File

table-styles.xlsx

Follow Excel Easy

1 of 6 08-11 06:47 PM
Excel Table Styles - Easy Excel Tutorial http://www.excel-easy.com/examples/table-styles.html

Start Free Download


Start Tracking your Package w/ Link Get
Package Tracer for Free - Now!

Download Now

Nifty & bank nifty tips

DHFL Home Loan


2. On the Home tab, in the Styles group, click Format as Table, and choose a table style.

2 of 6 08-11 06:47 PM
Excel Table Styles - Easy Excel Tutorial http://www.excel-easy.com/examples/table-styles.html

Note: click New Table Style to create your own table style or right click a table style and click Duplicate to create a
new table style that is similar to an existing one. Modifying a custom table style affects all tables in a workbook

3 of 6 08-11 06:47 PM
Excel Table Styles - Easy Excel Tutorial http://www.excel-easy.com/examples/table-styles.html

that use that table style. This can save a lot of time.

3. Excel automatically selects the data for you. Check 'My table has headers' and click on OK.

Result. This is another way to insert a table.

To convert this table back to a normal range of cells (and keep the formatting), execute the following steps.

4. On the Design tab, in the Tools group, click Convert to Range.

4 of 6 08-11 06:47 PM
Excel Table Styles - Easy Excel Tutorial http://www.excel-easy.com/examples/table-styles.html

Result. A nicely formatted range of cells.

Note: to remove the table style, select the range of cells, on the Home tab, in the Styles group, click Normal.

5 of 6 08-11 06:47 PM
Excel Table Styles - Easy Excel Tutorial http://www.excel-easy.com/examples/table-styles.html

Max Life Term Insurance


1 Cr Cover @Rs 16/Day*. 95.5% Claim
Settlement Ratio. Get Free Quote!

Do you like this free website? Please follow us on Google+

Learn more about tables, use the side menu >>


Go to Top: Table Styles | Go to Next Chapter: What-If Analysis

COPYRIGHT (C) 2010-2015 WWW.EXCEL-EASY.COM. ALL RIGHTS RESERVED.


EXCEL 2010 TUTORIAL | HOW TO EXCEL | MICROSOFT EXCEL 2010 | EXCEL MACRO

6 of 6 08-11 06:47 PM

You might also like