is changing cell height and width consider as part of formatting cell?

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,805
Office Version
  1. 2016
Platform
  1. Windows
Hi
I formatted a cell which has text content. I changed color, font size etc. Then I resized the cell by changing the height and the width. I wanted to delete the formatting so I went to Home-->Cell->clear format. I got rid of the format. However the height and the width of the cell did not come back to its origin! Thank you so much.
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
My first thought would be "When I set the width and height, do I use "FormatCells" like in adding borders?
If not, to my thinking it is not part of the formatting.
Maybe someone else has a better explanation though.
 
Upvote 0
You can't have a cell having a different width and height than its entire row or column, it is a formatting but not for 1 single cell.
You can copy an entire column, then Paste Special -> Formats on another column, and it would paste over its column width as well. So it is considered a formatting but for column/row, not a single cell.
 
Upvote 0

Forum statistics

Threads
1,224,825
Messages
6,181,190
Members
453,020
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top