Excel Header & Footer (& Quickly Copy to other Sheets)

No video

Excel Header & Footer (& Quickly Copy to other Sheets)

Рет қаралды 299,057

Күн бұрын

Join 400,000+ professionals in our courses here 👉 link.xelplus.c...
Quickly learn how to insert header and footer information to your Excel sheets. This is great if you'd like to optimize your print outs of your Excel sheets or PDF files.
This comprehensive guide will teach you how to add company logos, page numbers, and more to your worksheets. Perfect for both printed pages and PDF documents, you'll learn to customize headers and footers like a pro!
🔑 Key Takeaways:
- Adding Headers and Footers: Learn two easy ways to insert headers and footers into your Excel sheets.
- Customization Tricks: Discover how to add file names, dates, custom text, and even images to your headers and footers.
- Picture Formatting: Adjust logo sizes and positioning for a perfect fit in your headers.
- Applying to Multiple Sheets: Find out how to apply the same header/footer across multiple tabs efficiently.
- Print Preview and Adjustments: Use print preview to see how your headers and footers will look, and make quick adjustments as needed.
🛠️ Why It Matters:
- Professional Look: Headers and footers can give your spreadsheets a polished and professional appearance.
- Consistency Across Documents: Apply the same header/footer to multiple sheets for uniformity in your reports.
- Efficient Customization: Save time and effort by learning quick and effective ways to customize your headers and footers.
In this Excel Basics tutorial we cover different topics such as:
1. How to insert a header & a footer in your documents. We take a look at two options. One option uses "Page Layout".
2. How to insert pictures in the header - such as your logo and how to adjust it so it fits better on the printed page.
3. How to add page numbers to the footer of your Excel sheets. Also how to add existing page number from the number of printed pages
4. How to copy an existing header or footer to other tabs
5. How to remove headers and footers in your Excel files.
★ Links to related videos: ★
If you're interested in Excel basics, check out my playlist:
• Excel Introduction - L...
★★ My Online Excel Courses ★★ www.xelplus.co...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creato...
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.co...
🎥 RESOURCES I recommend: www.xelplus.co...
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel

Пікірлер: 234

@LeilaGharani 6 ай бұрын

Stay ahead with our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter

@alicemcleod6149 11 ай бұрын

You explain everything in terms that everyone can understand! You are very good at making these videos, thank you!

@LeilaGharani 11 ай бұрын

I appreciate that!

@excelisfun 5 жыл бұрын

Great video, Leila!!!! No doubt, the basic skill of headers and footers can really set a user apart from their Excel peers : )

@LeilaGharani 5 жыл бұрын

Thank you Mike! Agree - a little bit of basic knowledge can go a long way :)

@excelisfun 5 жыл бұрын

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 : )

@AhmedMohammed-fg2po 4 жыл бұрын

Lots of thanks to both of you Leila and Mike, you are the best excel instructors 🌹🌹🌹👏👏👏

@chuckmoore7645 3 жыл бұрын

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.

@LeilaGharani 3 жыл бұрын

Wow, thank you!

@mazarata73 5 жыл бұрын

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".

@LeilaGharani 5 жыл бұрын

Thanks Giuseppe. Yes - I agree it's really easy to "miss" some helpful features. Which class are you teaching?

@mazarata73 5 жыл бұрын

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.

@chanchalagarwal2697 Жыл бұрын

your videos help us a lot! Thankyou so much! Kindly make a video on how to add formula in footer

@Johannes7707 7 ай бұрын

Never thought Exel could be so much fun before watching your tutorials! Thanks a lot!

@LeilaGharani 7 ай бұрын

Glad you think so!

@joseapar 5 жыл бұрын

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!

@mariaplaza8072 2 жыл бұрын

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!

@Betterifitsfree 5 жыл бұрын

OMG, you nailed it. I was just fighting with this the other day. Thank you for simplifying and streamlining it for us.

@LeilaGharani 5 жыл бұрын

That's great! I'm glad you find this helpful.

@mrx-yc9vn 2 жыл бұрын

@@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.

@LearnAccountingToday 2 жыл бұрын

Thank you for the 'Select All' tip it saved me some time on my header and my protect sheets!

@TheNabob57 4 жыл бұрын

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!

@tariqcpshaikh4014 5 жыл бұрын

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.

@tristangeoffroy9286 4 жыл бұрын

Hello Leila, Thank you again and again, as usual, your perfect and useful vids, especially on your choice of painful topics. I

@classicjalwa 2 жыл бұрын

Thank you so much. 👍🏼😀⭐⭐⭐⭐ Unsure why anyone would give a thumbs down 😕

@LeilaGharani 2 жыл бұрын

Glad you enjoyed it!

@ExcelBonanza 5 жыл бұрын

Great Video! Sometimes the most basic of skills slip through the cracks.

