Zipping through sheet tabs

If you have many sheets in your file and you want to navigate through them, you can use the sheet tab scrolling buttons which are present at the bottom of the excel window. However, if you are not using the mouse and have both your hands busy on the keyboard, and you want to quickly move from one tab to another, do this -

If you have a file that has a lot of sheets and you need to move between sheets on either ends of the scroll tabs, press the Ctrl key and hold the Page up (to scroll left) or Page Down (to scroll right) button.  You will quickly be able to scroll through all the sheets and get to the other / opposite end.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube