Leila, Every video of yours that I watch just wreaks of AWESOMENESS!!!! Keep up the good work. I fish all over the web to find an answer to something and end up with you. You clarify everything in seconds! Thanks for sharing you knowledge.
For many people the tough things are the basics - as they actually do not use the more complicated features. Just recently I had to explain this very specific content of your tutorial to a class and the simplicity of solving the "problem" was so astonishing to them. Thanks for reminding that we can reach out to people also with "basics".
Just last Friday I taught a refresher course, mainly focussng on basic functionalities. It's targeting people working with Excel on a daily basis, but not feeling secure with it or for those coming back to work after a long period of leave.
Leila Gharani , It totally does, I still remember my first accounting job, on the first day, I handed my boss a report she wanted me to print from Excel, and I had added neat footers - and she was amazed at such a simple and basic Excel skill : )
Thanks for sharing this information. Yesterday I spent the whole afternoon struggling with a particular heather and the solution was so simple! Thanks a lot!
Excellent video! The trick you have shared with us in copying header and footer to other sheets has saved a lot of time in doing the tedious time-consuming repetitive work. Thank you so much.
@@LeilaGharani Please publish the way to change the justification within the three header sections. I want to be able to enter text at a point other than the left margin in the left section, the center in the center section and the right margin in the right section.
For people who print out excel sheets often, for the love of all that is good and holy please switch your default view to page layout, and add header footer information. The number of unlabeled sheets I come across is criminal. Great tips here! Use them!
Thank you Leila. I always customize headers and footers for all the work papers I have to write. I have tried in the past to select all pertinent tabs but did not know about activating. Thanks!
Simply wonderful video. Usually we use excel for number churning activities and for rest word does the job. But using this one can actually use excel to do what word does. Thanks Leila :)
Nice tip to save time and it will save us from making possible mistakes if we apply it separately to each of the other. I love the way of teaching also. Great work 👍
Hi Leila.. great video and tips on headers / footers. I especially like the trick to apply the settings from one sheet to all the others. I've always written a macro for that. But, your tip is handy and useful to apply the settings quickly without having to take the time to write code that you might not use again or repeatedly without having to modify it each time. Thanks again and Thumbs up!
Love it! I only knew headers from page menu. Love how easy it is going to be for me to apply same header and footer to multiple pages. I use a macro for my standard footer and header, then modify. I tried this and I think selecting multiple sheets to apply the footer also adjusted the margins on all sheets. That would save me a ton of time when I have 10 or more sheets.
Very useful again with using the page layout rather than using the header/footer option. Using this for other sheets too is always handy as we use it to change a particular cell selecting all sheets and changing the cell content
have you ever done panel line charts stacked vertically with resetting y-axis labels by using data labels on a secondary axis scatter plot? its pretty exciting.
Dear Leila, i m a novice in excel and i would love to make a request that can you index or advise as to which topics to start from basic to advanced and so on that one can understand your and other MVP's overwhelming videos and organise ourself.
Great video, thanks.. However, do you know a way to keep the numbering specific to each sheet when multiple sheets are selected? So instead of 1 of 4 it remains as 1 of 2 and 1 of 2? Thanks
@Leila Gharani Please publish the way to change the justification within the three header sections. I want to be able to enter text at a point other than the left margin in the left section, the center in the center section and the right margin in the right section.
Leila, you have no idea how much benefit I had of your session always I'm waiting for your video I need your support if you conduct a separate session for map chart in excel 365 I need to know all details about
There are only Left Middle and Right section.. can I add more section or any ninja trick to do multiple section on header and footer ?? Dear @LeilaGharani
Help in working: I want to set two cells references such that anything written in these cells may reflect in different multiple sheets headers and footers.
How to repeat page no and total pages in a cell in the sheets as pages are created while page preview or page printing? How to repeat footers from rows in excel sheets.
Hi Leila, Is there a way to add the header and footer to a blank excel and make it as a template so that whenever I start a new workbook, the header and footer is already there? Many thanks.
I have a question. If my page numbers are customized for example section would look like this 1.1 Current Award Balance by School. Would I have to customize the footer and drop each section for the page number?
@LeilaGharani in page setup>header footer tab, there is drop down option where i think you can load/copy from other files? what if i want to make different or multiple template of header/footer? i tried to make 1 file but it will not show from the dropdown. in the existing dropdown. also file in the dropdown are no where to be found
Can you tell me how to add the file name to my default Excel workbook so that the file name appears automatically in the footer of every new Excel worksheet created? I'm using Excel in Microsoft 365 Apps for Business. Thanks.
help, I am attempting to insert a small 10 cell table to the top header left side. All my documentation needs Created/date, modified/date, rev by/name, rev/date, Supersedes/date. The table helps keep information contained, and can change the dates when things are modified. Is there anyway I can do this in excel? I can created a table in word, and paste it into header in word in the table, but when I copy that same table and attempt to paste into the header in excel, it will past the information, but not the table?.. suggestions please. LOVE the ability to create header/footer and make it the same in ALL the tabs am working in.. WHAT A TIME SAVER thanks so much. REALLY love the way you do your videos, easy to SEE, learn and understand. thanks so much. My lucky day today.
Thnx. Is there any way to select footer as we select the header in an excel sheet. I have to repeat approx 4 rows on every page which I can do. But I am not able to select as well at the same time the 2 rows which include some pictures and text to be repeated on the same page. Kindly advise Thnx
Stay ahead with our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter
Leila, Every video of yours that I watch just wreaks of AWESOMENESS!!!! Keep up the good work. I fish all over the web to find an answer to something and end up with you. You clarify everything in seconds! Thanks for sharing you knowledge.
Wow, thank you!
You explain everything in terms that everyone can understand! You are very good at making these videos, thank you!
I appreciate that!
For many people the tough things are the basics - as they actually do not use the more complicated features. Just recently I had to explain this very specific content of your tutorial to a class and the simplicity of solving the "problem" was so astonishing to them. Thanks for reminding that we can reach out to people also with "basics".
Thanks Giuseppe. Yes - I agree it's really easy to "miss" some helpful features. Which class are you teaching?
Just last Friday I taught a refresher course, mainly focussng on basic functionalities. It's targeting people working with Excel on a daily basis, but not feeling secure with it or for those coming back to work after a long period of leave.
Great video, Leila!!!! No doubt, the basic skill of headers and footers can really set a user apart from their Excel peers : )
Thank you Mike! Agree - a little bit of basic knowledge can go a long way :)
Leila Gharani , It totally does, I still remember my first accounting job, on the first day, I handed my boss a report she wanted me to print from Excel, and I had added neat footers - and she was amazed at such a simple and basic Excel skill : )
Lots of thanks to both of you Leila and Mike, you are the best excel instructors 🌹🌹🌹👏👏👏
Never thought Exel could be so much fun before watching your tutorials! Thanks a lot!
Glad you think so!
Thanks for sharing this information. Yesterday I spent the whole afternoon struggling with a particular heather and the solution was so simple! Thanks a lot!
Excellent video! The trick you have shared with us in copying header and footer to other sheets has saved a lot of time in doing the tedious time-consuming repetitive work. Thank you so much.
OMG, you nailed it. I was just fighting with this the other day. Thank you for simplifying and streamlining it for us.
That's great! I'm glad you find this helpful.
@@LeilaGharani
Please publish the way to change the justification within the three header sections. I want to be able to enter text at a point other than the left margin in the left section, the center in the center section and the right margin in the right section.
Thank you for the 'Select All' tip it saved me some time on my header and my protect sheets!
For people who print out excel sheets often, for the love of all that is good and holy please switch your default view to page layout, and add header footer information. The number of unlabeled sheets I come across is criminal. Great tips here! Use them!
Basic but very important topic to watch. Your explanations are so much easy to understand. Thank you for sharing. Cheers!!
I'm glad you find it easy to follow. Thank you for your support.
Thank you Leila. I always customize headers and footers for all the work papers I have to write. I have tried in the past to select all pertinent tabs but did not know about activating. Thanks!
Hello Leila, Thank you again and again, as usual, your perfect and useful vids, especially on your choice of painful topics. I
Simply wonderful video. Usually we use excel for number churning activities and for rest word does the job. But using this one can actually use excel to do what word does. Thanks Leila :)
Nice tip to save time and it will save us from making possible mistakes if we apply it separately to each of the other. I love the way of teaching also. Great work 👍
That's very nice, thank you. Glad you like the tutorials.
Hi Leila.. great video and tips on headers / footers. I especially like the trick to apply the settings from one sheet to all the others. I've always written a macro for that. But, your tip is handy and useful to apply the settings quickly without having to take the time to write code that you might not use again or repeatedly without having to modify it each time. Thanks again and Thumbs up!
Love it! I only knew headers from page menu. Love how easy it is going to be for me to apply same header and footer to multiple pages. I use a macro for my standard footer and header, then modify. I tried this and I think selecting multiple sheets to apply the footer also adjusted the margins on all sheets. That would save me a ton of time when I have 10 or more sheets.
Thank you for the clear precise demonstrations.
Very useful again with using the page layout rather than using the header/footer option. Using this for other sheets too is always handy as we use it to change a particular cell selecting all sheets and changing the cell content
Thank you so much. 👍🏼😀⭐⭐⭐⭐
Unsure why anyone would give a thumbs down 😕
Glad you enjoyed it!
I liked it, I brought something different without leaving Excel, valuable tips, thank you Leila.
Basic but extremly important! Thanks for the video, Leila!
Thank you Malina :)
your videos help us a lot! Thankyou so much!
Kindly make a video on how to add formula in footer
Great Video! Sometimes the most basic of skills slip through the cracks.
Thank you. Very true!
5:36 The Trick ;) thanks Leila😘
Even topics where I think I know it already I learn valuable methods.
Glad you found something useful!
Yep, definitely needed basic skills. Thanks for the tipps.
You're very welcome.
sank you very much, you videos are always useful smart and clever!!!!
THANK YOU! Finally I know what to do.
Thanks Leila. This was very helpful.
You're very welcome John :)
Thank you, it is really helpful for saving my time.
Thanks for the clear instructions! Helped me a lot. But the picture part didn't copy to the other sheets, do you know why?
Thank you for making such a useful vedio
I like all your videos.
Thank you so much Madam.
You're very welcome.
Thanks for a best trick on this tropic.
Most welcome
Very amazing...Leila looking very smart...☺
thank for your guide to header and footer and your video is very very good
wow i didn't know this. thank you for sharing
Great tip! Thank you for sharing!
How about automatically copy the header and footer for new sheet created? Any advice?
Thanks in advance :)
Excellent. Great work
have you ever done panel line charts stacked vertically with resetting y-axis labels by using data labels on a secondary axis scatter plot? its pretty exciting.
Sounds exciting for sure :) I have this one on panel charts so far: ruclips.net/video/5nf8rucx80E/видео.html
Thanks, you are the best ❤
Thank you 😊
Great video!! Thanks for sharing knowledge.
You're very welcome.
Dear Leila, i m a novice in excel and i would love to make a request that can you index or advise as to which topics to start from basic to advanced and so on that one can understand your and other MVP's overwhelming videos and organise ourself.
Hi Syed - if you go to the channel page and then go playlists, you will find a playlist for Excel basics. I suggest you start there. Happy learning :)
Thanks Leila ...Easily explained ... You look cute ;)) and I am ur subscriber from now onwards
Great video, thanks.. However, do you know a way to keep the numbering specific to each sheet when multiple sheets are selected? So instead of 1 of 4 it remains as 1 of 2 and 1 of 2? Thanks
You not only make learning interesting but extremely easy to digest. Thanks for the much needed videos.
Glad you like them!
Thanks a lot, i have learnt from you so much.
@Leila Gharani Please publish the way to change the justification within the three header sections. I want to be able to enter text at a point other than the left margin in the left section, the center in the center section and the right margin in the right section.
THANK YOU LEILA
Thank you very much... 👃👍
Leila, you have no idea how much benefit I had of your session always I'm waiting for your video I need your support if you conduct a separate session for map chart in excel 365 I need to know all details about
There are only Left Middle and Right section.. can I add more section or any ninja trick to do multiple section on header and footer ?? Dear @LeilaGharani
Helpful video
Please upload a video how to prepare quotation in excel
Very nice Teacher
So easy but so useful!
Thanks a lot for such a nice video. Can we increase Header or/and Footer. As I want to add 4 footers instead of 3. Pls guide me.
You' re great ! Thank you so much !
great trick for apply header and footer to other sheet. thats very uefull. thank you for sharing youre knowledge.
Very helpful, thanks
I'm glad you like it!
thank you so so much i really was looking for this
You're very welcome Ismail :)
wow! I love you thank you.
Good one,, ctrl Press my fav
Great Information
Help in working: I want to set two cells references such that anything written in these cells may reflect in different multiple sheets headers and footers.
That's so helpful can you please tell me I'm using the same printer as yours but I can't get the driver for it where can i get the driver from?
Thank you for your useful video, is there any reason why I can not have the logo in the header being copied on all sheets?
How to repeat page no and total pages in a cell in the sheets as pages are created while page preview or page printing? How to repeat footers from rows in excel sheets.
Very useful knowledge thanks
You're very welcome Rahul.
Hi Leila, Is there a way to add the header and footer to a blank excel and make it as a template so that whenever I start a new workbook, the header and footer is already there? Many thanks.
Mam,
Your videos is very helpful
Thanks for the great video :)
Thank you very much
Excellent !!!!!
I have a question. If my page numbers are customized for example section would look like this 1.1 Current Award Balance by School. Would I have to customize the footer and drop each section for the page number?
Thank you so much for this. Can not wait to use
Thanks from Bangladesh
You're very welcome Saiful.
great video
Glad you like it.
Thanks, it was nice
repeating header for all pages didn't wok with logos but it works with text.
any advice?
same problem, too
@LeilaGharani in page setup>header footer tab, there is drop down option where i think you can load/copy from other files? what if i want to make different or multiple template of header/footer? i tried to make 1 file but it will not show from the dropdown. in the existing dropdown. also file in the dropdown are no where to be found
Can you tell me how to add the file name to my default Excel workbook so that the file name appears automatically in the footer of every new Excel worksheet created? I'm using Excel in Microsoft 365 Apps for Business. Thanks.
Tq so much . U help me a lot . Just wasting 30 minutes 😔😔😔
Thanku ma'am great video on some of the basic topic
Thank you... very clear instruction to follow it... 🙏🏻
beautiful
Thank you :)...... is there any way to bring page No. 1/X from right align to the middle align?
Very valuable information madam@
Glad you find it useful :)
help, I am attempting to insert a small 10 cell table to the top header left side. All my documentation needs Created/date, modified/date, rev by/name, rev/date, Supersedes/date. The table helps keep information contained, and can change the dates when things are modified. Is there anyway I can do this in excel? I can created a table in word, and paste it into header in word in the table, but when I copy that same table and attempt to paste into the header in excel, it will past the information, but not the table?.. suggestions please.
LOVE the ability to create header/footer and make it the same in ALL the tabs am working in.. WHAT A TIME SAVER thanks so much. REALLY love the way you do your videos, easy to SEE, learn and understand. thanks so much. My lucky day today.
You saved me 😭
Thanks for the video. But how can I put different headers in one worksshet?
thank you Leila
You're very welcome :)
What version of Excel are you using in this tutorial? In my version of EXCEL, after the View TAB, I only see Automate, then Help TABS.
Thnx.
Is there any way to select footer as we select the header in an excel sheet.
I have to repeat approx 4 rows on every page which I can do. But I am not able to select as well at the same time the 2 rows which include some pictures and text to be repeated on the same page.
Kindly advise
Thnx
You are the best
excellent
Thank you.
Can you please share how to use check box to Data validation 🙂. Thanks 🤓
A check box that if checked, allows you to expand the validation?
@@LeilaGharani yes. Like if I check "Apple", using offset or index formula I can get Data for "Apple" from huge dataset. Thanks 😊
@@LeilaGharani one more thing it's check box not drop-down list 😋