ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Single cell opens as 2C X 2R size? How do I change? (https://www.excelbanter.com/new-users-excel/213065-single-cell-opens-2c-x-2r-size-how-do-i-change.html)

Excel Bill

Single cell opens as 2C X 2R size? How do I change?
 
When I 'click' on a cell, it 'opens' with a 2 colmn X 2 row size. How do I
get back to just having a 'normal' 1C X 1R size?

JE McGimpsey

Single cell opens as 2C X 2R size? How do I change?
 
the method varies depending on the version you're using, but in general:

Select the merged cells, choose Format/Cells/Alignment, and uncheck the
merged cells checkbox.


In article ,
Excel Bill <Excel wrote:

When I 'click' on a cell, it 'opens' with a 2 colmn X 2 row size. How do I
get back to just having a 'normal' 1C X 1R size?



All times are GMT +1. The time now is 02:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com