If like me you have Excel workbooks that appear to be ever growing and contain more worksheets than are comfortable to navigate, then a great solution is to add a Table Of Contents (TOC) to your workbook.
Not only does this solution result in a great professional looking workbook, it allows easy and fast navigation of worksheets form a front sheet. Each of the subsequent worksheets have their own hyperlink on this first page so the user can quickly choose the worksheet they need to use. The TOC solution for outweighs the usual ways of highlighting many different worksheets. The most common ways of doing this are
Color your sheet tabs (these can be very cumbersome to navigate) orRight click on your sheet scroll button at the lower left corner of the Excel window. This is not as effective after 19 sheets as Excel only displays up to this number then you have to scroll for the rest.
Not only does the TOC solution look great it is really easy too achieve. I like the fact I do not need to use code or macros, or fuss about with inserting hyperlinks and selecting the correct cells to reference them to. This way is quick, foolproof and easy.
The first thing you need to do is save your workbook. Sounds weird but if you do not save your work book then this tip will not work. (Just try it) So, after you have saved your work book
Select a specific or any cell on the workbook your want to link toPoint to the cell border and then right click with your mouseHit the ALT key, you will now be able to drag the cell to the Table Of Contents WorksheetThe sheet will become activated, at this point you will be able to drag the cell to the position you want the hyperlinked cell to be inRelease the ALT keyA pop up menu will appear. Select 'Create Hyperlink Here' from itThe Hyperlink will appear on your TOC page with its like to the destination worksheet
Once you have placed your hyperlink, the text will be the contents of the original cell you selected. For example if you selected Sales Report Qtr 1 11'12 then the text of the hyperlink will read just that.
Give this handy tip a go, it really will save you time, and give you an easy navigable worksheet in no time at all.
Want more Excel Tips and Tricks?. Look no further!. BJ Johnston has been an advanced Excel user for 15 years and is the creator of http://www.howtoexcelatexcel.com/?page_id=2 a site that shares Excel tips and tricks with it's enthusiastic members. Join in the discussion, where users are working smarter and faster with Excel and don't forget to sign up for a FREE newsletter and as a bonus receive a FREE EBook- 50 Top Tips and Tricks.
View the original article here
No comments:
Post a Comment