Xaashiyaha Google^{(Google Sheets)} -ku waxa ay fududeeyaan in loo dejiyo aag gaar ah sida aagga daabacaadda ee buugaagtaada shaqada^{(print area in your workbooks)} . Waxaad dooran kartaa hal ama unugyo badan, xaashi shaqo, ama xitaa buug dhan oo la daabacayo.

Si taas loo sameeyo, waa inaad marka hore barataa sida loo dejiyo aagga daabacaadda Google Sheets .

U deji Aagga Daabacaadda si aad u daabacdo Xulashada Unugyada^{(Set the Print Area to Only Print Select Cells)}

Haddii aad xogtaada ku haysato unugyo gaar ah xaashidaada shaqo^{(specific cells in your worksheet)} , waxaad dejin kartaa ikhtiyaar si Google Sheets u daabaco oo keliya unugyadaas la doortay.

1. Ka bilow biraawsarkaaga kombayutarka, gal Google Sheets^{(Google Sheets)} , oo fur buugga shaqada ee aad rabto inaad daabacdo.
2. Dooro unugyada aad rabto inaad ku daabacdo buuggaaga shaqada.

1. Ka dooro Faylka^(File) > Ka daabac^(Print) liiska Google Sheets' Haddii kale, taabo Ctrl + P (Windows) ama Command + P (Mac).

1. Ka dooro unugyo la xushay^{(Selected cells)} tusmada hoos u dhaca ee Daabaca ee dhanka midig . ^(Print)Tani waxay hubinaysaa in unugyada la doortay oo keliya la daabacay.

1. Ka dooro Xiga^(Next) xagga sare ee shaashadda.
2. Raac habka daabacaadda caadiga ah si aad u daabacdo unugyadaada.

Deji Goobta Daabacaadda si aad u daabacdo dhammaan xaashida^{(Set the Print Area to Print the Entire Sheet)}

Haddii buug-shaqeedkaagu leeyahay waraaqo shaqo oo badan^{(workbook has multiple worksheets)} , oo aad jeclaan lahayd inaad daabacdo xaashi shaqo oo gaar ah, waxaad heli kartaa Google Sheets inuu taas sameeyo.

1. Ku fur buuggaaga shaqada xaashida Google^{(Google Sheets)} -ka ee shabakada shabakada.
2. Dooro xaashida shaqada ee aad rabto inaad ku daabacdo xagga hoose ee buugaaga shaqada.

1. Ka dooro Faylka^(File) > Ka daabac^(Print) liiska Google Sheets'.
2. Ka dooro xaashida hadda ee^{(Current sheet)} liiska hoos u dhaca Daabaca^(Print) ee dhanka midig. Waxaad arki doontaa dulmarka xaashida shaqada ee hadda dhanka bidix.

1. Ka dooro Xiga^(Next) xagga sare oo raac saaxirka daabacaadda caadiga ah si aad u daabacdo xaashida shaqada.

Deji Goobta Daabacaadda si aad u daabacdo Buug-hawleedka oo dhan^{(Set the Print Area to Print the Entire Workbook)}

Mararka qaarkood, waxaa laga yaabaa inaad rabto inaad daabacdo dhammaan buug-gacmeedkaaga Google^{(Google Sheets)} , kaas oo ay ku jiri karaan waraaqo shaqo oo badan. Google Sheets waxay leedahay ikhtiyaar ay ku sameyso taas, sidoo kale.

Marka aad daabacdo dhammaan buug-shaqeedka, hubi in daabacaaduhu leeyahay khad ku filan oo uu ku daabaco xogtaada^{(ink to print your data)} . Sidoo kale, ku quudi warqad ku filan saxaaradda warqaddaada daabacaha si aad u hubiso inaysan jirin wax carqalad ah markaad daabacdo^{(interruption when you print)} buuggaaga shaqada.

1. Ku gal buuggaaga shaqada xaashiyaha Google^{(Google Sheets)} ee biraawsarkaaga.
2. Ka dooro Faylka^(File) > Ka daabac^(Print) liiska Google Sheets'
3. Ka dooro Buug^(Workbook) -hawleed ka menu-hoosaadka Daabaca ee dhanka midig .^(Print)

1. Ka dooro Dhammaan xaashiyaha^{(All sheets)} liiska hoos u dhaca ee Xulashada^(Selection) .
2. Waxaad dhinaca bidix ku arki doontaa dulmar buugaag shaqo oo dhan. Haddii ay tani kuu muuqato, ka dooro Xiga^(Next) dhanka midig ee sare.
3. Ka dib waxaad dooran doontaa daabacahaaga, waxaad dooran doontaa cabbirka warqadda, iyo ikhtiyaarrada kale si aad ugu dambeyntii daabacdo buuggaaga shaqada.

