Dad badan ayaa u baahan inay abuuraan xaashi isku mid ah bil kasta, waxayna ku qaataan waqti qiimo leh si ay xaashida ugu diyaariyaan gelitaanka xogta. Haddii aad ka mid tahay iyaga, waxaad samayn kartaa jaantuska xaashida Google-^{(create a Google Sheets template)} ka adigoo isticmaalaya tillaabadan tillaabo. Sidan, uma baahnid inaad abuurto xaashi cayriin isku mid ah mar kasta.

Xaashiyaha faafinta ayaa kaa caawin kara inaad xalliso dhibaatooyin aan tiro lahayn, Excel waa aaladda desktop-ka ugu fiican ee shaqadaas. Google Sheets waa mid ka mid ah beddelka ugu wanaagsan ee Microsoft Excel marka ay timaado abuurista xaashida faafinta. Sida Microsoft Excel , Google Sheets waxay ku siinaysaa qaab-dhismeedka qaar si aad u abuurto noocyo kala duwan oo xaashi ah iyadoo loo eegayo shuruudahaaga. Nashqaduhu wuxuu kaa caawin karaa inaad si dhakhso leh u qabato shaqada gelida xogta.

Dhibaatadu waxay ka bilaabataa marka aad heli weydo template xaashida faafintaada. Waa dhibaato caadi ah oo dad badan haysata in aysan wax faa'iido leh u arkin " Template gallery ." Tusaale ahaan, waxaa laga yaabaa inaad u baahato tiir ka duwan, qoraal, midab, iwm. Waqtigan oo kale, waxaad samayn kartaa template gudaha Google Sheets si aadan ugu baahnayn inaad waqti ku qaadato abuurista tiirarka, safafka, iwm. xaashida faafinta.

Macluumaadkaaga, kuwa haysta ka mid noqoshada G Suite waxay abuuri karaan oo soo gudbin karaan qaab abka dhammaan abka ( Dukumentiyada^(Docs) , Xaashiyaha^(Sheets) , iwm.). Haddii aadan haysan rukunka G Suite , waxay kuu tahay shaqo nuqul-koobi ah maadaama aysan jirin ikhtiyaar toos ah oo loogu talagalay baahidaada.

Sida loo sameeyo naqshad Google Sheets gaar ah

Si aad u abuurto qaab-dhismeedka Google Sheets , raac tillaabooyinkan-

1. Fur oo gal akoonkaaga Google Drive
2. Ku samee xaashi cusub oo xaashida Google - ka ah^(Google)
3. U diyaari xaashida faafinta si uu u noqdo hab-raac
4. Kaydi faylka oo koobi ka samee Google Drive

Si aad u bilowdo hawsha, waxaad u baahan tahay inaad furto Google Drive -ka oo aad gasho akoonkaaga. Taas ka dib, ku samee xaashi cusub oo xaashida Google^{(Google Sheets)} -ka ah . Taas awgeed, dhagsii badhanka Cusub^{(New )} , dooro Google Sheets , oo guji ikhtiyaarka xaashida faaruqinta . ^{(Blank spreadsheet )}Haddii aad rabto inaad fikrado ka soo qaadato template jira, waa inaad ka doorataa ikhtiyaarka template . ^{(From a template )}Xaaladdaas, waxaa laguu wareejin doonaa Template gallery halka aad u baahan tahay inaad ka doorato template sida waafaqsan shuruudahaaga.

Marka xigta, waxaad u baahan tahay inaad diyaariso xaashida faafinta cusub si aad u isticmaali karto qaab template ah. Taas macnaheedu waa inaad u baahan tahay inaad u habayso sida baahidaada si aad u isticmaasho ama u dirto qof kale.

Markaas, kaydi faylka haddii aanu horeba u kaydsan. Hadda, waxaad u baahan tahay inaad nuqul ka samayso xaashidan faafinta ah ee kaydinta Google Drive -ku si uu faylku u shaqeeyo qaab qaabaysan oo kale. Taas awgeed, midig-guji faylka oo dooro Samee^{(Make a copy)} ikhtiyaarka koobiga.

