excel introduction training cour
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel Introduction Training Course

Excel Introduction Training Course

resolvedResolved · Medium Priority · Version 2007

replyReply Mon 26 Sep 2011, 15:40Delegate Trish said...

Trish has attended:
Excel Introduction course
Excel Intermediate course

Excel Introduction Training Course

Please tell me the quickest way to highlight several columns and then, at the flick of a switch, make the widths equal?

For upcoming training course dates see: Pricing & availability

replyReply Tue 27 Sep 2011, 00:38Trainer Mark said...

RE: Excel Introduction Training Course

Hello Trish,

Quickest way to widen multiple columns. Click the top of the first column required (this means clicking the actual letter, eg. D Column), Hold down the Shift key, Click on the last column required eg. J column. This selects all those columns.

Then move your mouse between any two of the selected columns (not on the sheet but again in the very top where the Letters of the columns reside), eg, between F and G, your cursor changes to a double headed arrow, click and drag to required width, when you let go all the selected columns will snap to same width.
It takes longer to explain than it does to perform!

I hope this resolves your question. If it has, please mark this question as resolved.

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

Mon 3 Oct 2011: Automatically marked as resolved.

 

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

Excel tip:

Sorting List Subtotals

If you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows.
IMPORTANT: If you do not hide the details rows before sorting a subtotalled list, your subtotals will be removed and all of the rows in your list will be reordered.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard