Have you ever had an Excel workbook with multiple sheets, where you no longer can see all the sheets in one view. Of course, you can use the built-in tabs navigation buttons and go to the next, previous, first or last sheet, but wouldn’t it be great if there was a way to see all the sheets and be able to click on the one you want to work on. It is especially useful when sheet names are long.Place your cursor in tabs navigation button area (red box). Right click there and a floating list of all the sheets will appear. Simply select the sheet you want to work on with your mouse and the pointing sheet will open.
Try it. Hope it help.
No comments:
Post a Comment