@LeilaGharani 5 жыл бұрын

Thank you. Very true!

@TamraShorts 5 жыл бұрын

Basic but very important topic to watch. Your explanations are so much easy to understand. Thank you for sharing. Cheers!!

@LeilaGharani 5 жыл бұрын

I'm glad you find it easy to follow. Thank you for your support.

@giorgidvali951159 2 жыл бұрын

sank you very much, you videos are always useful smart and clever!!!!

@NVenkadesh 5 жыл бұрын

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 👍

@LeilaGharani 5 жыл бұрын

That's very nice, thank you. Glad you like the tutorials.

@sachinrv1 5 жыл бұрын

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 :)

@MovinOn2222 2 жыл бұрын

Thank you for the clear precise demonstrations.

@shironmania 5 жыл бұрын

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

@pcrose5163 5 жыл бұрын

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.

@swee8181 3 жыл бұрын

5:36 The Trick ;) thanks Leila😘

@COOKWITHSAM 3 жыл бұрын

Helpful video Please upload a video how to prepare quotation in excel

@Luciano_mp 5 жыл бұрын

I liked it, I brought something different without leaving Excel, valuable tips, thank you Leila.

@heishoi 2 жыл бұрын

wow i didn't know this. thank you for sharing

@abdelrhmanhashem9332 4 жыл бұрын

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

@usmanahmed5122 5 жыл бұрын

Thank you so much Madam.

@LeilaGharani 5 жыл бұрын

You're very welcome.

@zhangmxin Жыл бұрын

Thank you, it is really helpful for saving my time.

@ckokse 5 жыл бұрын

Yep, definitely needed basic skills. Thanks for the tipps.

@LeilaGharani 5 жыл бұрын

You're very welcome.

@yogibearstie 3 жыл бұрын

Even topics where I think I know it already I learn valuable methods.

@LeilaGharani 3 жыл бұрын

Glad you found something useful!

@fulishujr2435 4 жыл бұрын

Thanks for a best trick on this tropic.

@LeilaGharani 4 жыл бұрын

Most welcome

@MalinaC 5 жыл бұрын

Basic but extremly important! Thanks for the video, Leila!

@LeilaGharani 5 жыл бұрын

Thank you Malina :)

@windwatcher8054 2 жыл бұрын

THANK YOU! Finally I know what to do.

@rameshmaharjan2206 5 жыл бұрын

I like all your videos.

@betoo1769 2 жыл бұрын

Tq so much . U help me a lot . Just wasting 30 minutes 😔😔😔

@sorel93 4 жыл бұрын

Thanks for the clear instructions! Helped me a lot. But the picture part didn't copy to the other sheets, do you know why?

@javierpena5146 3 жыл бұрын

THANK YOU LEILA

@wayneedmondson1065 5 жыл бұрын

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!

@ifraheemtariq 3 жыл бұрын

Very nice Teacher

@advocate.lalitsharma.4805 5 жыл бұрын

thank for your guide to header and footer and your video is very very good

@deogratiusmfoy1989 Жыл бұрын

wow! I love you thank you.

@MohammadAshooryan 5 жыл бұрын

great trick for apply header and footer to other sheet. thats very uefull. thank you for sharing youre knowledge.

@ssvr2009 2 жыл бұрын

Thanks Leila ...Easily explained ... You look cute ;)) and I am ur subscriber from now onwards

@ASA-Biker 4 жыл бұрын

Great Information

@fartinmartin5 5 жыл бұрын

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.

@LeilaGharani 5 жыл бұрын

Sounds exciting for sure :) I have this one on panel charts so far: kzfaq.info/get/bejne/a9SWa9WmyN6cYHk.html

@matthewojokojo1863 4 жыл бұрын

Thank you very much

@gajanandhumal8883 4 жыл бұрын

Thank you very much... 👃👍

@adnanakram2217 4 жыл бұрын

Good one,, ctrl Press my fav

@ZAHIDHUSSAIN-ri5kg 5 жыл бұрын

Very amazing...Leila looking very smart...☺

@syedyusufahamedzubairullah5615 5 жыл бұрын

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.

@LeilaGharani 5 жыл бұрын

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 :)

@mrx-yc9vn 2 жыл бұрын

@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.

@maxfintora3634 3 жыл бұрын

Thanks, you are the best ❤

@LeilaGharani 3 жыл бұрын

Thank you 😊

@maneeshkumar8189 4 жыл бұрын

Thanks you very much

@tariqsoomro2016 4 жыл бұрын

Thanks, it was nice

@HienPham-nb5zt 5 жыл бұрын

Great tip! Thank you for sharing! How about automatically copy the header and footer for new sheet created? Any advice? Thanks in advance :)

@aniljaggarwal60 2 жыл бұрын

