Dhererka safafka iyo ballaca tiirarka Excel waa kuwo toos ah, laakiin waxaad gacanta ku beddeli kartaa dhererka safka iyo ballaca tiirarka. Dhererka safka ee xaashiyaha ayaa kordha oo hoos u dhacaya iyadoo loo eegayo cabbirka xogta la geliyey safafka; Excel si toos ah ayuu u kordhin doonaa oo u dhimi doonaa safafka. Dejinta dhererka safafka waxaa loo adeegsadaa sababo gaar ah, sida unug leh qoraal hanuunin.

Beddel Dhererka^{(Change Row Height)} Safka iyo Balaadhka Tiirka^{(Column Width)} gudaha Excel

Tababarkan, waxaan ku sharixi doonaa sida loo:

• Beddel dhererka safka.
• Beddel ballaca tiirka

Waa maxay safafka iyo tiirarka Excel?

• Safka : ^(Rows)Xaashida faafinta^{(Spreadsheet)} ee Excel , safafka ayaa si toos ah u socda. Safafka waxaa lagu gartaa tirooyinka safafka kuwaas oo si toosan uga socda dhanka bidix ee xaashida.
• Tiirarka^(Columns) : Xaashida xaashida ee Excel , tiirarku si toos ah ayey u socdaan waxaana lagu gartaa madax tiirarka alifbeetada kuwaas oo si toos ah ugu socda dusha sare ee xaashida.

1] Beddel Dhererka safka

Waxaa jira laba ikhtiyaar oo lagu beddeli karo dhererka safka.

Ikhtiyaarka koowaad waa in aad aado halka safka saddexaad uu yaallo, dulsaarka saara soohdinta hoose ee lambarka saddexda saf, oo qabo oo hoos u jiid cursorka.

Waxaad arki doontaa natiijada.

Doorashada labaad waa inaad gujiso safka saddexaad.

Markaas u tag Home tab ee kooxda Unugyada^(Cells) oo guji Format .

Liiska hoos-u-dhaca, dooro Dhererka Safka^{(Row Height)}

Sanduuqa wada hadalka Dhererka^{(Row Height)} Saf ayaa soo bixi doona.

Gudaha sanduuqa wada-hadalka, dhig tirada dhererka aad rabto in safku ahaado, ka dibna riix OK .

2] Beddel Ballaca tiirka

Waxaa jira laba hab oo lagu beddelo ballaca tiirka.

Habka koowaad^{(Method one)} waa in aad aado xadka saxda ah ee tiirka B.

Jiid^(Drag) soohdinta saxda ah ee tiirka B, waxaadna ogaan doontaa in ballaca tiirka uu sii ballaaranayo.

Habka labaad waa in la gujiyo tiirka B.

Markaas u tag Home tab ee kooxda Unugyada^(Cells) oo guji Format .

Liiska hoos-u-hoosaadka, dooro ballaca tiirka^{(Column Width)} .

Sanduuqa wada hadalka ballaca tiirka^{(Column Width)} ayaa soo bixi doona; geli nambarka ballaca aad rabto in tiirarku ahaado oo guji OK .

Waxaan rajeynayaa in tani ay caawineyso; haddii aad wax su'aalo ah qabtid, fadlan faallo ka bixi hoos.

Akhri soo socda^{(Read next)} : Sida loogu daro ama looga saaro Xudduudaha Unugyada Microsoft Excel^{(How to add or remove Borders to Cells in Microsoft Excel)} .

How to change Row Height and Column Width in Excel

The height of rows and the width of columns in Excel are usually automatic, but you can change the row’s height and column width manually. The row height in spreadsheets increases and decreases according to the data’ѕ size entered into the rows; Excel will automatically increase and deсrease the rows. Setting the rоws’ height is used for specific reasons, suсh as a cell with an orientation text.

Change Row Height and Column Width in Excel

In this tutorial, we will explain how to:

• Change the height of a row.
• Change the width of a column.

What are Rows and Columns in Excel?

• Rows: On the excel Spreadsheet, rows run horizontally. The rows are identified by row numbers which run vertically on the left side of the spreadsheet.
• Columns: On the Excel spreadsheet, columns run vertically and are identified by alphabetical column headers that run horizontally on the spreadsheet’s top.

1] Change the Height of a row

There are two options to change the height of a row.

Option one is to go to where row number three is, place the cursor on the bottom border of the number three-row, hold and drag the cursor down.

You will see the result.

Option two is to click row three.

Then go to the Home tab in the Cells group and click Format.

In the drop-down list, select Row Height

A Row Height dialog box will appear.

Inside the dialog box, place the number of height you want the row to be, then click OK.

2] Change the Width of a column

There are two methods to change the width of the column.

Method one is to go to the right border of column B.

Drag the right border of column B, and you will notice that the column width gets wider.

Method two is to click column B.

Then go to the Home tab in the Cells group and click Format.

In the drop-down list, select Column Width.

A Column Width dialog box will appear; enter the width number you want the column to be and click OK.

I hope this helps; if you have questions, please comment below.

Read next: How to add or remove Borders to Cells in Microsoft Excel.

Related posts

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

• Sida loo koobiyeeyo Width sarifka isha ilaa xaashi kale oo Excel ah

• Balacaha Saarka AutoFit iyo Dhismayaasha Saf ee Excel

• Sida loo abuuro Graph Bar ama Shaxda Saxiixa ee Excel

• Sida Loo Hagaajiyo Safka gudaha Excel

• Sida loo abuuro Jaantuska Ururka gudaha Excel

• Sida loogu isticmaalo DEC2Bin gudaha Excel si loogu beddelo nambarka jajab tobanle ee binary

• Sida loo abuuro Shaxda Radar gudaha Windows 11/10

• Sida loo joojiyo ama loo damiyo Wadaagista Buuga Shaqada ee Excel

• Sida loo isticmaalo INT iyo Functions LCM gudaha Excel

• Sida loo daabaco unugyada la doortay ee Excel ama Google Sheets hal bog

• Microsoft Excel waxay sababtaa isticmaalka CPU sare marka uu socdo Windows 10

• Sida loo beddelo qaabka faylka caadiga ah ee lagu kaydiyo Word, Excel, PowerPoint

• Sida loo isticmaalo shaqada DGET gudaha Excel

• Sida loo dayactiro buug-shaqeedka Excel ee xumaaday

• Sida loo isticmaalo shaqada ISODD ee Excel

• Sida loo isticmaalo shaqada COOSE ee Excel

• Sida loo geliyo shaxda firfircoon ee xaashida Excel

• Sida loo beddelo dhererka caadiga ah iyo ballaca daaqadda Terminalka Windows

• Sida loo isticmaalo EDATE iyo EOMONTH Functions gudaha Excel