When you reference another cell on another tab, I could swear somewhere along the line I've seen a shortcut that allows you to jump to that cell on the other tab........![]()
When you reference another cell on another tab, I could swear somewhere along the line I've seen a shortcut that allows you to jump to that cell on the other tab........![]()
Do you mean Ctrl+[
Good luck.
Press F5 to open the GoTo dialog and type in the sheet reference.
Another option, right click the sheet navigation arrows at the bottom left above the status bar and choose a sheet from the list.
One more way (requires planning and a little more effort)
One each sheet, you can name a cell then use the Name Box drop down to navigate to the sheet/cell.
The Name Box is to the immediate left of the formula bar.
To Name a cell, simply select it, click into the Name Box and give it a name -- no spaces or illegal characters allowed.
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks