Wednesday, July 3rd, 2013

Word 2010 and 2013 Tip – Wrap Text Around a Table

Use a text box in Word to control text wrap around a table

In a previous tip I showed you how to place a table inside a text box so you could put two tables side by side. You can use the same process to make the text on your page wrap around a table.

Click here to learn how to place a table inside a text box

To control the way text wraps around a table, first create a text box and place a table inside it.

Then click to select the text box and, from the Ribbon, select the Format tab > Text Box Tools. Click the Wrap Text dropdown menu and choose the desired wrapping option from those in the list – typically you will use Square to wrap text round the text box with its inserted table.

Helen Bradley

Friday, July 20th, 2012

5 Cool Excel 2010 tips and tricks

Here are five cool tips, tricks and keystrokes to help your day go faster in Excel:

Display cell formulas and not results

If you want to see the cell in your worksheet display formulas rather than the results of those formulas then  you can do it one of two ways.

Use the keyboard shortcut Ctrl + ~ to toggle formula display on and off

You can also use Formulas > Show Formulas

Start a new line

When you need to add a line break to a cell to start a new line of text press Alt + Enter in the cell. If you just want to wrap a long piece of text in a cell right click the cell and choose Format > Alignment tab > Wrap Text.

Copy the contents of the cell above

To copy the contents of the cell above into the current cell press Control + ‘.

Moving around super fast and super smart

To move from one sheet in a workbook to the next (or in reverse), press Control + PgDn and Control + PgUp.  To move to the next open workbook press Control + Tab or Control + Shift + Tab.

Super quick mouse free SUM formula

Skip taking the mouse to your Ribbon to add a SUM function and do it with a simple keystroke instead. Type Alt + = and Excel adds the SUM function automatically to the current cell. Doesn’t get much easier than that!

Helen Bradley

Thursday, January 20th, 2011

Word – place a table over newspaper columns

Place a table over two columns in Word

Sometimes you’ll need to include a table in a document but place it so that it’s placed over a series of columns rather than inside the column itself.

To do this, click where you want the table to appear and insert the table at this point.

Hold your mouse over the table and you’ll see the table selector above the top left corner of the table. Click it to select the table and drag the table into position.

The default text wrap settings for a table in Word is that the text wraps around the table so there’s no special option to set to make this happen.

You can widen the table cells as large as necessary. If desired, the table can be sized so it fits the full width of the page or you can make it any size that you want.

To adjust the wrapping of text around a table, right click the table selector (the little square above its top left edge) and choose Table Properties > Table tab. Here you can select how text flows around the table or you can make it not flow around it if you want the table to push the text completely out of its way.

Here too you can alter the alignment of the table – by choosing Left, Center or Right.

This table behavior is consistent across Word 2007, 2010, 2003 and earlier versions.

Helen Bradley

Wednesday, January 16th, 2008

Multiple Paragraphs of text in an Excel cell

Multiple paragraphs of text in an Excel cell sound good, they look good but how the heck do you create them? If you press the Enter key you enter the current text into the cell and move away from it – obviously, pressing the Enter key isn’t the answer.

The solution is to press Alt + Enter to create a new line of text in the current cell. Do this as often as you need to. You might have to make the row taller to fit the text if Excel doesn’t make the adjustment for you.

Helen Bradley