short cut to tracing dependent on other worksheet when there are mutliple dependents (some on local sheet)

G

GGG411

New Member
Joined
Feb 24, 2021
Messages
2
Office Version
  1. 365
Platform
  1. Windows
Hi. I'm looking for a shortcut to jumping to dependent cells on other worksheets when there are multiple dependents, with some on the local sheet.
Pressing Ctr + [ will only take me to the first local dependent...I'd like to use my keyboard to toggle and choose the offsheet dependent.
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
You must log in or register to reply here.

Similar threads

C
  • Question
Dependent Drop Down Help, Excel 2010
Replies
5
Views
139
Akuini
Akuini
D
  • Question
Completely cleaning account numbers and storing with a specific format
Replies
2
Views
609
diversification
D
K
  • Question
How to Connect Employees' Individual Excel Workbooks to a Main Workbook for Automatic Data Updates?
Replies
4
Views
613
OaklandJim
O
A
  • Solved
Calendar form cancel button passing data to worksheet
Replies
7
Views
396
AndyEd
A
O
  • Question
Trace Dependencies Keyboard Short Cut
Replies
3
Views
459
mrshl9898
M

Forum statistics

Threads
1,214,918
Messages
6,122,252
Members
449,075
Latest member
staticfluids

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top