One possible solution is to use hyperlinks in your worksheets. That being said, there are several things you can do to get the results you want. The short answer is no, there is not a way in Excel to freeze the worksheet tabs. He would like the "Main" tab to always be visible, and the tabs to its right to scroll. Jonathan wonders if there is a way, much like freezing a pane, to freeze a worksheet tab. This last method is the easiest, but still is time consuming. In order to display the worksheet he must either click back a tab at a time or scroll all the way to the left of the tabs (by clicking on the control at the far left of the tabs) and then select the "Main" tab. He is constantly having to revert back to the "Main" worksheet. Jonathan has a workbook that contains over fifty worksheets, one of which is named "Main" and is positioned as the first tab in the workbook.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |