precedent

  1. T

    Does this shortcut exist? Jump to precedent/dependent cell on another sheet

    Hey Mr Excel users, I'm looking for a shortcut that allows me to jump to dependent or precedent cells on other sheets. I know you can do it within the same sheet, but hate having to manually click that arrow that pops up when the cell being traced has a dependent / precedent on another sheet...
  2. Q

    Cycling through precedents

    Hi all, At my previous employer we had a tool/shortcut that allowed us to click on a cell containing a formula and then cycle through its precedents using shortcuts. The cycle was started off with CTRL+G (repurposed from Microsoft's default use) and then you could move to each precedent of the...
  3. P

    Mimic Coloured boxes around precedent cells with VBA

    Hi, I'm trying to mimic the coloured boxes that appear around precedent cells when you edit a formula. I can use VBA to colour the borders, but I like the style with small boxes on the 4 corners of the range as it allows the colour to be seen even if that cell is selected. Is there any way to...
  4. btorrean

    Parse Precedents/Dependents from Formulas

    Dear Forum Users, I have come upon a situation where I need to parse precedents/dependents from user formulas in a workbook. Excel's built-in '.Precedents' and '.Dependents' do not return all precedents or dependents. For example, if I have a two-sheet workbook and a formula on Sheet1...

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