00:00hi everyone in this video I will guide you how to use alt plus enter to add new
00:05lines in Excel like this one you can see that I have three products small large
00:12medium in one cell and the quantity is also in one cell so how you can do that
00:19first you need first you need to mention the size for example small and what you
00:26have to do is you need to press alt and hit the enter to add another line in the
00:32same cells and put the size and then again press the alt plus enter to add
00:42another line and mention the size and again press alt plus enter to mention
00:53the another size so now you can see that all four sizes are in the same cells now
01:01how you can put the quantity in the another cell press F2 and first you need
01:07to enter the quantity for example 10 and then press alt plus enter to make
01:14another line mention the quantity another alt plus enter and put the
01:21quantity and alt plus enter to put the quantity of exercise and hit enter and
01:31now you can see that the all four sizes are in the same cell along with the
01:37quantity this Excel tip works in Excel 2010 2013 1619 and Microsoft 365 and it is
01:46perfect for beginners and professional who want to make their spreadsheets look
01:50neat so don't forget to like share and subscribe for more Excel Excel tips and
01:55tricks
Comments