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 How To Autofill Number Serial In Merged Cells In Excel—Simple Tutorial](https://www.myofficetricks.com/wp-content/uploads/2021/05/myofficetricks.com_2021-05-24_08-19-05.gif)
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](https://www.myofficetricks.com/wp-content/uploads/2021/05/image-31.png)
![How To Autofill Number Serial In Merged Cells In Excel—Simple Tutorial How To Autofill Number Serial In Merged Cells In Excel—Simple Tutorial](https://www.myofficetricks.com/wp-content/uploads/2021/05/myofficetricks.com_2021-05-24_08-19-44.gif)
![How To Autofill Number Serial In Merged Cells In Excel—Simple Tutorial How To Autofill Number Serial In Merged Cells In Excel—Simple Tutorial](https://www.myofficetricks.com/wp-content/uploads/2021/05/image-32.png)
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](https://www.myofficetricks.com/wp-content/uploads/2021/05/myofficetricks.com_2021-05-24_08-20-39.gif)
![How To Autofill Number Serial In Merged Cells In Excel—Simple Tutorial How To Autofill Number Serial In Merged Cells In Excel—Simple Tutorial](https://www.myofficetricks.com/wp-content/uploads/2021/05/image-33.png)
That’s the all for today’s tutorial. Hope this can be helpful to you. See you next time~
Leave a Reply