microsoft.excel.training - indent
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 » microsoft.excel.training - Indent

microsoft.excel.training - Indent

resolvedResolved · Low Priority · Version Standard

replyReply Thu 4 Oct 2007, 15:57Delegate Chidinma said...

Chidinma has attended:
Excel Intermediate course
Excel Advanced course

Indent

Can you indent text within a cell?

For upcoming training course dates see: Pricing & availability

replyReply Fri 5 Oct 2007, 10:42Trainer Amanda said...

RE: Indent

Hi Chidinma

Thank you for your question.

You can apply an indent to text in a cell by going to Format Cells then go to Alignment, then you will find an Indent box that you can use to create an indent.

Amanda

 

Excel tip:

Stop Formula Returning A "#DIV/0" Error

If a formula returns a #DIV/0 error message there is a way to avoid such results.

For example the formula =A1/B1 will return a #DIV/0 if B1 is empty or a zero.

If you protect your formulas with the ISERROR function, the formula will then look like this:

=IF(ISERROR(A1/B1),0,A1/B1)

In plain English: should the result of A1 divided by B1 be an error change the result to 0 else show the result of A1/B1.

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