Posted by: tonyteaching | April 8, 2009

Ms. Excel 2007: “Create as Table” to change your data list to Table

Some reasons why it’s useful to change our data list to be Table:

as a table, our data will be easy to be filtered (e.g. just show particular data which equal with …, OR greater than …, AND less than …, above average, below average, shorted ascending/descending, …)

just use:

– Select the data

– ‘Home’ Tab > ‘Style’ group > “Format as Table” Button > choose the style as you want to


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Categories

%d bloggers like this: