Excel - tab stops within a cell

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

Resolved · Urgent Priority · Version 2003

12 posts

ReplyThu 7 Jan 2010, 15:28Delegate Amy said...

Amy has attended:
No courses

Excel - tab stops within a cell

Hi

Please can you let me know whether it is possible to enter tab stops within a cell (Excel spreadsheet).
When pressing the tab key you move between cells rather than within the original cell.

Many thanks

Version	Date	Location	Places available	Book	Next place rate (£)
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2007	Mon 22 Mar 2010	Limehouse	3		£224	£225
2003	Tue 23 Mar 2010	Southwark	4		£207	£212
2007	Thu 25 Mar 2010	Rochester (Hoo)	0	FULL
2003	Fri 26 Mar 2010	Limehouse	4		£224	£225
2007	Tue 30 Mar 2010	Southwark	5		£199	£204
2003	Thu 1 Apr 2010	Bloomsbury	4		£207	£212
Full Schedule: See all 77 Excel Intermediate course dates. Bookings currently available until 23rd December 2010.

1,056 posts

ReplyFri 8 Jan 2010, 10:23Trainer Andrew said...

RE: Excel - tab stops within a cell

Hi Amy

Thank you for your question.

Unfortunately I'm not aware of a way to add tabs to space out or position text within a cell.

Word on the other hand can set tabs within a cell of a table so this may be better suited to your needs.

Let me know what kind of outcome you are looking to achieve with Tabs in Cells in case I can find another way of achieving it.

Kind regards,

Andrew

· Excel: Survival Of The Fittest
· Special Characters in Excel
· Microsoft Excel Training: Essential for Today's Employees
· Streamlining Excel To Save Time
· You're Hired! Raising Your Chances Of Employment With Excel

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

Excel tip:

Hide data in Excel Worksheets

Let's say you have some data in cell 'C5' you would like to hide from the casual viewer.

Click cell 'C5' to select it.

Click the 'Format' menu, select 'Cells'. When the 'Format Cells' dialogue box opens, click the 'Numbers' tab (if necessary), then select 'Custom' from the 'Category' list.

Double-click the 'Type' entry box and type three semi-colons: ";;;"

Click 'OK' to close the dialogue box and accept the new formatting.

The data in cell 'C5' disappears. It's still there and will work in calculations, but it isn't visible.

If you need to check the data, just click the blank cell and the contents appear in the 'Formula bar'.

View all Excel hints and tips