Front and Backward Navigation|Power Query|Excel Forum|My Online Training Hub

Good evening,

Can you please answer this question how do I add an index to a workbook of more than 50 worksheets and Row 1 and Column 1 Are already used? So, my question is if I insert a new row or column then all formulas mess up, and fixing them will be a bit of trouble.

Can you suggest any solution, please? My main question is about backward navigation. I created this Navigation by Power Query but was stuck at backward navigation. There is no first empty row or first column empty so where do I put index for backward navigation.

Thanks

PB