agwalsh
asked on
Using Ctrl and Tab in an Excel cell - was available in Excel 5.0?
hi Folks
Just wondering if there is a way to do a tab movement in an Excel cell..
So that I could enter the following..I have a user who said she could do it in Excel 5.0 using Ctrl and Tab
County 1
Wonder if there is an alternative way to do it in later versions of Excel (specifically 2010)
Thanks.
Just wondering if there is a way to do a tab movement in an Excel cell..
So that I could enter the following..I have a user who said she could do it in Excel 5.0 using Ctrl and Tab
County 1
Wonder if there is an alternative way to do it in later versions of Excel (specifically 2010)
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If that doesn't work, it should be fairly easy to write a macro to insert 8 <space> characters from a hotkey.
Yes in Excel if you want to do tab enter which basically write in Multiple lines.. Then you can try doing the same by pressing ctrl+enter
Lets say in A1 if i write ABC and then when press ctrl+enter the next text which i will write will come in the next line and so on..
Lets say in A1 if i write ABC and then when press ctrl+enter the next text which i will write will come in the next line and so on..
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Ahh Rory my bad..I'm starting my day and you are write its Alt+Enter..Again i'm assuming tab is the space he is giving and want to come to next line..
Although you can enter the tab character using some formula or cut-paste, but the tab effect will not show up in the excel cell.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
(My technique is essentially an extension of alt-enter as described earlier. Alt-enter is fine to use to achieve the same result, as long as you're okay working withing the formula bar or the cell editing area.)
ASKER
@Professor JimJam - no, it's not indent. I had already said that to her. Indent moves all the text from the left. But she wanted the equivalent of a tab movement within in Excel cell. (Tabs = spawn of Satan to be honest in my opinion but to each their own) :-). You have given me the answer with the Microsoft link - it's discontinued.
Alt and Enter is NOT what she is looking for. Thanks for all the other comments but writing a macro and a piece of code - that's probably overkill really :-)
Alt and Enter is NOT what she is looking for. Thanks for all the other comments but writing a macro and a piece of code - that's probably overkill really :-)
ASKER
I got the answer - "this feature has been discontinued" with first post from ProfessorJimJam.