excel tabs

S

sandlapper

I need to put addresses on the tabs but there isn't enough room to type the
entire address. Can I make the tabs so they hold more characters?
 
L

ljw9292

I made a spreadsheet that needs street addresseson the tabs. I don't have
room to type the complete street names on the tabs.
Lin
 
D

Don Guillett

One solution would be to put your info on a master sheet. Rename your other
sheets
1,2,3,4,5,etc
and use this by right click master sheet tab>insert this>save.
Now when you double click on the row with the address you will goto the
sheet.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Sheets(Target.Row).Select
End Sub
 
G

Gord Dibben

Sheet Tab names are limited to 30 characters.

Find some other naming method.


Gord Dibben Excel MVP
 
Top