Waa inaad raacdaa tillaabada ugu dambeysa mar kasta oo aad rabto inaad sameyso fayl cusub adigoo isticmaalaya qaabka. Waxaa la soo jeediyay in template-ka lagu hayo gal gaar ah si aad dhaqso ugu garan karto.

Waa kaas! Hagahan waa inuu ku caawiyaa haddii aadan haysan rukunka G Suite .

Create a Google Sheets template without Google Workspace subscription

Many people need to create the same spreadsheet every month, and they spend some valuable time to make the spreadsheet ready for data entry. If you are one of them, you cаn create a Google Sheets template using this step by step guide. This way, you do not need to create the same raw spreadsheet every time.

A spreadsheet can help you solve countless problems, and Excel is the best desktop tool for that job. Google Sheets is one of the best alternatives for Microsoft Excel when it comes to creating a spreadsheet. Like Microsoft Excel, Google Sheets offers some templates so that you can create different types of sheets according to your requirements. A template can help you perform the data entry job faster.

The problem starts when you do not find a template for your spreadsheet. It is a common problem with many people that they do not see anything useful in the “Template gallery.” For example, you might need a different column, text, color, etc. At such a moment, you can create a template in Google Sheets so that you do not need to spend some time on creating the columns, rows, etc. while making the spreadsheet.

For your information, G Suite subscription holders can create and submit a template across all the apps (Docs, Sheets, etc.). If you do not have a G Suite subscription, it is a copy-paste job for you as there is no direct option for your need.

How to create a custom Google Sheets template

To create a Google Sheets template, follow these steps-

1. Open and sign in to your Google Drive account
2. Create a new spreadsheet with Google Sheets
3. Make the spreadsheet ready to be a template
4. Save the file and make a copy in Google Drive

To start the process, you need to open up the Google Drive website and sign in to your account. After that, create a new spreadsheet with Google Sheets. For that, click the New button, select Google Sheets, and click on the Blank spreadsheet option. If you want to take ideas from an existing template, you should select the From a template option. In that case, you will be redirected to the Template gallery from where you need to choose a template according to your requirements.

Next, you need to make the new spreadsheet ready so that you can use it as a template. That means you need to customize it as per your needs so that you can use or send it to someone else.

Then, save the file if it is not saved already. Now, you need to make a copy of this spreadsheet in your Google Drive storage so that the file works as a custom template. For that, right-click on the file and select Make a copy option.

You must follow the last step whenever you want to make a new file using the template. It is suggested to keep the template in a separate folder so that you can recognize it quickly.

That’s it! This guide should help you if you do not have a G Suite subscription.

Related posts

• Sida qoraalka loogu beddelo abka shabakadda Google Sheets

• Wax-soo-saarka ugu fiican ee Google Sheets si loo horumariyo wax soo saarka

• Sida otomaatig loogu sameeyo hawlaha xaashida Google ee Macros

• Sida loo muujiyo Taariikhda iyo Waqtiga Hadda ee Excel iyo Google Sheets

• Sida loo sameeyo liiska hoos u dhaca ee Excel iyo Google Sheets

• Daar ama dami soo jeedinta Drive-ka ee Chrome browser (Google Workspace)

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

• Hagaaji Google Docs Spellcheck oo aan si sax ah u shaqayn

• Sida loo hagaajiyo Khaladaadka Soo Dejinta Faylka ee browserka Google Chrome

• Sida loogu sameeyo Google Workspace lacag la'aan gudaha Gmailka

• Sida loo beddelo Default Print Settings gudaha Google Chrome

• Sida loo geliyo WordArt xaashida Google-ka iyadoo la isticmaalayo Google Drawings

• Qeexida Jajabka Android, Dhibaatada, Arrinta, Shaxda

• Sida loogu daro oo loo isticmaalo aagagga wakhtiyada badan ee Google Calendar

• Sida loo sameeyo Koofida Dhibcaha ee Google Docs dhowr daqiiqo gudahood

• Sida qoraalka loogu qaybiyo tiirarka ku jira Excel iyo Google Sheets

• Sida loogu xidho Google Sheets iyo Excel

• Sida Zero loogu daro lambarka hortiisa ee Excel iyo Google Sheets

• Sida loo tirtiro akoonka Google Stadia

• Sida loo dejiyo xadka Character ee Excel iyo Google Sheets