Microsoft Office Excel Tip - Navigating Complex Spreadsheets
Have you ever tried working with an Excel workbook with various spreadsheets? I normally come across this situation when putting together a business plan and finance data on Excel and naming it according to the information on your spreadsheet corresponding to Assumptions, Financials, Break-even point, etc (as shown below).
However, you will note that as you get your business data onto your workbook, you get to the point where you can no longer see the worksheet beyond the 8th spreadsheet as shown above. You can definitely use the built in tabs navigation buttons or arrows on the left hand side where you can click next, previous, first or last sheet. It can be tedious though, clicking from one sheet to the next. There is a way to make life easier. Just right click on the tabs navigation buttons and a floating list of all the worksheets in the workbook will appear as shown on the left. It is particularly useful if the spreadsheet names are quite long.
Try it, and I hope you will find it useful in your daily tasks. There always is a way of working smarter.