Pivot tables and drop down options

Resolved · Low Priority · Version 365

Thu 3 Feb 2022, 12:40 Delegate Sharon said...

Sharon has attended:
Excel Intermediate course

Pivot tables and drop down options

My query relates to the above subject. It's just a reminder how to create these two options if possible please? Many thanks.

Thu 3 Feb 2022, 14:37 Trainer Jens said...

RE: Pivot tables and drop down options

Hi Sharon,

Thank you for the forum question.

Pivot Tables are very useful to analyse data and to create reports.

I found a very good video on YouTube, which go through the basics.

https://www.youtube.com/watch?v=m0wI61ahfLc& ;t=45s

I believe that you talk about data validation when you ask for drop down options.

Please watch the video below:

https://www.youtube.com/watch?v=QR04owFaJy4

We have Pivot Tables and create drop down option on our Excel Advanced course

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Thu 10 Feb 2022: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Multiple Lines of Text in a Cell

As an alternative to the Text Wrapping facility, type a word or two, press Alt+Enter to get a new line, type more text, and continue the process for as many lines as you need. Enter as normal when you have finished.

The line break is not affected by changing the column width, as text wrapping. To remove this you must edit the cell and remove the invisible character and replace with a normal space.

View all Excel hints and tips