advanced formatting
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 » Advanced formatting

Advanced formatting

resolvedResolved · Low Priority · Version 2003

replyReply Mon 28 Jul 2008, 16:30Delegate Niamh said...

Niamh has attended:
Excel Intermediate course

Advanced formatting

How to wrap text in th Format cells option

For upcoming training course dates see: Pricing & availability

replyReply Tue 29 Jul 2008, 10:40Trainer Pete said...

RE: Advanced formatting

Hi Naimh,

Thank you for your post, welcome to the forum;

Wrapping text within the width of a cell, follow these steps:
Select the column to be affected. (Click on the column header ie A,B,C or which ever column) Go to Format>Cells, select the Alignment Tab and check the box Wrap Text.

I hope that has answered your question, regards Pete

 

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

Excel tip:

Copying Formulae Quickly

There is a quicker way of copying a formula down a column.

Just point and double click on the black autofill handle in the right hand corner of a cell.

This will work providing you have some data in the column to the left of the column.

Sandy

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