Really appreciate your teaching style-- breaks down what you're doing, why, and what it's called, but never condescending, and the pace you set reflects that.
thank you so much oh my God i was really strugling to enter data using excel and i was also strugling to cellect cells ,no word can explain how grateful i really am.
@@ProfessorAdamMorgan ,, Its very typical of me, you spend several hours learning something new with excel you have your own spread sheet open & you polish what you have learned from start to finish.....Next morning, open your spread sheet & where do i start, happens several time over the lockdown, but open up what you were watching yesterday & the penny drops, most of the time, ~Thank you.
Hey thanks Tony. I'm happy this video was helpful for you. I'm still recording weekly Excel videos so I hope they're helpful for your class, thanks for watching.
Hello Prof, just had a quick question tho if i for exe if i have text in A1,B1,C1 and i won't merge them using formula without losing the data from B1&C1 like just removing the borders between the 3 of em and putting them together in 1 cell how can i do that?
hello, i have data on F and G columns that have some special numbers, so, i go through them to edit/change data occuring twice, please is there a way to simplify the process?
Hello, is there a way to see if a cell has been merged and centered with another? As if I merge 10 cells and I write in it, the only cell that gives me if isblank=true is only for the first one, but I need to know that all 10 cells are filled with text.
Hi David, If you highlight the cell or range of cells, you can look in the Home Tab, Alignment Group, and see if Merge & Center is highlighted. If it is, it has been applied, if not then it is not applied. You can the formula bar to see if the cell has contents in it or not. I hope this helps.
Hi Zhe, Tables, are set up to have data below each individual column. Therefore, you cannot merge and center while in the Table format. I'd recommend converting your data to a range if that's what you want to do.
Man is saving my intro to pc grade
I came here looking for coal (Merge & Center) and I found gold. Thank you. 🙌
Glad I could help! Thank you for watching, Tshepo!
Where have you been all my life?! Thank you
Haha thanks Renece! Glad this video was helpful for you, thanks for watching!
Really appreciate your teaching style-- breaks down what you're doing, why, and what it's called, but never condescending, and the pace you set reflects that.
I love the way you explain your steps. You make it easy to follow and learn. Especially, for me as an older person and not tech savvy. Thank you
LEARNED SOOOOO MUCH😭😭
thank you so much oh my God i was really strugling to enter data using excel and i was also strugling to cellect cells ,no word can explain how grateful i really am.
Glad it helped! Thank you for watching and good luck entering your data, Zanele!
THANK YOU VERY MUCH FOR YOUR TUTORIAL ON MERGE AND CENTER. IT REALLY HELPS A LOT.
This video us great. I want to start using youtube more often thanks to you!
this channel has taught me more than the course i am currently paying for. Thank you for all your hard work. Us students truly appreciate it.
instablaster...
Very helpful thank you
Excellent video, wish more people would wear the mic you have, 10/10 clarity.
Glad you liked it! Thanks for watching, Chas.
@@ProfessorAdamMorgan ,, Its very typical of me, you spend several hours learning something new with excel you have your own spread sheet open & you polish what you have learned from start to finish.....Next morning, open your spread sheet & where do i start, happens several time over the lockdown, but open up what you were watching yesterday & the penny drops, most of the time, ~Thank you.
Thank you. Very helpful.
Glad it was helpful! Thanks for watching, Obinna.
Thank you for all of your help!
thanks. yo helped a lot
I think you explained nicely
Thank you for watching, Mazher!
thanks!
Life saver thanks professor
this was super helpful!! thank you!😎
Nice work! Thanks.
It's really helpful
I'm glad this helped you out, Fionah. Thank you for watching!
Thanks!
Video starts at 1:50
great fuckn job dude. I know you posted this years ago but do more I need you right now for a online class I'm taking
Hey thanks Tony. I'm happy this video was helpful for you. I'm still recording weekly Excel videos so I hope they're helpful for your class, thanks for watching.
Plz help me..... To apply banded theme in window 8 because there is not option of banded theme.... How can i add it
thanks very helpful. #2018
Glad it helped you out, thanks for watching Mohssine!
Please I would like to know how merge a large number of cells that is my heading and centralize them
how do you do it without screwing up my background colour?
Hello Prof,
just had a quick question tho if i for exe if i have text in A1,B1,C1 and i won't merge them using formula without losing the data from B1&C1 like just removing the borders between the 3 of em and putting them together in 1 cell how can i do that?
Thanks tho it's " CONCATENATE " just figured it out lol thanks anyway
hello, i have data on F and G columns that have some special numbers, so, i go through them to edit/change data occuring twice, please is there a way to simplify the process?
Why i can't merge my cell after i am formating my cell as a table? Can i?
It is possible to merge a cell when they already have a drop down menu?
Lmao so that's what I've been doing wrong, I instead merged a and b but I had to merge the cells a2 and b2 🤦🏻♂️😂thx for they
Excel VBA sum "sheet1 A1" to "Sheet2 A1" and the total result will be in "Sheet2 A1" please how will I do it, I need help
Hello, is there a way to see if a cell has been merged and centered with another? As if I merge 10 cells and I write in it, the only cell that gives me if isblank=true is only for the first one, but I need to know that all 10 cells are filled with text.
I guess professor Adam does not know the answer?
Hi David,
If you highlight the cell or range of cells, you can look in the Home Tab, Alignment Group, and see if Merge & Center is highlighted. If it is, it has been applied, if not then it is not applied. You can the formula bar to see if the cell has contents in it or not. I hope this helps.
Hi David,
Sorry, I'm a few months behind on comments right now. Catching up since the semester is now over.
How to merge cells when in the table format?
Hi Zhe,
Tables, are set up to have data below each individual column. Therefore, you cannot merge and center while in the Table format. I'd recommend converting your data to a range if that's what you want to do.
@@ProfessorAdamMorgan alright thank you so much
No problem!
😘
Very bad explaines
What were you looking for Tripti Giri?
The explanation is superb
Lmao so that's what I've been doing wrong, I instead merged a and b but I had to merge the cells a2 and b2 🤦🏻♂️😂thx for they