How To Autofill Number Serial In Merged Cells In Excel—Simple Tutorial

Date:2021-5-24 Author:Sandra

It’s definitely easy for you guys to autofill number serial in cells. The fastest way is to type 1 in cell A1 and 2 in cell A2 then fill it.

How To Autofill Number Serial In Merged Cells In Excel—Simple Tutorial

But how to autofill number serial in merged cells like below.

How To Autofill Number Serial In Merged Cells In Excel—Simple Tutorial
How To Autofill Number Serial In Merged Cells In Excel—Simple Tutorial
How To Autofill Number Serial In Merged Cells In Excel—Simple Tutorial

If you do the same way, it will remind you that [ To do this, all the merged cells need to be the same size.] It doesn’t work

Actually, you just need to highlight the are you need to quickly fill, then type =MAX(A$1:A1)+1 in cell A1 and press Ctrl and Enter keys together.

How To Autofill Number Serial In Merged Cells In Excel—Simple Tutorial
How To Autofill Number Serial In Merged Cells In Excel—Simple Tutorial

That’s the all for today’s tutorial. Hope this can be helpful to you. See you next time~

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *