Tag Archives: tables

Formulas in Word 2007

Hi Friends!

Today’s tip came out of another friend of mine asking me about something they didn’t know how to do. Actually, she knew how to do it in Word 2003. So did I. But I didn’t know how to do it right there on the spot, so I did some homework. Now YOU will benefit from the question being asked.

The question: “How do I add numbers in Word?” – not the exact words. It’s pretty easy.

1.    Just create a table, enter the values, then click on the destination cell for your formula.

2.   Click on the “Layout” tab that shows up above the Ribbon when your cursor is within the table.

3.   Click on “Formulas” at the far right end of the Ribbon.

4.   “Sum” is the default formula (you CAN select another formula in the drop-down called “Paste function”). Since we’re talking about adding figures, just click “Ok.” And there you have your total!

It’s that simple. Now for a little note to the contrary: This scenario is the simplistic, perfect-world scenario. You have the ability to create your own formula using cell locators (B1:B3 means cells in column B, rows 1 – 3), or functions +, -, *, and  /. You can also do compound formulas like (sum(above))*2) meaning add all the values above and multiply by 2. But now you’re probably getting glassy-eyed and getting distracted. Am I right?

Thanks for stopping by!

Advertisements

Leave a comment

Filed under MS Word

Word: Converting Tables

Hello Friends!

Today’s tip is about converting tables to text. Sometimes when you copy templates, especially in the case of resumés, they will have tables embedded in them. Here is how to convert them to just text.

To start, click anywhere in the table area. You will see a square (Arrow 1, below) with a cross with arrows on all 4 points inside it. Click on that little square to select the table. Then mouse over and click the Layout tab (Arrow 2) . Next, you will click on “Convert to Text” (Arrow 3).

When you click the “Convert to Text” button, Word will give you some options on how you want your text separated. I selected tabs. Click “Ok.”

Here’s a heads-up for you though. Your text won’t line up perfectly, so you’ll have to reset them. I’ll have a post on that too, soon.

Thanks for stopping by! Comment to let me know what tips you’d like to see. Subscribe to be notified when I post a new tip.

Leave a comment

Filed under MS Word