U deji Aagga Daabacaadda si aad ugu daabacdo madaxyada bog kasta^{(Set the Print Area to Print Headers on Each Page)}

Haddii xogta Google Sheets ay ku faafto bogag badan, waxaa laga yaabaa inaad rabto inaad ku darto madaxyada bog kasta oo aad daabacdo. Tani waxay fududaynaysaa akhrinta xogta maadaama aad si sax ah u garanayso tiirka waxa uu yahay xogta bog kasta.

Si aad u daabacdo madaxyada tiirka ee bog kasta, waxaad marka hore barafayn doontaa safka madaxa^{(freeze the header row)} :

1. Fur buuggaaga shaqada oo gal xaashida shaqada ee aad rabto inaad daabacdo.
2. Ka dooro View > Baroj^(Freeze) > 1 saf^{(1 row)} oo ka socda bar menu-ka Google Sheets si aad u qaboojiso safka koowaad ee xaashidaada shaqo.

1. Dooro Fayl^(File) > Daabac^(Print) si aad u habayso ikhtiyaarada daabacaadda xaashidaada shaqo.
2. Dooro Headers & footers oo awood ku soo celi safafka la qaboojiyey^{(Repeat frozen rows)} ee midigta.

1. Habee^(Customize) wax kasta oo ikhtiyaar ah haddii aad rabto. Kadib, dooro Next oo ku yaal geeska kore ee midig.

Ku beddel Aagga Daabacaadda oo leh Nasasho Bogga Gaarka ah^{(Customize the Print Area With Custom Page Breaks)}

Waxaad ku dari kartaa nasashada bogga gaarka ah xaashiyahaaga shaqo ee Google Sheets si aad u ogeysiiso daabacahaaga meesha laga joojiyo daabacaadda bog^{(stop printing a page)} oo uu bilaabo bog cusub.

Si aad ugu darto bog nasasho xaashidaada shaqo:

1. Ka dooro Faylka^(File) > Ka daabac^(Print) liiska Google Sheets'.
2. Dooro Dejinta Bogga Jebinta Caadiga^{(Set Custom Page Breaks)} ah ee dhinaca midigta.

1. Jiid^(Drag) xariiqda dhibcaha buluuga ah ee xaashidaada shaqada si aad u qeexdo jebinta bogga. Kadibna, dooro Xaqiiji nasashada^{(Confirm Breaks)} dhanka geeska sare ee midig.

1. Haddii aadan ku faraxsanayn go'yada bogga ee la cayimay, dooro Dib^(Reset) u dajinta xagga sare si aad dib ugu dejiso bogga goynta.
2. Dooro Ku Xiga^(Next) dhanka midig ee sare si aad u sii wado daabacaadda xaashidaada shaqo ee boggaga caadiga ah.

Way fududahay in la habeeyo oo lagu dejiyo aagga daabacaadda ee xaashiyaha Google^{(It’s Easy to Customize and Set the Print Area in Google Sheets)}

Google Sheets waxay ku siinaysaa dabacsanaan aad ku daabacan karto qayb kasta oo ka mid ah buuggaaga shaqada ee aad rabto. Sidan, waxaad diiradda saari kartaa xogta ugu muhiimsan ee aad rabto inaad daabacdo markaad ka tagayso wax kasta oo kale. Waxaan rajeyneynaa in hagahan uu ku caawiyo.

How to Set the Print Area in Google Sheets

Goоgle Sheets makeѕ it eaѕy to set a custom area aѕ the print area in your workbooks. You can select single or multiple cells, a worksheet, or even an entire workbook to be printed.

To do that, you’ll have to first learn how to set the print area in Google Sheets.

Set the Print Area to Only Print Select Cells

If you have your data only in specific cells in your worksheet, you can configure an option so that Google Sheets only prints those select cells.

1. Launch a web browser on your computer, access Google Sheets, and open the workbook you’d like to print.
2. Select the cells you want to print in your workbook.

1. Choose File > Print from Google Sheets’ menu bar. Alternatively, press Ctrl + P (Windows) or Command + P (Mac).

1. Select Selected cells from the Print dropdown menu on the right. This ensures only the selected cells are printed.

1. Select Next at the top of the screen.
2. Follow the standard print process to print your cells.

