Random cell ranges populated in the Navigation Pane and not deletable
Microsoft 365, Version 2602 (Build 19725.20126)
I have a log that spans thousands of rows with 8 columns. It is presentation format, rather than being an actual table, so there's plenty of blank cells. There are no formulas, because everything is entered manually.
The problem is that I opened the Navigation Pane, to see what I could do to make this workbook a little easier to navigate, since it's really quite long. For some reason, there are nearly 300 ranges picked out in the Navigation Pane. None of them are named, and they refer to chunks of text in combos that I can't figure out. Annoyingly, I also can't delete or even rename any of these ranges.
I've already run a bit of VBA to unhide any hidden ranges, ran one of the ready-made scripts to unhide all rows and columns to ensure there was nothing hiding there, and been into the Name Manager to confirm there are no named ranges.
Ideally, I'd like to delete all of these ranges, because I was actually hoping to name some ranges of my own so they could be easily navigated to. As it stands, any ranges I create are immediately lost in the endless scroll of the navigation pane.
The 8 columns of the log, with a fairly representative sample of the rows we use
The ranges that are in the Navigation Pane
The range selected by Sheet1!A1:H16
[link] [comments]
Want to read more?
Check out the full article on the original site