Change back to default cell and column width.

  • Thread starter Thread starter Mosaddeq Aziz
  • Start date Start date
M

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
 
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.
 
You could use a macro:

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