diversification
New Member
- Joined
- Jun 24, 2020
- Messages
- 37
- Office Version
- 365
- Platform
- Windows
Hi there, I have a spreadsheet I've designed that has one table that's only 1 row x 1 column (ie. the data is only 1 cell.) This cell will be overwritten by the user of the spreadsheet. When it's overwritten, and the user hits the 'tab' button to exit from the cell, the table auto-creates another row, which causes the other functions in the spreadsheet to spill. The auto-addition can be reversed with a quick Ctrl + Z, but the users of this spreadsheet are pretty far from tech savvy, so I'd rather just limit the spreadsheet from auto-creating that next row. Is there a simple way to accomplish this, so that when I share it with other users, it will discontinue that behavior?
Notably, this appears to be the default behavior when the 'tab' key is used to exit the cell in the bottom-right corner of *any* structured table. Hopefully this can be turned off or limited for a sheet.
Notably, this appears to be the default behavior when the 'tab' key is used to exit the cell in the bottom-right corner of *any* structured table. Hopefully this can be turned off or limited for a sheet.