excel vba - Indent's

The UK's most regular instructor-led training courses.
Training information: excel vba · Excel/courses/london · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Indent's

Helen has attended:
Excel Intermediate course
Excel Advanced course

by - delegate Helen [1 post] (2007 Aug 16 Thu, 13:49) Reply

Can you indent text within a cell?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue	Bloomsbury	0	FULL
2003	2008 Nov 27 Thu	Southwark	3	book now	£210	£215
2007	2008 Nov 28 Fri	Bloomsbury	0	FULL
2003	2008 Dec 2 Tue	Bloomsbury	4	book now	£207	£215
2003	2008 Dec 4 Thu	Bayswater	6	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	5	book now	£212	£224
Full Schedule: See all 113 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Indent's

by - trainer Tracy platinum contributer [586 posts] (2007 Aug 16 Thu, 14:56) Reply

Hi Helen,

Yes you can there are buttons on your formatting tollbar which indent the text within the cell. The buttons are after the decimal places and before the borders!

Have a go and see what it does, clearly it is not as powerful as word in terms of word processing abilities.

Tracy

· Microsoft Excel Training - Discover A Hidden Power At Your Fingertips
· Microsoft Excel Features and Functions for Accountants
· How to check for and reduce errors in Microsoft Excel
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· Why Should I Learn Visual Basic in Excel?

Excel tip:

Make a quick copy of a worksheet

Hold down the Ctrl key, then click and drag on a sheet tab to make a copy of that sheet. Though this process usefully copies the formats of the original sheet, note that any Range Names you have on the original sheet will be duplicated too.

To make a copy of a worksheet's contents and formats without duplicating range names: (1) Ensure that you have a blank worksheet to paste to. (2) On the sheet to copy, click on the sheet selection square to the left of Column A's heading to select the whole sheet. (2) Copy the whole sheet. (3) Paste to the blank worksheet.

View all Excel hints and tips