Haddii aad rabto in aad ku darto madax iyo^{(header )} footer xaashida ^{( footer )}Excel^{(Excel spreadsheet)} , markaa maqaalkani wuxuu kaa caawin doonaa inaad taas sameyso. Microsoft Excel waxay u ogolaataa isticmaalayaasha inay gashadaan madax iyo cagaf bog kasta si gacanta ah. Marka laga reebo taas, waxaad ku habeyn kartaa taariikhda, waqtiga, iyo sidoo kale qoraalka caadiga ah. Aynu eegno nidaamka ku lug leh.

Microsoft Excel waa mid ka mid ah  qalabka wax soo saarka ugu fiican^{(best productivity tools)} ee aad ku isticmaali karto kombayutarkaaga. Haddii aad rabto inaad kaydiso jadwalka maalinlaha ah ama kharashyada bilaha ah, waxaa suurtagal ah in la sameeyo wax walba iyadoo la kaashanayo  Microsoft Excel .

Aheader ama footer wuxuu kaa caawinayaa inaad fahamto bogga sida uu u shaqeeyo cinwaan ahaan. Aynu ka soo qaadno inay tahay inaad geliso cinwaannadaas xaashida faafintaada. Taas awgeed, casharradan ayaa ku anfici doona.

Sida loogu daro Header iyo Footer xaashida Excel

Si aad ugu darto Header iyo Footer xaashida xaashida ee Excel , raac talaabooyinkan-

1. Ka fur Microsoft Excel kumbuyuutarkaaga.
2. U beddel^(Insert) tabka Gelida
3. Guji ikhtiyaarka madaxa iyo cagaha ee qaybta ^{(Header & Footer)}qoraalka^(Text) .
4. Qor^(Write) madaxa iyo cagta sida loo baahdo.

Aynu si faahfaahsan u dul istaagno tillaabooyinkan.

Marka hore, waa inaad ku furto xaashida xaashida ee Microsoft Excel . Haddii aad rabto inaad geliso madaxa iyo cagaha ka hor intaadan samayn xaashida xaashida, samee xaashida madow adigoo furaya Excel . Taas ka dib, u beddel  tabka ^(Insert ) Gelida ee tabka  Guriga ^(Home ) oo ogow  qaybta qoraalka ^(Text ) . Halkan waxaad ka heli doontaa ikhtiyaarka loo yaqaan  Header & Footer .

Guji si aad^(Click) u geliso madaxa iyo cagaha dhammaan boggaga hal mar. Kadibna, waxaad bilaabi kartaa inaad gacanta ku qorto madaxa iyo cageeyaha aad rabto bog kasta.

Sida caadiga ah, waxay kuu ogolaanaysaa inaad geliso kaliya madaxa qoraalka iyo cagaha. Si kastaba ha ahaatee, aan ka soo qaadno inaad rabto inaad geliso lambarka bogga, tirada boggaga, taariikhda hadda, wakhtiga hadda, iwm. Waxa ugu muhiimsan ee ku saabsan shaqeyntan ayaa ah inay kuu ogolaato inaad geliso madax iyo cagafyo kala duwan bog kasta.

Taas awgeed, dhagsii qaybta madaxa ama qaybta hoose ee bogga, oo guji  tabka Naqshadda ^(Design ) , sida ka muuqata xagga sare.

Kadib, ka dooro nooc madax iyo cageeyaha qaybta  Header & Footer Elements  . Macluumaadkaaga, waxaad geli kartaa kuwan sidii madax-madaxeed ama hoose-

• Lambarka Bogga
• Tirada bogagga
• Taariikhda Hadda
• Waqtiga Hadda
• Jidka Faylka
• Magaca faylka
• Magaca xaashida
• Sawir

Haddii aad geliso sawir sida madax ama footer, waxaa suurtagal ah in aad u saxdo sida Microsoft Word . Taas awgeed, isticmaal  ikhtiyaarka Sawirka Qaabka  .^{(Format Picture )}

Waa intaas! Rajo in ay ku caawin

How to add Header and Footer in Excel spreadsheet

If you want to add a header and footer in Excel spreadsheet, then this article will help you to do that. Microsoft Excel allows users to insert a header and footer for each page manually. Other than that, you can customize it with the current date, time, as well as regular text. Let’s take a look at the procedure involved.

Microsoft Excel is one of the best productivity tools that you can use on your computer. Whether you want to keep a note of daily schedule or monthly expenses, it is possible to do everything with the help of Microsoft Excel.

Aheader or footer helps you to understand the page as it works as a title. Let’s assume that you have to insert such titles in your spreadsheet. For that, this tutorial will be handy for you.

How to add Header and Footer in Excel spreadsheet

To add Header and Footer in Excel spreadsheet, follow these steps-

1. Open Microsoft Excel on your computer.
2. Switch to the Insert tab.
3. Click the Header & Footer option in the Text section.
4. Write down the header and footer as required.

Let’s delve into these steps in detail.

At first, you will have to open the spreadsheet with Microsoft Excel. In case you want to insert the header and footer before making a spreadsheet, create a black spreadsheet by opening the Excel. Following that, switch to the Insert tab from the Home tab and find out the Text section. Here you will get an option called Header & Footer.

Click on it to insert header and footer in all the pages at once. Then, you can start typing the desired header and footer in each page manually.

By default, it allows you to insert only text header and footer. However, let’s assume that you want to insert the page number, number of pages, current date, current time, etc. The most essential thing about this functionality is that it lets you insert different header and footer on each page.

For that, click on the header or footer section on a page, and click on the Design tab, as visible on the top.

Then, choose a type of header and footer from the Header & Footer Elements section. For your information, you can insert these as a header or footer-

• Page Number
• Number of Pages
• Current Date
• Current Time
• File Path
• File Name
• Sheet Name
• Picture

If you insert a picture as a header or footer, it is possible to edit it like Microsoft Word. For that, make use of the Format Picture option.

That’s all! Hope it helps.

Related posts

• Sida loo isticmaalo Madaxa, Footer, iyo Footnote gudaha Google Docs

• Daar ama dami Header iyo Footer marka lagu daabacayo Chrome

• Sida loo xidho oo loo ilaaliyo Header iyo Footer gudaha Word

• Sida loo geliyo Header iyo Footer dukumeenti Word ah

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

• Sida loo beddelo midabka warqadda shaqada ee Excel

• Sida loo isticmaalo EDATE iyo EOMONTH Functions gudaha Excel

• Casharka Microsoft Excel, ee Bilowga ah

• Sida loo isticmaalo Muddada Dhaqaale Function gudaha Excel

• Sida loo isticmaalo shaqada DISC gudaha Excel

• Sida loo isticmaalo shaqada ISODD ee Excel

• Sida loogu daro Koodhka Dalka ama Goobta Liiska Lambarka Taleefanka ee Excel

• Sidee loo xisaabiyaa korodhka ama hoos u dhaca boqolkiiba ee Excel?

• Sida loo qaybiyo hal tiir oo loo kala qaybiyo tiirar badan oo Excel ah

• Sida loo abuuro Shaxda Radar gudaha Windows 11/10

• Sida loo isticmaalo shaqada DGET gudaha Excel

• Sida loogu isticmaalo shaqada MID iyo MIDB gudaha Microsoft Excel

• Sida loo tiriyo lambarka Haa ama Maya ee Excel

• Sida loo xidho unugyada qaacidada Excel si loo ilaaliyo

• Sida loo isticmaalo INT iyo Functions LCM gudaha Excel