Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Pivot tables

Resolved · Low Priority · Version Vista

Reply Wed 17 Feb 2010, 15:37Delegate Jennifer said...

Jennifer has attended:
Excel Advanced course

Pivot tables

what is the procedure for creating a cutom list?

For upcoming training course dates see: Pricing & availability

Reply Thu 18 Feb 2010, 15:50Trainer Stephen said...

RE: Pivot tables

Hi Jennifer

Thanks for your question

Can you clarify your requirements for me please

Do you need to construct a custom list similar to days or months, where if you type in one item from the list and you drag and drop on that cell then other items from the list are automatically filled in.

Or do you wish to build some thing in a pivot table? If so could you detail your requiremnts please

Thanks

Stephen

Excel articles

· Special Characters in Excel
· The Pursuit of Excellence
· Should I Use Data Bars, Colour Scales Or Icon Sets In Excel?
· Simple Ways To Customise Excel
· Sorting Birthdates Into Their Respective Months In Excel

Please browse our web site to find out more about
microsoft excel 2003 vba courses and other Microsoft training courses.

Excel tip:

Convert a column into row quickly in Excel 2010

Occasionally you might enter data into Excel vertically and then when you finish realize that actually it would look more clearer if it was represented in a horizontal format. If you follow these simple steps below, you can quickly change the data from going vertically to horizontally and vice versa.

First, select the column you want to convert into a row or a row into a column. Then right click and select Copy. Go to the sheet where you want to past this row as a column and select “Paste Special”. Remember to check the check-box “Transpose” and select “OK”.

View all Excel hints and tips