Freeze Worksheet (Tab) so they are always showing on the page

[dazfoz]

Morning Forum (Or afternoon/evening wherever you are!),

Im working on a spreadsheet at the moment, and the functionality is fine so don't need any help with that, but what I was wondering is;

Is it possible in Excel (2010) to anchor a specific worksheet (Lets call it Sheet1) so that it is the first sheet, but no matter how many sheets there are and if I keep scrolling to the right, that sheet will always be visible on the left hand side. Sort of a freeze panes effect, but for the tabs?

Apologies if I have not explained my question in enough detail!

Thanks in advance

Daz

 

[HansPA]

I am actually looking for same posibility in Excel 2016.

Any suggestions??

Regards Hans

 

[tygrrboi]

with vba it is possible. But a bit bulky.

Freezing Worksheet Tabs (Microsoft Excel)