Free Excel Tips and Tricks

Show sheet names vertically

This is a preview lesson

Purchase this course, or sign in if you’re already enrolled, to take this lesson.

In the newer versions of Excel, the sheet scrolling icons have changed.

To follow along go to 1.3

YouTube



Ad Free Version


Available in the paid for courses.

Our recommended course for you is:

Online Intermediate Excel Course

If you want to see all your sheets in Portrait style, all you need to do is RIGHT click on the sheet scrolling icons at the bottom left of the screen. This will bring up the list of sheets in the spreadsheet but in an easier to read portrait style. You can then choose a sheet and click OK to go there.

Selecting sheets

Note that the icon that used to be there to go to the first or last sheet has disappeared. If you want to do this you need to hold your CTRL button down and then click on the arrows.

Selecting sheets
0
    0
    Your Cart
    Your cart is emptyReturn to Shop