microsoft.excel.training

microsoft.excel.training - Indent

Resolved · Low Priority · Version Standard

Indent

Chidinma has attended:
Excel Intermediate course
Excel Advanced course

by - delegate Chidinma [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: Indent

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

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 and Inventory Management
· Features of Microsoft Excel that assist in Analysis of Financial Data
· Tap the Power of Recorded Macros with MS Excel Courses
· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers
· Microsoft Excel Training: Not Just for Newbies Anymore

Excel tip:

Fill formulae across a sheet

To copy a formula down a spreadsheet where there is data underneath, to the left or to the right of the formula, double-click on the fill handle. The fill handle is the little black cross that appears in the bottom right-hand corner of the formula cell. Unfortunately, no similar facility exists to copy formulae across the sheet.

One reasonably quick way to copy an existing formula across a sheet is to select the formula and the cells on the right to which you want to copy it. Then press Ctrl+R to copy the formula across the selected range, or, if you are menu-minded, use the Edit|Fill|Right command.

View all Excel hints and tips

Rate this page: