Table Formatting Without the Table Behavior I bet a few of you who have been working with the MS Excel 2007 tables the last couple of days have found yourselves wishing you could easily get the right formatting, without all the table behaviors that come with it. If you've been searching for a way to … Continue reading Table Formatting Without the Table Behavior
Oh, You Didn't Want the Table Column Full of Formulas?
Oh, You Didn't Want the Table Column Full of Formulas? If you worked through yesterday's tip about MS Excel 2007 tables, you know that entering a formula into a single cell will cause Excel to fill the table's entire column with the formula. It's handy if that's what you intended, but what if it's not … Continue reading Oh, You Didn't Want the Table Column Full of Formulas?
One Formula for the Whole Table Column
One Formula for the Whole Table Column Do you use MS Excel 2007's table formatting options? You know, the great looking and convenient formats found on the Format as Table button under the Home tab on the ribbon. Well, here's a real time saver I just happened to stumble across as I was exploring Office … Continue reading One Formula for the Whole Table Column
The Larger View
The Larger View Do you often work with MS Excel 2007? Ever wish for a quick way to enlarge an area of your worksheet so that you can see the details a little closer? While I know you've all found that Ctrl + scrolling the mouse wheel will do the trick quickly, you probably also … Continue reading The Larger View
Copied From Above
Copied From Above Here's a super quick copy trick for MS Excel! Have you ever needed an exact copy of a cell's contents? And I do mean exact. Even cell references won't be changed in your formulas. Well, here's the trick: simply select the cell directly below the item to be copied and use the … Continue reading Copied From Above
Breaking Up Isn't So Hard to Do
Breaking Up Isn't So Hard to Do If you tried the tip from the other day, where you imported data from the Web into Excel 2007, you may have found that not all data appearing to be a table is actually a table. Am I right? I found that many things I imported were actually … Continue reading Breaking Up Isn't So Hard to Do
Hassle Free Web Data in Excel 2007
Hassle Free Web Data in Excel 2007 So, you have data on a Web page and you need to move it into an MS Excel worksheet. What are you planning to do? Copy/paste each piece of data? Re-enter the data? Well, I vote you import the data directly from the Web and avoid all the … Continue reading Hassle Free Web Data in Excel 2007
The Long Formula
The Long Formula Do you work in MS Excel a lot? Ever have a really long formula that would expand the formula bar in the older versions of Excel? Did it become bothersome when it began to cover the cells in the first few rows? Well, if that's the case for you and you now … Continue reading The Long Formula
Special Data Formatting: The Easy Way
Special Data Formatting: The Easy Way Do you enter a lot of special data into MS Excel, such as zip codes, phone numbers or social security numbers? Ever find yourself wishing the parenthesis and/or dashes would just fill themselves into the correct locations? I mean, wouldn't it be faster if you could just key 5551234567 … Continue reading Special Data Formatting: The Easy Way
Page Layout View for Excel?
Page Layout View for Excel? Yep, you read that right! If you're using Excel 2007, you'll find that it also has a page layout view. Just like the view you've used in MS Word for years, you can now choose to view your worksheet in pages, complete with headers, page breaks, rulers and all. Take … Continue reading Page Layout View for Excel?