So, if you investigated the tip we ran the other day on Word 2007’s Quick Tables then you may have been left with a bit of disappointment if you didn’t see a built-in table that would suit your needs.
In that case you may have thought “Good idea, too bad it doesn’t help me.”
Before you dismiss [...]
Have you ever tried to copy and paste cells from MS Excel to MS Word?
What happened?
I bet you went to Excel, highlighted the cells, copied the cells, went to Word, pasted the cells and poof, there they were!
Sounds great, doesn’t it?
Yes, and it can be, but if you’re using Word and Excel 97, there are [...]
Do you use MS Excel charts?
If so, do you find it difficult to select just the “right” portion of your chart? Or, maybe you have the opposite problem. You can select portions easily, but you can’t seem to select the whole thing. Are you tired of all those mis-clicks?
Whatever your selection problems may be, you [...]
Have you ever had the same information to enter in multiple cells in MS Excel?
What did you do?
Did you type the data into one cell and then copy and paste it everywhere else in the worksheet?
That was a bit of a pain, wasn’t it?
How would you like a way to get the data into all [...]
Have a table in MS Excel 2007? Do you need to calculate information, such as an average or sum for each column in the table?
If so, what did you do?
Did you set up the row by hand and then create the needed [...]
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 [...]
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 what you want?
Is there a way to undo Excel’s automatic column [...]
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 get the formatting without actually creating the [...]
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 2007!
When I have a range of cells with [...]
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 [...]
