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.
LVL 1
agwalshAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ProfessorJimJamCommented:
not sure if i understood the question correctly. i assume you are referring to indent text in a cell by  inserting  eight spaces in the active cell.
if yes, then you can use  the Intend option in cell format.

see image below.

2015-07-01-14-27-00-Microsoft-Excel---Bo
also Microsoft support page about this.

https://support.microsoft.com/en-us/kb/156164#/en-us/kb/156164
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Danny ChildIT ManagerCommented:
If that doesn't work, it should be fairly easy to write a macro to insert 8 <space> characters from a hotkey.
0
Saurabh Singh TeotiaCommented:
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..
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Rory ArchibaldCommented:
@Saurabh,
It's Alt+Enter (Ctrl+Enter enters into all selected cells at once) and that's not the same as a tab.
0
Saurabh Singh TeotiaCommented:
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..
0
Saqib Husain, SyedEngineerCommented:
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.
0
gatesisantichristCommented:
This is a semi-advanced tip (very simple for advanced users, but sometimes valuable). I make long and confusing formulas readable by
- Hit F2 to edit the cell with a long somewhat unreadable formula
- Select the entire formula, Ctrl-C
- Paste to Word or notepad or any editor
- Insert line feeds and space padding as desired, such as in my example below
- Select all
- Ctrl-C
- Back in Excel, hit F2 (edit the destination cell)
- Remove existing contents (the long original formula)
- Ctrl-V and hit enter
Note that you must *edit* the cell, not just arrow or mouse over to it.
If you paste while not editing, the line feeds cause your formula to be spread over multiple cells.

Examine this example and all of the above should be clear:

=IF(CurrentAgentStateLevel<10,100,IF(CurrentAgentStateLevel<15,500,IF(CurrentAgentStateLevel<30,1000,5000)))
instead can now appear in my formula bar as

=IF(
   CurrentAgentStateLevel<10,
   100,
   IF(
      CurrentAgentStateLevel<15,
      500,
      IF(
         CurrentAgentStateLevel<30,
         1000,
         5000
         )
      )
   )
by following the steps atop.

Note: in XL2003 (and 2007 and 2010, if you're forced to use them) IF must have the open parentheses right after the F, no spaces, no line feeds - a wimpy parsing implementation but strictly enforced.

By the way, I picked a tame example; the original formula was not that gruesome. Unless you live in the land of daisies and lollipops, one day you'll encounter a truly gruesome formula that someone (or yourself) wrote. If so, consider this formatting as an alternative to breaking up the formula over multiple cells.

One more note: even with this formatting, the Excel formula bar is still limited. You can still always select all, and copy into a word processor, and take advantage of scrolling, wrapping or not, resizing window, etc. - even if you intend to make no modifications to the formula while there.
0
gatesisantichristCommented:
(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.)
0
agwalshAuthor Commented:
@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 :-)
0
agwalshAuthor Commented:
I got the answer - "this feature has been discontinued" with first post from ProfessorJimJam.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.