![]() |
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? |
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? |
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