learn excel in london - Pivot table

The UK's most regular instructor-led training courses.
Training information: learn excel in london · Excel training london · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Pivot table

Chris has attended:
Excel Advanced course

by - delegate Chris [1 post] (2007 Mar 16 Fri, 09:44) Reply

Is there a quick way to adjust text fields, e.g. names of people who are displayed with spaces added. Having the spaces added does not allow the pivot table to run correctly.

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 27 Thu	Bloomsbury	3	book now	£240	£245
2003	2008 Nov 28 Fri	Southwark	1	book now	£235	£240
2003	2008 Dec 3 Wed	Bloomsbury	0	FULL
2003	2008 Dec 5 Fri	Bayswater	5	book now	£195	£205
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
Full Schedule: See all 98 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: pivot table

by - trainer Garry gold contributer [188 posts] (2007 Mar 29 Thu, 11:26) Reply

Select the emplty field just above the row number 1 and before the column heading letter A and this selects all the rows and headings and adjust the fields

· Excel Macros for the Non-Programmer
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· 3 Reasons why Your Small Business Office Needs Microsoft Excel Training
· Compare Different MS Excel Training Methods
· Training Budgets In A Bad Economy

Excel tip:

Changing Excel file and worksheet defaults

The appearance of any new Excel files or any new worksheets that are inserted into a file are controlled by two template files, Book.xlt and Sheet.xlt.

By opening, modifying and saving these templates you can change the default settings for all new files and/or all newly inserted sheets.

Use Book.xlt to make change to defaults for new workbooks; and Sheet.xlt to change defaults for sheets.

If you can't find either of these files on your computer, you can create and save them yourself.

You can do this simply by creating a new workbook with the setting you want to use as your defaults; then saving them with the appropriate name in the XLStart folder. If you are using Office 2003, this is usually found in C:\Program Files\Microsoft Office\Office11\XLStart.

View all Excel hints and tips