Sida qaar badan oo naga mid ah laga yaabo inay hore u yaqaaneen, Google Sheets waa bedelka Microsoft Excel , mana aha qalab xun oo dhan. Nidaamka weyn ee walxaha, xaashiyadu^(Sheets) maaha kuwo la mid ah heerka Excel marka la eego shaqeynta, laakiin waxay ku fiican tahay inta badan hawlaha aasaasiga ah. Tusaale ahaan, Google Sheets wuxuu taageero u leeyahay tiirarka, laakiin qof kastaa ma yaqaan sida loo qariyo tiir ka dib abuurista mid.

Ku qari safafka^{(Hide Rows)} iyo tiirarka^(Columns) xaashida Google -ka

Waxaa laga yaabaa inuu yimaado wakhti inta lagu jiro shaqada oo aadan rabin inaad aragto qaar ka mid ah tiirarka dukumeentigaaga. Doorashada ugu fiican waa in la qariyo, markaa haddii aadan aqoon sida loo sameeyo hawshan fudud, ka dibna sii wad akhrinta si aad u barato sida.

1. Fur dukumeentiga xaashida su'aasha^(Sheets)
2. Dooro tiirarka aad rabto inay tagto
3. Midig ku dhufo oo dooro Qari^(Hide) tiirarka
4. Sidoo kale, waxaad qarin kartaa Safka.

Aan si faahfaahsan uga hadalno arrintan.

Fur dukumeentiga xaashida su'aasha^(Sheets)

Marka hore, waxaa lagaa doonayaa inaad Google Sheets ka furto biraawsarkaaga. Waayo-aragnimada ugu fiican, fadlan isticmaal biraawsar ku salaysan Chromium sida Google Chrome ama Microsoft Edge . Halkaa, ka dooro dukumeentiga si aad u furto.

Dooro tiirarka aad rabto inay tagto

Talaabada xigta kadib furitaanka dukumeentiga xaashida Google^{(Google Sheets)} waa in la muujiyo tiirarka saxda ah. Guji^(Click) oo ku jiid tilmaamahaaga jiirka si aad u muujiso tiirarka aad rabto inaad qariso. Marka tan la sameeyo, waa inuu jiraa dabool buluug ah oo daboolaya tiirarka go'aaminaya in la iftiimiyay.

Hab kale oo lagu xusho tiirarka waa in la cadaadiyo CTRL oo guji tiir kasta si aad u muujiso jumlad.

Qari^(Hide) ama ka tirtir^(Delete) tiirarka dukumeenti

Hadda waa waqtigii aad qarin lahayd tiirarkaaga ama tirtiri lahayd si wanaagsan haddii taasi ay tahay waxa ay ku timid. Si aad wax u qariso, midig-guji tiirarka la iftiimiyay, ka dib dooro Qari^{(Hide Columns)} tiirarka oo fiirso markay indhahaaga hortooda ku luminayaan.

Haddii kale, waxaad tirtiri kartaa tiirarka adiga oo gujinaya Tirtir Tiirarka la xushay^{(Delete Selected Columns)} , waana taas.

Qari ama ka tirtir safafka xaashiyaha

Haddii aadan xiisayneynin inaad qariso ama tirtirto tiirarka, markaa ikhtiyaarka ayaa jira inaad sidaas oo kale ku sameyso safafka. Muuji safafka loo baahan yahay, ka dib halkaas, midig-guji oo dooro Qari Safka^{(Hide Rows)} , waana taas.

Ka saar^(Unhide) safafka iyo tiirarka Google Sheets

Qarintu waa hal shay, laakiin waxa iman doona wakhti marka safafkan qarsoon iyo tiirarkan mar kale loo baahan doono.

Si aad iyaga dib ugu soo celiso, si fudud u dhufo fallaadhaha lagu arkay shaashadda si aad wax ugu celiso xaaladdoodii caadiga ahayd.

Waa kaas!

How to hide Rows and Columns in Google Sheets

As many of us might have already known, Google Sheets is an alternative to Microsoft Excel, and it is not a bad tool at all. In the grand scheme of things, Sheets is not on the same level as Excel in terms of functionality, but it is good enough for most basic tasks. For example, Google Sheets has support for columns, but not everyone knows how to hide a column after creating one.

Hide Rows and Columns in Google Sheets

There may come a time during work where you just do not want to see some of the columns in your document. The best option is to hide them, so if you do not know how to do this simple task, then keep reading to learn how.

1. Open the Sheets document in question
2. Select the columns you want gone
3. Right-click on it and select Hide columns
4. Similarly, you can hide Rows.

Let us talk about this in more detail.

Open the Sheets document in question

First, you will be required to open Google Sheets in your web browser. For the best experience, please use a Chromium-based web browser such as Google Chrome or Microsoft Edge. From there, select the document to open it.

Select the columns you want gone

The next step after opening your Google Sheets document is to highlight the correct columns. Click and drag with your mouse pointer to highlight the columns you want to hide. When this is done, there should be a blue overlay covering the columns that determine they are highlighted.

Another way to select columns is to press down on CTRL and click on each column to highlight them in bulk.

Hide or Delete columns from a document

Now it is time to hide your columns or delete them for good if that is what it comes down to. In order to hide, right-click on the highlighted columns, then select Hide Columns and watch as they disappear before your eyes.

Alternatively, you could just delete the columns by clicking on Delete Selected Columns, and that’s it.

Hide or delete Rows from Sheets

If you are not interested in hiding or deleting columns, then the option is there to do the same with rows. Highlight the required rows, then from there, right-click and select Hide Rows, and that’s it.

Unhide rows and columns in Google Sheets

Hiding is one thing, but there will come a time when these hidden rows and columns will be needed again.

In order to bring them back, simply click on the arrows seen in the screenshot to return things to their normal state.

That’s it!

Related posts

• U kala qaybso dukumeenti ku jira Google Docs

• Sida qoraalka loogu beddelo abka shabakadda Google Sheets

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

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

• Sida loo geliyo sanduuqa qoraalka gudaha Google Docs

• Sida loogu daro Nambarada bogga Google Docs

• Sida loogu daro Watermark gudaha Google Docs

• U beddelo Word, PowerPoint, Excel Documents PDF adoo isticmaalaya Google Docs

• Sida loo qoro Screenplay gudaha Google Docs

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

• Sida loo soo celiyo Menu Toolbar ee maqan ee Google Docs

• Sida loogu daro tixraacyada iyo tixraacyada Google Docs

• Sida loo midoobo oo loo kala saaro unugyada Google Doc Table

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

• Sida loo barbar dhigo labada dukumeenti ee Google Docs

• Qaababka shaqo ee ugu wanaagsan ee Google Docs si loo abuuro CV xirfad leh

• Sida Documents loogu badalo PDF iyadoo Google Docs la isticmaalayo browser ah

• Sida loogu daro xuduud Google Docs

• Sida loo labanlaabo booska Google Docs

• Sida looga saaro Gridlines dukumeenti xaashida Google