Tech Tips Home
The Best Tech Tips And Daily Deals
Newsletter On The Internet!

Shop online 24hrs a day or call us Mon-Fri
8:30AM-4:30PM EST - 1-800-915-2088
WorldStart Tech Tip And Store Search
Email: Password: Login Remember Me

Like what you see here? Subscribe to the Tech Tips newsletter!   Email: Subscribe

Include This Too? Maybe Not!

Tuesday, December 16th, 2008 by | Filed Under: MS Excel, MS Office Help
 
Loading...


Include This Too? Maybe Not!

So, have you taken some time to work with the tables found in MS Excel 2007 after last week’s tips?

If so, I’m sure you’ve noticed how they seem to have a whole set of behaviors you may not have expected.

After all, we see the table as a set of formatted cells, not as an object that will behave differently than the regular cells surrounding it. But that’s exactly what we have!

To make life easier when dealing with Excel 2007 tables, I’d like to show you another feature/behavior they exhibit: Table AutoExpansion.

When you choose to add a piece of information to a cell adjacent to the right side of the table or a cell directly below the table, you’ll find that Excel adds the column or row automatically to the table.

That behavior is called Table AutoExpansion and it’s part of Excel’s AutoCorrect, Format As You Type options.

If you like the simple way to expand your tables, the behavior is something you’ll want Excel to continue doing. But there still has to be a way to stop it from happening when necessary, isn’t there?

Why yes, I’m glad you asked!

When Excel automatically adds a row or column to your table, you’ll find that you also get an AutoCorrect Options button.

Clicking on that will allow you to undo the recent expansion or stop it altogether.

If you choose to stop it and later change your mind, you can turn the feature back on via the Office Button, Excel Options button, Proofing section, AutoCorrect Options button.

In the AutoCorrect dialogue window, under the Format As You Type tab, recheck the “Include new rows and columns in table” checkbox.

Click OK.

There you have it. A bit more control over the power of Excel 2007’s tables!

~ April

Leave a Reply


Like these tips? Get them for FREE in your email!

WorldStart's Tech Tips Newsletter

  • Tech Tips Daily - Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

  • Tech Tips Weekly - If you don't want our Tech Tips newsletter every day, then sign up for this weekly newsletter to get the best information of the week. Sent on Fridays.

Other Newsletters

  • WorldStart's Daily Deals - Every week, we send out great deals in our Daily Deals newsletter. Many of these deals are exclusively for our Daily Deals newsletter subscribers and can't be found with our regular specials.

  • Just For Grins - Each issue includes a couple clean jokes, some funny quotes, and a hilarious reader's story. Newsletter is sent five days a week.


Enter Email Address:

Subscribe

Your e-mail address is safe with us!
We only use it to send you the newsletters you request. It is NEVER disclosed to a third party for any reason, ever! Plus, if you decided you don't like our newsletters (don't worry, you'll love them), unsubscribing is fast and easy.

Free Newsletter Signup



Tech Tips Daily

Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

Tech Tips Weekly

The week's best in tech and computer help. Get your issue sent to your email every Friday!

WorldStart's Daily Deals

The very best deals on the Internet! Get a new set of incredible sales every day of the week!

Just For Grins

Clean jokes, funny quotes, and hilarious comics. Sent 5 times a week straight to your email.


Subscribe


Love Worldstart? Refer A Friend!

WorldStart's Premium Membership

Tip Archive


Categories:
Archives: