Change back to default cell and column width.

[Mosaddeq Aziz]

Hi,

I have an excel sheet which have different cell size. I want to get back to
default cell size for the whole worksheet. Is that possible and how?

rgds,

Mosaddeq

 

[ShaneDevenshire]

Hi,

1. Click the top left corner of the spreadsheet to select the entire sheet.
Or press Ctrl A while in a blank cell.
2. Choose Format, Row, Height and enter 12.75
3. Choose Format, Column, Width and enter 8.43

If this helps, please click the Yes button.

 

[Dave Peterson]

You could use a macro:

Option Explicit
Sub testme()
With ActiveSheet
.Columns.ColumnWidth = .StandardWidth
End With
End Sub