Set the Print Area to Print the Entire Sheet

If your workbook has multiple worksheets, and you’d like to print a specific worksheet, you can get Google Sheets to do that.

1. Open your workbook with Google Sheets in a web browser.
2. Choose the worksheet you’d like to print at the bottom of your workbook.

1. Select File > Print from Google Sheets’ menu bar.
2. Choose Current sheet from the Print dropdown menu on the right. You’ll see your current worksheet’s preview on the left.

1. Select Next at the top and follow the standard print wizard to print your worksheet.

Set the Print Area to Print the Entire Workbook

Sometimes, you may want to print your entire Google Sheets workbook, which could include multiple worksheets. Google Sheets has an option to do that, too.

When you print an entire workbook, make sure your printer has enough ink to print your data. Also, feed enough paper into your printer’s paper tray to ensure there’s no interruption when you print your workbook.

1. Access your workbook with Google Sheets in a web browser.
2. Choose File > Print from Google Sheets’ menu bar.
3. Select Workbook from the Print dropdown menu on the right.

1. Choose All sheets from the Selection dropdown menu.
2. You’ll see a preview of your entire workbook on the left. If this looks good to you, select Next at the top-right corner.
3. You’ll then select your printer, choose the paper size, and other options to finally print your workbook.

Set the Print Area to Print Headers on Each Page

If your Google Sheets data is spread across multiple pages, you may want to include the headers on each page that you print. This makes reading the data easier as you know exactly what column is for what data on each page.

To print column headers on each page, you’ll first freeze the header row:

1. Open your workbook and access the worksheet you want to print.
2. Select View > Freeze > 1 row from Google Sheets’ menu bar to freeze the first row in your worksheet.

1. Choose File > Print to configure the print options for your worksheet.
2. Select Headers & footers and enable Repeat frozen rows on the right.

1. Customize any other options if you’d like. Then, select Next at the top-right corner.

Customize the Print Area With Custom Page Breaks

You can add custom page breaks to your Google Sheets worksheets to let your printer know where to stop printing a page and start a new page.

To add a page break in your worksheet:

1. Select File > Print from Google Sheets’ menu bar.
2. Choose Set Custom Page Breaks in the sidebar on the right.

1. Drag the blue dotted line in your worksheet to specify a page break. Then, select Confirm Breaks at the top-right corner.

1. If you’re not happy with the specified page breaks, select Reset at the top to reset the page breaks.
2. Select Next at the top-right corner to continue to print your worksheet with your custom page breaks.

It’s Easy to Customize and Set the Print Area in Google Sheets

Google Sheets offers you the flexibility to print whatever part of your workbook you want. This way, you can focus on the main data that you’d like to print while leaving everything else out. We hope this guide helps you out.

Related posts

• Sida loogu Isticmaalo VLOOKUP gudaha Google Sheets

• Sida loo Geliyo Emoji gudaha Word, Google Docs iyo Outlook

• Sida loo Hagaajiyo 403 Cilada Reebay Google Chrome

• Waxa la sameeyo marka Google uu yidhaahdo waxaa laga yaabaa in kombayutarkaagu soo dirayo su'aalo toos ah

• Sida loo Beddelo Kaabta Google Drive iyo Sync Goobta Faylka

• 7 Degdeg ah Hagaajinta Marka Minecraft uu sii wado shil

• Sida maqaal loogu dhejiyo Linkedin (iyo waqtiyada ugu fiican ee la dhejiyo)

• Sida loogu raadiyo asxaabta Facebook goob, shaqo, ama dugsi

• Sida loo helo oo loo daabaco rasiidka Amazon

• Sida loogu daro Kalandarka Muuqaalkaaga Google Calendar

• Sida Loo Abuuro Asal Daah Furan gudaha GIMP

• Sida loo Isticmaalo Tags Discord Spoiler

• Sida Loo Helo Maalmaha Dhalashada Facebook-ga

• Sida Facebook Xusuus Loogu Helo

• Sida Slack loola xidhiidhiyo Google Calendar

• Waa maxay Qiimaynta Uber Rakaabka iyo sida loo hubiyo

• Google Keep vs. Evernote: Keebaa Wanaagsan?

• Ma bedeli kartaa Magacaaga Twitch? Haa, Laakin ka digtoonow

• Ku dheji Fayl kasta oo Windows ah Google Drive, OneDrive iyo Dropbox

• Kombuyuutarkaaga si aan kala sooc lahayn ma isagaa u shidmay?