You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

How do I stop columns from creating when tabbing thru a spreadsheet?

I recently updated my computer and my old EXCEL files are now opening up in Numbers (which is fine).


I have this old template that was created specifically for me and is what needs to be used daily. Now every time I tab to enter information into the columns instead of it jumping to the next empty cell on the next line down it will create additional columns which are not needed.


How do I stop columns from creating when using the tab field? Is this a simple fix I am not just seeing?

Any suggestions or help is greatly appreciated.

Thanks.

Posted on Jan 28, 2021 8:32 AM

Reply
Question marked as Top-ranking reply

Posted on Jan 28, 2021 8:13 PM

Yes, in Numbers 10.3.9 (and I think long before) a new column is created when you are in the rightmost column of a table and press <tab> .


If you don't want that, I suggest training yourself to use the arrow keys. Or when you are in the rightmost column press <return>.


Unlike in Excel there is no preference setting to control the selection behavior after you press <return> (move down, right, up, left).


SG

2 replies
Question marked as Top-ranking reply

Jan 28, 2021 8:13 PM in response to bubbastumper

Yes, in Numbers 10.3.9 (and I think long before) a new column is created when you are in the rightmost column of a table and press <tab> .


If you don't want that, I suggest training yourself to use the arrow keys. Or when you are in the rightmost column press <return>.


Unlike in Excel there is no preference setting to control the selection behavior after you press <return> (move down, right, up, left).


SG

Jan 28, 2021 11:44 AM in response to bubbastumper

"Now every time I tab to enter information into the columns instead of it jumping to the next empty cell on the next line down… "


Pressing tab should not produce this result.


Press tab to confirm the entry and move to the next cell to the right.

Press enter to confirm the entry and move to the next row.*


Note that the focus goes to the 'next' cell, not the 'next empty cell'.

Return, after an unbroken series of tabs moves focus to the cell in the next row that is directly below the cell in which the first entry was made.


If you have been entering values along a row, the expected process is:


Click on A2, enter value A2, press tab, enter value B2, press tab, enter value C2, press return, enter value A3…



Tab adding a column should happen only after a second press of tab in a cell in the rightmost column of the table.


…enter D2 value, press tab to confirm entry, press tab a second time to create column E and move to E2.



Does the behaviour you are describing occur on only this table, on all tables in this document, on tables in several (but not all) documents.


If the last, do the documents in which it does occur have anything in common (such as having been created by importing a .xls file or by importing a .xlsx file or by importing a file from an earlier version of Numbers)?


Regards,

Barry

How do I stop columns from creating when tabbing thru a spreadsheet?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.