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
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
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....
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
