microsoft excel training class

microsoft excel training class - Ident

Resolved · Low Priority · Version Standard

Ident

Bing has attended:
Excel Intermediate course

by - delegate Bing [2 posts] (2007 Oct 4 Thu, 15:57) Reply

can you indent text within a cell?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	3	book now	£475	£495
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	4	book now	£499	£530
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	8	book now	£345	£425
2003	2009 Jan 22 Thu + 23 Fri	Southwark	5	book now	£450	£485
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	6	book now	£450	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	7	book now	£450	£475
Full Schedule: See all 34 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: ident

by - trainer Amanda diamond contributer [1240 posts] (2007 Oct 5 Fri, 11:13) Reply

Hi Bing

Thank you for your question.

The answer is yes, you can apply an indent to text in a cell. Go to Format Cells then go to Alignment, then you will find an Indent box that you can use to create an indent.

Amanda

· Training Budgets In A Bad Economy
· Do You Really Need Excel VBA Training?
· Microsoft Excel Courses Teach Advanced Macro Techniques
· Reporting and Analysis with Excel
· An Introduction to Microsoft Excel: Top Features for the Excel Novice

Excel tip:

Checking if a calculation adheres to Order of Precedence

When writing formulas you must make sure that results will be calculated as you intended.

Excel adheres to the standard order of precedence for calculations. It calculates percentages, exponents, multiplication, and division in this order before calculating addition and subtraction.

For example, =7+5*3 results in an answer of 22, not 36.

To force a calculation to be completed before another calculations, place the section in parentheses: =(7+5)*3 will result in 36.

To check how excel is evaluating a formula, click on the cell and select the 'Tools' menu, select 'Formula Auditing' and click 'Evaluate Formula'

In the dialog box click on 'Evaluate' to watch as each part of the formula is successively calculated.

View all Excel hints and tips

Rate this page: