'Tabbing' back to start of spreadsheet

Resolved · Low Priority · Version 2016

Mon 22 Oct 2018, 15:49 Delegate 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:43 Trainer 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:09 Delegate 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:12 Trainer 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

Wed 24 Oct 2018, 09:50 Delegate Cormac said...

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 :-)

Training courses

	98.7 % recommend us
	More live stats...

Training information:

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