ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Tab function within cells (https://www.excelbanter.com/excel-worksheet-functions/155860-tab-function-within-cells.html)

Mister Softie

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.



RagDyeR

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.





All times are GMT +1. The time now is 07:14 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com