Friday, June 10th, 2011

Excel multi color column charts

When you have a great big Excel column chart with heaps of delicious data but all in one series, it makes sense for the chart to be plotted in wonderful technicolor. However that’s an option Excel 2010 doesn’t make it very easy to find. If you try the Chart Tools > Design tab you can choose a multi-color chart but that only colors each series a different color so it won’t work when all your data is in one series.

The solution is to click on one column to select it then right click and choose Format Data Series > Fill group. Locate and check the Vary Colors by Point option and you’ll have a wonderful multi-colored series – much more enlightening than a plain old single color chart don’t you think?

If the colors aren’t to your liking (you are getting just a little bit fussy but I do know exactly what you mean) select the Page Layout tab and check out the Themes – there’s sure to be one which will make your chart perfect.

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

Thursday, January 13th, 2011

Moving between columns in Word

jump move and switch between columns in Word
One of the most difficult things that people find with working with columns in Word is moving between the columns.

The reason is that the process itself is anything but easy.

The Tab key, which will move you between cells in columns in a table, doesn’t work inside newspaper style columns in Word so that key is out.

Instead, to move or jump from one column to the next you’ll press Alt + Page Down to go to the column on the right (the second column) or Alt + Page Up to move to the first column.

When you click Alt + Page Down, if you are in column 1 you’ll go to the very top of column 2. If you keep pressing the key you’ll flip between the top character in each column.

If you’re somewhere in column 2, when you press Alt + Page Up you’ll go to the top of column 1.

These are the only specialist keys for moving or switching between columns – we could use more – like jumping from a line in one column to the same line in the one next to it – but nada! Sorry!

Helen Bradley

Tuesday, January 11th, 2011

Typing in the second column in Word

Ok, so you’ve formatted your text to be two columns in Word and you’ve typed something in the first column. You haven’t filled the first column because you don’t want to. Fair enough – it’s your document – your choice.

But you do want to type something in the next or second column but however hard you try – Word won’t play nice. It wants you to fill column one before you get to fill column two – you don’t want to – so you’re at a stalemate.

The solution is to force Word to the top of the second column and you do this by inserting a break. In Word 2002/2003 choose Insert> Break > Column Break.

In Word 2007 & 2010 choose Page Layout tab> Breaks > Column.

Now you can type at the top of the second column. Yeah!

Helen Bradley

Sunday, January 9th, 2011

Picture between columns in Word

I get a lot of folks at projectwoman.com who come looking for help with columns and Word – anything from Word 2002 through 2003 to 2007 and now 2010. I have to think the reason is that Microsoft doesn’t make it as easy as it thinks to work with columns.

In the next few posts I’ll show you some things to do with columns that I think most folk have trouble with.

First up, how to put a picture in between columns in Word. Start by formatting your text in columns and then add your picture.

Chances are it won’t move and sit between columns. The issue is that Word inserts images as In Line With Text by default which is the setting MOST OF US WOULDN’T USE IN 1,000 YEARS – but Microsoft doesn’t really understand most users and so that’s what we get – images that are stuck – they won’t move where we want them to go and they won’t rotate.

To fix this, in Word 2002/2003 from the Picture toolbar find the Text Wrapping button, click it and choose practically anything except In Line With Text – I choose Square because it is the best all round setting.

In Word 2007/2010 click the Picture and from the Picture Tools > Format tab on the ribbon click the Text Wrapping button and choose Square.

Now your picture does what you expected it to do in the first place – it moves, it can be rotated and when you drag it over the space between two columns it sits where it is put and it pushes the text out of the way around it. Neat huh?

One day… maybe Microsoft will hear our cries of frustration and insert images so they behave like they should without us having to jump through hoops to make them.

Helen Bradley

Tuesday, October 30th, 2007

Making Columns in Word

There are lots of ways to create text in columns in Word but the easiest is to type the text (or at least some of it) and select it or position the cursor where the columns should begin. Then choose Format, Columns and select the number and spacing of columns.

From the Apply To dropdown list choose what to apply the columns to. If you have text selected, you’ll typically select Selected text. If you haven’t selected text you can apply them to the Whole Document or This Point Forward. Using This Point Forward lets you create a heading on the page with the text in columns under it.

Helen Bradley

Wednesday, June 27th, 2007

Word – Quick and easy columns…

One thing I do amongst all the things I do is to tech edit articles and books.

You learn a lot when you do this, on the one hand you learn how much you don’t know and on the other you learn how much you do know… it’s an eye opening experience both ways.

One thing that came out of a recent experience is how to do columns in Word. In this case, I liked my solution lots better than the one in front of me.

To turn a piece of text you have already created into a series of columns in Word, select the text and choose Format, Columns. Now choose how many and the width of your columns and instantly – columns to go!

I won’t disclose the solution I was editing… it simply wasn’t this simple.

Helen Bradley