Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default Tab function within cells

Is there a way to put in a tab within a cell? I could manually
insert 5 spaces but it's cumbersome. I know I could insert another
column but my columns are rather wide and the formatting is done with
left justification. Thanks.


  #2   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,572
Default Tab function within cells

Select the cells in question, then:
<Format <Cells <Alignment tab,
Expand the "Horizontal" window, and click on "Left Indent",
This activates the normally dormant "Indent" box to the right of that
window.

Just play with different values in that box to get what you're looking for.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Mister Softie " wrote in message
...
Is there a way to put in a tab within a cell? I could manually
insert 5 spaces but it's cumbersome. I know I could insert another
column but my columns are rather wide and the formatting is done with
left justification. Thanks.



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
Using IF function for many many cells, and using more than one IF function Aikisteve Excel Worksheet Functions 0 July 6th 06 01:18 PM
How to add two cells when one uses IF function? Nat Excel Discussion (Misc queries) 2 April 19th 06 08:52 PM
Add certain cells based on a function MrSandman Excel Worksheet Functions 1 March 10th 06 12:53 AM
multi function cells kellerfro Excel Discussion (Misc queries) 4 June 27th 05 07:34 PM
Using SUM function with #N/A in some cells Jeeper Excel Worksheet Functions 5 June 10th 05 06:28 AM


All times are GMT +1. The time now is 02:40 AM.

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

About Us

"It's about Microsoft Excel"