Exel Worksheet tabs, movable ?

Associate
Joined
7 Oct 2008
Posts
1,372
Location
Herefordshire
I'm doing a lot of spreadsheets right now in Excel, and one thing that really gets on my nerves is the Work sheet tabs being right at the bottom of the page, is there anyway I am able to move them?

Thanks
 
If they annoy you then you can hide them:- Tools,Options View tab

Or via a macro, which you can assign to a toolbar button or hot key combination

Code:
Sub ToggleSheetTabs()
    If ActiveWindow.DisplayWorkbookTabs = True Then
        ActiveWindow.DisplayWorkbookTabs = False
        Else
        ActiveWindow.DisplayWorkbookTabs = True
        End If
End Sub
 
Back
Top Bottom