98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » 'Tabbing' back to start of spreadsheet
'Tabbing' back to start of spreadsheet
Resolved · Low Priority · Version 2016
Mon 22 Oct 2018, 15:49Delegate Cormac said...
Cormac has attended:
Excel Intermediate course
'Tabbing' back to start of spreadsheet
Hello there (Sarah?!). I'm inputtin data on a large spreadsheet (set up by someone else) and on the earlier rows, when I got to the end of the end of a row I would press the 'tab' button and this would immediately bring me back to the beginning of the next row. At about line 250 or so, it stopped working so I now need to get back there by using the Excel cheats (Shift, arrow key etc). This is OK but more time consuming than just pressing Tab at the end of the row. And add all these small delays together and it starts to add up! Any ideas?
Thanks so much
Cormac
Mon 22 Oct 2018, 19:43Trainer Wendy said...
RE: 'Tabbing' back to start of spreadsheet
Hi Cormac
Thank you for using our forum
Does it do this if you use Enter instead of Tab?
Kind regards
Wendy Canelas
Microsoft Office Trainer
Wed 24 Oct 2018, 08:09Delegate Cormac said...
RE: 'Tabbing' back to start of spreadsheet
Hello Wendy
Thanks for replying.
No - if I press enter on the last cell, it drops one row and makes the cell below it the 'active' cell....
Wed 24 Oct 2018, 09:12Trainer Wendy said...
RE: 'Tabbing' back to start of spreadsheet
Hi Cormac
It could be a few things. You might have used an arrow key to move to another cell or clicked on another cell and Excel 'forgot' to return to column A.
If you press Ctrl + End, does it return to the last cell used or does it go to a blank cell somewhere?
A faster shortcut instead of using the ctrl and arrow keys is to use Home. This will always take you to the beginning of your row.
Kind regards
Wendy Canelas
Microsoft Office Trainer
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Closing Multiple Workbooks quicklyWhen you have several workbooks open in Excel and want to just close them all at once: |
