Exceljet

Quick, clean, and to the point

Move to next pane

Windows shortcut

Mac shortcut

FnF6

Move to the next pane in a worksheet that has been split. On Windows, F6 and Shift-F6 will also move between the worksheet, the status bar, and the ribbon.

222 Excel Shortcuts for Windows and Mac

I have used vlookup a lot and read some about index and match, but decided to add extra columns and stay with vlookup, however, your site was so very clear that making the switch (only where necessary) was very easy. For the first time, I understand index and match match. Thank you. -Garth

Move to next pane

Download 200+ Excel Shortcuts

Excel video training