ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Indent within a row (https://www.excelbanter.com/excel-worksheet-functions/25011-indent-within-row.html)

marilyn

Indent within a row
 
How do I indent using the tab key within a row rather than using the spacebar
to move the cursor over?


Hi
Try Format|Cells|Alignment tab and select Left indent from Horizontal
Alignment. You can set how much indent using the buttons alongside.

--
Andy.


"marilyn" wrote in message
...
How do I indent using the tab key within a row rather than using the
spacebar
to move the cursor over?




marilyn

How do I move the cursor down to the next line I want to start typing within
a row other than to use the spacebar

"Andy B" wrote:

Hi
Try Format|Cells|Alignment tab and select Left indent from Horizontal
Alignment. You can set how much indent using the buttons alongside.

--
Andy.


"marilyn" wrote in message
...
How do I indent using the tab key within a row rather than using the
spacebar
to move the cursor over?





David McRitchie

Hi Marilyn,
Please don't change the subject line, the proper thing to do is to
start a new question and not by using a reply.

Watch your terminology. Excel has rows and columns, I think you
mean how to start a new line within a cell.
use the Alt+Enter
and if you want to do the equivalent in a formula you would use CHAR(10)
in a concatenation ="line one" & CHAR(10) & "line two"
and in VBA if you start writing macros you would use CHR instead of CHAR.

When people use Google web search or Google Groups search they
look at the subject line when they get hits on words to try to determine
which of many items might be relevant to what they searched for.
http://www.mvps.org/dmcritchie/excel/xlnews.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"marilyn" wrote in message ...
How do I move the cursor down to the next line I want to start typing within
a row other than to use the spacebar

"Andy B" wrote:

Hi
Try Format|Cells|Alignment tab and select Left indent from Horizontal
Alignment. You can set how much indent using the buttons alongside.

--
Andy.


"marilyn" wrote in message
...
How do I indent using the tab key within a row rather than using the
spacebar
to move the cursor over?








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

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