Selasa, 20 Juli 2021

How to Fix Microsoft Excel Can't Sort, error "To Do This, All The Merged Cells Need To Be The Same Size"

0

Baca Juga

In this short tutorial I wanna show you how to fix "To Do This, All The Merged Cells Need To Be The Same Size". Thus error usually happen if you try to sorting your excel data. 


First open your document that you want to sort, then click top corner of the cell to select all the cell , or you can press ctrl+a on the keyboard.

Select all cell



Then right click on the cell then chose Format Cells

chose Format Cells

After new windows open, chooes alignment tabs. 

Alignment


On the alignment option, uncheck merge cells option untul look like image bellow. 

Uncheck Merge Cells

after all that, click oke then try to sort your data again. Should be error not pop out again. 

if you things 


if you things this tutorial help you, please share and comment to this post. 

See you on next tutorial. 

Author Image
AboutOSS Lovers Admin

Sharing atau berbagai segala sesuatu yang berbau open source dan teknologi lainnya.

Tidak ada komentar:

Posting Komentar