It's general knowledge that in a word processor document, words can be spaced and aligned using the Tab key. However, in an Excel document, the use of the Tab key takes you into the next adjacent cell. Copying and pasting into the Excel document does not show the desired result. Is there a means, other than via the spacebar, whereby text can be aligned (or near enough) in an Excel document?
Word spacing in Excel
-
- 3StarLounger
- Posts: 357
- Joined: 02 Jun 2013, 05:55
- Location: Australia - SOUTH MORANG - A northern suburb of the city of MELBOURNE in the state of Victoria
Word spacing in Excel
You do not have the required permissions to view the files attached to this post.
George
When we're gaun up the hill o’ fortune, may we ne'er meet a frien' comin' doun!
(When we are going up the hill of fortune, may we never meet a friend coming down!)
Don't cry because it's over...Smile because it happened.l
At the end of the day it's midnight.
When we're gaun up the hill o’ fortune, may we ne'er meet a frien' comin' doun!
(When we are going up the hill of fortune, may we never meet a friend coming down!)
Don't cry because it's over...Smile because it happened.l
At the end of the day it's midnight.
-
- 3StarLounger
- Posts: 392
- Joined: 25 Jan 2010, 12:21
Re: Word spacing in Excel
Put the text into different cells. You can Data - Text to columns with tab as a delimiter to split them up.
If you want in the same cell, I think you will have to use spacebar and you will also format to a fixed width font (eg Courier New).
Steve
If you want in the same cell, I think you will have to use spacebar and you will also format to a fixed width font (eg Courier New).
Steve
-
- Administrator
- Posts: 78596
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Word spacing in Excel
The idea in Excel is that you do use the Tab key to place text in different columns if you want to align text.
There is no feature similar to that of Word to align text within a cell.
You'd have to select a fixed-width font such as Courier New and use spaces to align the text, but that is not an attractive solution - it doesn't look nice and it's tedious.
There is no feature similar to that of Word to align text within a cell.
You'd have to select a fixed-width font such as Courier New and use spaces to align the text, but that is not an attractive solution - it doesn't look nice and it's tedious.
Best wishes,
Hans
Hans
-
- 3StarLounger
- Posts: 357
- Joined: 02 Jun 2013, 05:55
- Location: Australia - SOUTH MORANG - A northern suburb of the city of MELBOURNE in the state of Victoria
Re: Word spacing in Excel
Thanks to both of you for your reply. The amount of text to be aligned is not that great. I just thought there might be some way of doing it other than using the spacebar but apparently not.
George
When we're gaun up the hill o’ fortune, may we ne'er meet a frien' comin' doun!
(When we are going up the hill of fortune, may we never meet a friend coming down!)
Don't cry because it's over...Smile because it happened.l
At the end of the day it's midnight.
When we're gaun up the hill o’ fortune, may we ne'er meet a frien' comin' doun!
(When we are going up the hill of fortune, may we never meet a friend coming down!)
Don't cry because it's over...Smile because it happened.l
At the end of the day it's midnight.