Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 4th 06, 01:20 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 1
Default How do I make tab stops within a cell of Excel?

I am trying to make a address book with checklist and need to use several
tabs stops within a Cell, since there is not key to make tab stop as there is
on a typerwriter, How do I make a tab stop with a cell, or a template for
Excel?

  #2   Report Post  
Old August 4th 06, 02:01 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,909
Default How do I make tab stops within a cell of Excel?

ALT + ENTER will produce a new line in a cell.

This is one line ALT + ENTER
This is a new line ENTER

Might be what you need.


Gord Dibben MS Excel MVP

On Thu, 3 Aug 2006 17:20:01 -0700, B Daniels <B
wrote:

I am trying to make a address book with checklist and need to use several
tabs stops within a Cell, since there is not key to make tab stop as there is
on a typerwriter, How do I make a tab stop with a cell, or a template for
Excel?


  #3   Report Post  
Old August 4th 06, 05:38 PM posted to microsoft.public.excel.worksheet.functions
BD BD is offline
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 16
Default How do I make tab stops within a cell of Excel?

No I don't need a new line. I want to make consist stopping places. Such ass
Streets, Citys, States, Zip codes all lining up when it's printed. As I would
in a work program. Is it just not possible in Excel? I really don't want to
be counting up the number of letters in each address and then recounting to
make the rest of the spaces. That just doen'st seem to be efficent use of time
BD

"Gord Dibben" wrote:

ALT + ENTER will produce a new line in a cell.

This is one line ALT + ENTER
This is a new line ENTER

Might be what you need.


Gord Dibben MS Excel MVP

On Thu, 3 Aug 2006 17:20:01 -0700, B Daniels <B
wrote:

I am trying to make a address book with checklist and need to use several
tabs stops within a Cell, since there is not key to make tab stop as there is
on a typerwriter, How do I make a tab stop with a cell, or a template for
Excel?



  #4   Report Post  
Old August 4th 06, 07:09 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 30
Default How do I make tab stops within a cell of Excel?

B,

If you're trying to make a document that looks right, iether use Word or:

Consider the cells as guidelines for a form. Each address, zipcode, state,
and name goes in its own cell. You can right or left justify each entry to
line up with other entries. If you need to "box" anything, use
Format/Cells/Border. There are no "tabs" within individual cells, but you
can tab to the next cell. Please respond with progress you make.

HTH

Beege

"B Daniels" <B wrote in message
...
I am trying to make a address book with checklist and need to use several
tabs stops within a Cell, since there is not key to make tab stop as there
is
on a typerwriter, How do I make a tab stop with a cell, or a template for
Excel?





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I make my arrow buttons move from cell to cell in Excel? slickd1200 Excel Discussion (Misc queries) 1 April 17th 06 05:42 PM
Want to make conditional sounds based on cell values in Excel [email protected] New Users to Excel 1 January 25th 06 03:51 PM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
how do I make a cell in Excel required to be populated? Tia Excel Discussion (Misc queries) 1 February 10th 05 12:35 AM
How Can I make a cell flash in Excel monir Excel Discussion (Misc queries) 0 February 4th 05 03:41 AM


All times are GMT +1. The time now is 10:09 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017