• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
WittySparks Logo White

WittySparks

Ignite Your Thoughts

  • Topics
  • Reviews
  • Newsletter
WittySparks / Technology / Software / How to create and work with tables? – MS Excel 2007 Tips
Microsoft Excel 2007 Tips

How to create and work with tables? – MS Excel 2007 Tips

Software December 24, 2008 by Kartik Subramaniam

Excel 2007 has come up with several customized features and one of them is Tables. Working with tables has been much more appealing and customized for its users in the newer version. To give you a glimpse, let’s work with a set of values.

Enter a few values in an excel sheet as follows

Enter Values in Tables Excel
Enter Values in Tables Excel

Type Alt+n+t . This would result in the Insert tab and select the Tables option
You would get to see the following box, click Ok.

Alt+n+t Excel
Alt+n+t Excel

This would transform the appearance of the table as follows

Table Appreance Excel
Table Appearance Excel

If you notice, Excel 2007 creates a filter in the column based on the values in the column. You would also see another tab in the ribbon-Design (which appears in the case of Tables).

Design Ribbon Excel
Design Ribbon Excel

In the Design ribbon, some of the key features which are used commonly are:
Properties

  • Table Name

Table Style Options

Table Style Options Excel
Table Style Options Excel
  • By selecting Banded Rows, you would get an alternating color pattern in the rows
  • By checking the Total Row box, you would get the total of the row values at the end
  • Selecting the First Column or Last Column highlights the formatting in that column

Table Styles
You can change the appearance of the table by selecting the options in Table Styles as follows:

Table Styles
Table Styles

Related Topics

  • FlexClip Review: Is it the right tool for Video Creators?
  • Hubstaff Review: Is it the best time tracking tool?
  • Website Analytics: Almost Everything You Need To Know
Previous Post: « The Broken Window by Jeffrey Deaver – Book Review
Next Post: iRing – a new Bluetooth Ring Concept »
Profile picture for Kartik Subramaniam

About Kartik Subramaniam

A dreamer of sorts & a Creative writer, passionate about reading diverse stuff.

View all posts by Kartik Subramaniam

Primary Sidebar

Search

Exclusive Coupons

  • Moqups coupon code: WITTYSPARKS for 20% or PARTNERS50 for 50% discount.
  • WPForms coupon code: WITTYSPARKS for 50% off.
  • Serpstat coupon code: wittysparks_discount for 30% off.
  • SEO Buddy coupon code: WITTYSPARKS for 25% off.
  • Morningscore coupon code: wittysparks for 30% off for 3 months.
  • FlexClip coupon code: WITTYSPARKS for 30% off.
  • Uplead coupon code: “witty” for 30-day free trial.
  • FastestVPN coupon codes: WITTYSPARKS15 or WITTYSPARKS10 or Get up to 93% OFF.
  • Outranking.io coupon code: WITTYSPARKS50 for 50% off.

For more such offers visit our exclusive offers for SEO, Bloggers, Marketers and for Business owners.

Featured Productivity Software

Notion logo
Notion

Whether you’re a solo entrepreneur or a large team, Notion Workspace can help you stay organized and get more done. Get started today and take your productivity to the next level.

Try Notion for FREE

Footer

Affiliate Disclosure

If you make a purchase from WittySparks links, we will receive a small commission. See our Affiliate Disclosure.

Sponsors

Partnered with FreePik to use the licensed images.

turn to dhgate for smartphone

Follow Us

  • Facebook
  • Twitter
  • Pinterest
  • LinkedIn
  • Instagram
  • YouTube
  • RSS

Copyright © 2023 · Hosting sponsored by Rocket.net (Affiliate link)

  • About Us
  • Contact Us
  • Privacy Policy
  • LinkedIn
  • Twitter
  • Like
  • Pinterest