tabbing back start spreadsheet

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » 'Tabbing' back to start of spreadsheet

'Tabbing' back to start of spreadsheet

resolvedResolved · Low Priority · Version 2016

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

RE: 'Tabbing' back to start of spreadsheet

Thanks Wendy! I've now marked as complete. The Home key does effectively the same thing so I'm good to go now - cheers :-)


 

Excel tip:

Closing Multiple Workbooks quickly

When you have several workbooks open in Excel and want to just close them all at once:

1) Hold down the SHIFT key before selecting the File menu.

2) Once in File menu release SHIFT key and select Close All option.

3) All your files will close. If files require saving Excel will ask if you want to save the changes.

View all Excel hints and tips


Server loaded in 0.07 secs.