Adjust column width when column header is hidden

[yitzymerm]

Can you adjust column width if the Column (ABC) heading is hidden (I can't get that plus symbol that's usually used to adjust column size) and same goes for the rows (123)....

I know I can unhide the headings, my question is if there's any way to do it while keeping them hidden.

Thanks

 

[Peter_SSs]

Is this what you mean?

Another option
Ctrl+Space bar to select column, right click & choose Column Width ...

 

[yitzymerm]

I guess that could work, was just looking more for something that I can quickly adjust width based on length of characters in the cell, which regularly we would just double click on top between the 2 columns.

Thanks.

 

[Jaafar Tribak]

I guess that could work, was just looking more for something that I can quickly adjust width based on length of characters in the cell, which regularly we would just double click on top between the 2 columns.

Thanks.

There are a number of ways to do this with vba. For example, you can attach the following code line to a button Selection.EntireColumn.AutoFit or use the OnKey Method to assign the macro to some keyboar shortcut keys.

or you could still use the mouse.

For example, the following code goes in the ThisWorkbook Module and it will autofit the row(s) and column(s) of the current selection when holding down the CTRL key and right-clicking the mouse:

Option Explicit

#If VBA7 Then
    Private Declare PtrSafe Function GetAsyncKeyState Lib "user32" (ByVal vKey As Long) As Integer
#Else
    Private Declare Function GetAsyncKeyState Lib "user32" (ByVal vKey As Long) As Integer
#End If

Private Sub Workbook_SheetBeforeRightClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)
    If GetAsyncKeyState(VBA.vbKeyControl) Then
        Cancel = True
        Selection.EntireColumn.AutoFit
        Selection.EntireRow.AutoFit
        Exit Sub
    End If
End Sub

 

[yitzymerm]

Okay this definitely helps much better.

Thanks!

 

[Peter_SSs]

I guess that could work, was just looking more for something that I can quickly adjust width based on length of characters in the cell, which regularly we would just double click on top between the 2 columns.

Well, with my first example above, after Ctr+Spacebar you could choose AutoFit Column Width instead of the option I highlighted.

Another alternative would be keyboard shortcut: Ctrl+Spacebar then Alt+H O I

 

[yitzymerm]

Yes that is correct, this can indeed also work for me.

Thanks

 

[Peter_SSs]

Cheers.