It's wonderful trick

@JYLOI Жыл бұрын

beautiful

@johnborg6005 5 жыл бұрын

Thanks Leila. This was very helpful.

@LeilaGharani 5 жыл бұрын

You're very welcome John :)

@shahjahanali6338 4 жыл бұрын

Thanks a lot, i have learnt from you so much.

@OnlineToBrain 3 ай бұрын

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

@hieubui6871 2 жыл бұрын

thank you

@ManishShori Жыл бұрын

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.

@tahirshah6979 5 жыл бұрын

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.

@kinanqayyum6368 4 жыл бұрын

Excellent. Great work

@jainankur402 3 жыл бұрын

You not only make learning interesting but extremely easy to digest. Thanks for the much needed videos.

@LeilaGharani 3 жыл бұрын

Glad you like them!

@izharkhankhattak Жыл бұрын

excellent

@redflag1103 2 жыл бұрын

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?

@kaifansari6426 4 жыл бұрын

Thank you maam

@olasunkanmijojolola1101 3 жыл бұрын

You saved me 😭

5 жыл бұрын

So easy but so useful!

@meongcaem5802 5 жыл бұрын

Thank you... very clear instruction to follow it... 🙏🏻

@nimazavar8281 3 жыл бұрын

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?

@paulsprunken 8 ай бұрын

Dear Leila, always learn a lot from your videos, thank you but unfortunately this time not the answer I am looking for. I have a workbook with (this time) 37 sheets. Each sheet has a table of varying length. In some rows above each table there is some text, always same size (although the text itself varies in contents based on some cell values (text concatenates them per sheet). But I also need to put a section of text below each table before each sheet is saved as PDF. You could call it a footer but not in the sense of the print layout footer as explained in this video. And copying/pasting everything into Wordfiles defeats purpose as in a week from now I will have another batch to process. And I wouldn;t even know how to more efficiently place the dynamic text bloc a few rows underneath every table on each of the sheets other than doing an individual copy/paste across all sheets. I must be missing some knowledge for a more clever approach. All I can do is ask ... thank you kindly for your considerations

@rangikamuthunayake9943 5 жыл бұрын

Great video!! Thanks for sharing knowledge.

@LeilaGharani 5 жыл бұрын

You're very welcome.

@donnaassenza5736 5 жыл бұрын

Thank you so much for this. Can not wait to use

@md.saifulislamtuku9303 5 жыл бұрын

Thanks from Bangladesh

@LeilaGharani 5 жыл бұрын

You're very welcome Saiful.

@arazjaff2596 5 жыл бұрын

great video

@LeilaGharani 5 жыл бұрын

Glad you like it.

@sumitthakur2241 5 жыл бұрын

Thanku ma'am great video on some of the basic topic

@vrtlaricaprofesionalneuslu2663 4 жыл бұрын

You' re great ! Thank you so much !

@hosseinhosseinpoor4845 3 жыл бұрын

thanks.

@shakiraasfoor7599 4 жыл бұрын

مشكوره

@RahulJauhari 5 жыл бұрын

Very useful knowledge thanks

@LeilaGharani 5 жыл бұрын

You're very welcome Rahul.

@MNAKSA 5 жыл бұрын

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.

@shazman1341 Жыл бұрын

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

@maheshyadav7455 5 жыл бұрын

Mam, Your videos is very helpful

@cathyji9873 Жыл бұрын

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.

@saifec3031 4 жыл бұрын

nice one

@donnahendricks3333 5 жыл бұрын

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.

@mohosinsahokh4221 3 жыл бұрын

Thanks mam

@ahmadabusharkh2422 2 жыл бұрын

Hi, thanks for the great video, but the design tab doesn't appear to me!

@jean-yvespiret8773 2 жыл бұрын

Awesome! Was looking how to replicate header & footer to multiple tabs. Your videos are great! One question (that you must have been asked many times I guess...). What application do you use for the video screenshots? The zooming feature is great!

@msuhaib9411 5 жыл бұрын

Very helpful, thanks

@LeilaGharani 5 жыл бұрын

I'm glad you like it!

@ismailismaili0071 5 жыл бұрын

thank you so so much i really was looking for this

@LeilaGharani 5 жыл бұрын

You're very welcome Ismail :)

@anndoederlein5435 3 жыл бұрын

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.

@hasnainak4252 5 жыл бұрын

Thanks for the great video :)

@krn14242 5 жыл бұрын

Thanks Leila.

@kaushaljoshi19 5 жыл бұрын

It's really good info, but when try do such thing, the formatting which I fixed, is changed, and so again I need to fix the formatting.

@nathankoll193 5 жыл бұрын

Hi Leila, Thank you for another great video! For some reason, the header image did not copy to the other sheets, while the footer did. Do you have any idea why that might be? Best, Matthew