Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel pivot tables

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel pivot tables

Excel pivot tables

ResolvedVersion 2007

Phil has attended:
Presentation Skills course
Excel Intermediate course

Excel pivot tables

Hi Mark

I have a question about pivot tables. I have 2 files that use them and they don't seem to work as I think they should. In one case the months don't come in number order and in the other the pivot table goes horizontally and I would prefer it to be vertical. Can I send you the files to have a look please?

Thanks
Phil

RE: Excel pivot tables

Hello Phil,

Send the files over and we'll have a look.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer

RE: Excel pivot tables

Hi Mark

Can you give me an email address so I can send the files?

Phil

RE: Excel pivot tables

Hello Phil,

It would be a start if you could send a sample of what you have so we can look and decide if we can solve the layout issue you are having.

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer

RE: Excel pivot tables

Mark

I still do not have an email address that I can send the file to. I cannot describe it in words, you need to see the file.

Phil
PS I was away on holiday for a week.

RE: Excel pivot tables

Hello Phil,

Please send your example file to info@stl-training.co.uk for Mark's attention and we will get it to him.

Regards,

Richard

Mon 26 Sep 2011: Automatically marked as resolved.

Excel tip:

Select only cell that contain text to lock format

For selecting cells that only contain Text in Excel

By selecting cells that only contain text, you can delete, fill or protect cells of this type.

Use short cut to Go to box (F5) or Edit, Go to
In the dialog box, click special button & select Constants and only check text or any other desired type.

Click OK.

And text cells will all be highlighted for you to apply format. Please note only works on one sheet at a time.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.