For the love of God, please someone tell me how to select columns in Excel 2007

[EyeballsintheSky]

I've got a table. I want to select some cells and format the text but it will only select the whole table and it's driving me insane. I want to click on a cell and drag it to select the area that I want but it won't do it. Please someone tell me how to change this setting before I hire a hitman to get Bill Gates once and for all

Do you mean a pivot table?

Suggest you post your question on www.mrexcel.com - v helpful forum.

do you hvae merged cells?
If you want me to have a look you can email me the file and what you want to do on Kate Fallon 44 @ hotmail . com

If it's the same as my old version of Excel you click on the cell and highlight it, or right click and drag the highlight down the column??? and then go to the top menu: format and click "cells" - and then you can do all your formatting stuff.

That's if they haven't changed it all for Excel 2007....

From the help file - is this any help?

To apply formatting, copy data, or make changes to a PivotTable report, you can select either individual cells or data regions by using commands or by using a mouse. The mouse pointer changes depending on what you are trying to select:

To select cells, use the regular Microsoft Office Excel mouse pointer .
To select data regions, position the mouse pointer at the top or left sides of fields and labels so that the mouse pointer changes to a down arrow or a right arrow .

Note If you don't see the pointer change shape, on the Options tab, in the Actions group, click Select, and then make sure that Enable Selection is selected.