Haddii aad ku abuurtay warqad yar oo ku taal Excel , waxaa laga yaabaa inaad rabto inaad udub dhexaad u noqoto bogga markaad daabacdo. Sida caadiga ah, waxay ku daabici doontaa xagga sare, geeska bidix ee bogga. Xog yar oo aad u yar, tani waxay wax u dhimi kartaa waxtarka soo jeedintaada.

Waxaa jira hab sahlan oo lagu dhex dhexaadinayo xogta bogga daabacan. Waxaad u dhexayn kartaa xogta si toos ah, toosan, ama labadaba.

Si aad u aragto sida xaashida shaqadu u muujin doonto marka la daabaco, dhagsii Faylka^(File) kadibna Daabac^(Print) . Waxaad ka heli doontaa dulmar ku saabsan dukumeentiga midigta fog.

Marka xaashida shaqada ee muunada ah ee kor ku xusan dib loo eego, waxaad arki kartaa in la dhigay dhanka sare, geesta bidix ee bogga. Tani waa sida ay u daabacan doonto.

Si aad u dhex dhigto xogta bogga daabacan, dhagsii bogga Layout^{(Page Layout)} -ka bogga . Kadibna, dhagsii badhanka fallaadha ee hoose, ee geeska midig ee qaybta Dejinta^{(Page Setup)} Bogga tab ee Layout Page .^{(Page Layout)}

Bogga Setup^{(Page Setup)} sanduuqa wada hadalka ayaa soo bandhigaya. Guji tab Margins . Hoosta Xarunta ciwaanka bogga^{(Center on page)} , dooro Sanduuqa hubinta Horizontally haddii aad rabto in macluumaadka uu u dhexeeyo bidix ilaa midig inta u dhaxaysa cidhifyada bogga. Dooro sanduuqa^(Vertically) si toos ah u calaamadee haddii aad rabto in macluumaadka kor-ilaa-hoose u dhexeeyo cidhifyada bogga. Dooro^(Select) labada sanduuq ee hubinta haddii aad rabto in xogta boggu udub dhexaad u tahay si toos ah iyo mid toosan labadaba.

Riix^(Click) badhanka Horu -u- fiirinta^{(Preview Preview)} oo hadda waxaad arki doontaa xogta ku salaysan bogga. Waxa kale oo aad bedeli kartaa jihaynta bogga oo waxay ahaan doontaa mid dhexda u ah.

Dhex dhexaadinta xogta bogga waxay wax ku ool u tahay kaliya xaashida hadda la doortay. Sidaa darteed^(Therefore) , xitaa haddii aad haysatid bog buuxa oo xog ah xaashida 2^{(Sheet 2)} , waxaad dhexda u dhigi kartaa xogta yar ee xaashida 1^{(Sheet 1)} adoon saameynin xaashida kale.

Sidoo kale, haddii aad haysato xaashi ay ku qoran tahay xog badan oo aad rabto in aad daabacdo qayb ka mid ah xaashida, laakiin aad rabto in ay noqoto mid udub dhexaad u ah, markaa waxaad samayn kartaa taas adigoo dooranaya xogta aad rabto inaad daabacdo. Markaad hesho xogta, u gudub Faylka Daabacaada^{(File Print)} oo waxaad arki doontaa hoos u dhac ku yaal Settings .

Waxaad dooran kartaa inaad daabacdo xaashida firfircoon, daabac buugga shaqada oo dhan ama ku daabac doorashada hadda jirta. Tani runtii waa mid anfacaya maadaama laga yaabo inaad haysato xaashi shaqo oo aad u weyn, laakiin kaliya waxaad u baahan tahay inaad daabacdo garaaf ama jaantus kooban. Ku raaxayso!

Center Your Worksheet Data in Excel for Printing

If you have created a smаll worksheet in Excel, you may want to center it on the page when уou print it. By default, it will рrint in the upper, left corner of the page. For a very small set of data, thiѕ can detract from the effectiveness of your presentation.

There is an easy way to center the data on the printed page. You can center the data horizontally, vertically, or both.

To see how your worksheet will display when printed, click on File and then Print. You’ll get a preview of the document at the far right.

When the sample worksheet above is previewed, you can see that it is placed in the upper, left corner of the page. This is how it will print.

To center the data on the printed page, click the Page Layout tab. Then, click the arrow button in the lower, right corner of the Page Setup section of the Page Layout tab.

The Page Setup dialog box displays. Click the Margins tab. Under the Center on page heading, select the Horizontally checkbox if you want the information centered left-to-right between the margins of the page. Select the Vertically check box if you want the information centered top-to-bottom between the margins of the page. Select both checkboxes if you want the data centered in the page both horizontally and vertically.

Click the Preview Preview button and now you will see the data centered on the page. You can also change the page orientation and it will remain centered.

Centering data on a page is effective only for the currently selected sheet. Therefore, even if you have a full page of data on Sheet 2, you can center the smaller set of data on Sheet 1 without affecting other sheets.

Also, if you have a sheet with a lot of data on it and you only want to print out one section of the sheet, but still want it centered, then you can do that by first selecting the data you want to print. Once you have the data selected, go to File Print and you’ll see a dropdown right below Settings.

You can choose to print the active sheets, print the entire workbook or print on the current selection. This is really handy as you might have a huge worksheet, but only need to print a summary graph or chart. Enjoy!

Related posts

• Sida loo Geliyo Xaashida Shaqada ee Excel Word Doc

• Safka Kooxda iyo Tiirarka ku jira xaashida shaqada ee Excel

• Hal-Column iyo Xog-urur badan oo Aasaaska ah oo ku kala soocida xaashida faafinta ee Excel

• Sida Loo Geliyo CSV ama TSV Xaashida Shaqada ee Excel

• Sida Loogu Mideeyo Xogta Faylal Badan oo Excel ah

• Hagaha VBA Sare ee MS Excel

• Sida loo xisaabiyo Z-Score gudaha Excel

• 4 siyaabood oo loo isticmaalo calaamadda jeeg ee Excel

• 2 siyaabood oo loo Isticmaalo Shaqada Transpose ee Excel

• Waa maxay sababta ay tahay inaad u isticmaasho safafka la magacaabay ee Excel

• Faylka Xogta Muuqaalka Lama Geli karo: 4 Hagaajin La Isku Dayo

• Sida Loo Isticmaalo Shaqada PMT ee Excel

• Isticmaal kiiboodhka si aad u bedesho dhererka safka iyo ballaca tiirka gudaha Excel

• Farqiga u dhexeeya Microsoft Excel Online iyo Excel ee Desktop

• Sida Loo Raadiyo Excel

• Ku Qari Xogta Qarsoon ee Dukumeenti 2007/2010

• U isticmaal Magacyada Range Dynamic ee Excel si aad u Dejiso Dabcida

• Goorta la Isticmaalayo Tusaha-Match Bedelkii VLOOKUP ee Excel

• 3 Siyood Oo Unugyada Excel Loogu Kala Qaybiyo

• Google Sheets vs Microsoft Excel - Waa maxay faraqa u dhexeeya?