Muuqaalka shaydaanka u eg ee Excel waxa uu u ekaan karaa mid taagan waqtiyada qaar iyada oo aan la helin suurtagalnimada in la abuuro is dhexgalyo la habeeyay si ay u waafaqdo baahiyaha xogta lagu kaydiyay xaashida shaqada.

In kasta oo ay tani run tahay ilaa xad, Microsoft waxa ay u dhistay Excel awoodda ay si degdeg ah u habayn karto ballaadhka tiirka iyo dhererka safafka si ay ugu dhigmaan cabbirka xogta unugyada.

Baro sida loo isticmaalo astaanta AutoFit^(AutoFit) ee Excel si aad si toos ah ugu beddesho cabbirka tiirarka iyo safafka cabbirka xogta ku jirta xaashida shaqada.

Kahor intaadan Beddelin ^{(Row Heights)}Balaadhka Tiirka^{(Column Widths)} iyo Dhererka Safka ee Excel

Waxaa jira xad ah sida weyn iyo yar aad u samayn karto tiirar iyo saf gudaha Excel . Ballaca^(Column) tiirka iyo dhererka safafka leh ee qiimaha eber ayaa ku qarsoon xaashida shaqada ee Excel . Tani waxay u dhigantaa isticmaalka tiirarka qari ama qarin sifada safka ah.

Tiirarku^(Columns) waxay yeelan karaan ballac ahaan ugu badnaan 255. Tiradani waxay ka dhigan tahay tirada ugu badan ee xarfaha tiirku ku hayn karo cabbirka farta caadiga ah.

Beddelida farta, cabbirka xarfaha, iyo ku darista xarfaha kale ee xarfaha sida farta farta iyo dhiirranaanta waxay si weyn u dhimaysaa tirada ugu badan ee xarfaha tiirku hayn karo. Cabbirka caadiga ah ee tiirka Excel waa 8.43, kaas oo la xidhiidha 64 pixels.

Sarafku waxay yeelan karaan dhererka ugu badan ee 409. Tiradani waxay ka dhigan tahay inta 1/72nd ee inch ah oo isku xigta ay qaadi karto. Cabbirka caadiga ah ee safka Excel waa 15, kaas oo la xidhiidha 20 pixels ama qiyaastii 1/5th of inch.

Isticmaalka Feature-ka AutoFit ee Excel

Ka soo qaad^(Suppose) xaashida shaqada ee Excel aad qoraal ku leedahay unugga A1 kaas oo ka baxsan 8.43 (64 pixels) ballaca tiirka caadiga ah. Ogow^(Notice) in kasta oo ballaca tiirka aanu ka koobnaan karin dhererka qoraalka, haddana Excel waxa uu u ogolaanayaa qoraalka in uu ku daadado tiirarka ku xiga.

Dooro Tiirka A^{(Column A)} , dhagsii tabka Guriga ee ^(Home)Ribbon -ka , oo hel qayb ka mid ah Ribbon -ka ku dhawaad ​​dhammaan dariiqa saxda ah ee Unugyada summadaysan^(Cells) .

Guji badhanka cinwaankiisu yahay Format oo hel qayb ka mid ah liiska ku calaamadsan Cabirka unugga^{(Cell Size)} . Ogow in ay jiraan saddex doorasho oo lagu beddeli karo ballaca tiirka.

Balaadhka tiirka^{(Column Width)} - Doorashadani waxay kuu ogolaanaysaa inaad gacanta ku beddesho ballaca tiirka adigoo ku qoraya nambar. Doorashadani faa'iido ma leh sababtoo ah waxaad si sahlan u samayn kartaa isla shay adiga oo si fudud u jiidaya tiirka ilaa cabbirka aad rabto.

Ballaca Saarka AutoFit^{(AutoFit Column Width)} - Tani waa ikhtiyaarka aan rabno. Doorashadani waxay beddeshaa cabbirka tiirka oo u beddelan doona cabbir cusub iyadoo ku xidhan dhererka waxa ku jira unugga tiirka ee qaada booska ugu badan.

Balaadhka Default^{(Default Width)} - Doorashadani dhab ahaantii ma beddeleyso ballaca tiirar kasta; waxay si fudud u beddeshaa ballaca caadiga ah ee tiirarka warqad shaqo gaar ah.

Dhinaca batoonka qaabka^(Format) , dooro AutoFit Column Width oo ogaysii in ballaca tiirka A^{(Column A)} uu isbeddelay si uu u koobo dhererka qoraalka unugga A1 .

Ogsoonow inaad sidoo kale habayn karto tiir adigoo si fudud u dooranaya tiirarka ama tiirarka ka dibna laba jeer gujinaya soohdinta gacanta midig ee tiir kasta oo la doortay.

Haddii aad rabto in aad dib u dejiso dhammaan balacyada tiirarka oo dib ugu celiso ballaca caadiga ah, kaliya dooro Format – Width Default^{(Format – Default Width)} oo ku qor 8.43 . Waxa kale oo aad isticmaali kartaa kiiboodhka gaaban si aad u hagaajisid tiirarka Excel .

Kaliya taabo ALT + H ka dibna tabo O ka dibna I. Waad sii dayn kartaa ALT iyo H marka aad riixdo. Markaa isku darka furaha buuxa waa ALT + H + O + I I.

Si ka duwan ballaadhka tiirka, Excel si toos ah ayuu u hagaajiyaa dhererka safka si uu u dajiyo dhererka qoraalka ee qaada booska ugu toosan ee saf kasta.

Sidaa darteed, qaabka AutoFit Row Height Height^{(AutoFit Row Height)} ee laga helay badhanka Qaabka^(Format) maaha mid faa'iido leh sida muujinta Ballaadhka Column AutoFit^{(AutoFit Column Width)} .

Marka xogta lagu dhejiyo xaashida shaqada ee Excel , waxaa jira waqtiyo marka safafka sare uusan si toos ah u hagaajin. Marka ay tani dhacdo, qoraalka waa la jarayaa halkii uu ku daadan lahaa saf kale oo ka sarreeya ama ka hooseeya.

Si taas loo hagaajiyo, dooro safka qoraalka la jaray oo guji Format > AutoFit Row Height . Tani waxay ku qasbi doontaa Excel inuu beddelo dhererka safka si uu u waafajiyo qoraalka dheer ee aan caadiga ahayn.

Safafka, waxaad isticmaali kartaa kombuyuutar gaaban oo la mid ah ALT + H + O + A si aad u toosiso dhererka safafka.

Adigoo isticmaalaya qaabka AutoFit ee Excel waxaad si toos ah u bedeli kartaa ballaca tiirarka iyo joogga safafka xaashida shaqada si aad u dejiso qoraalka cabbirka kala duwan adigoon gacanta ku beddelin qiimaha ballaca iyo dhererka.

Badbaadiyaha wakhtiga dhabta ah, sifada AutoFit^(AutoFit) waxay sidoo kale ka dhigi kartaa xogta ku jirta xaashida shaqada mid sahlan in la galo oo la akhriyo. Ku raaxayso!

AutoFit Column Widths and Row Heights in Excel

Excel’s grid-like appearance can seеm static at times without the possibility of creating cuѕtomized interfaces to match the needs of the data stored in a worksheet.

Although this is true to some extent, Microsoft has built into Excel the ability to instantly customize column widths and row heights to match the size of the data in the cells.

Learn how to use Excel’s AutoFit feature to automatically change the size of columns and rows to the size of the data in a worksheet.

Before You Change Column Widths and Row Heights in Excel

There are limits to how big and small you can make columns and rows in Excel. Column widths and row heights with a value of zero are hidden in an Excel worksheet. This is the equivalent to using the hide column or hide row feature.

Columns can have a maximum width of 255. This number represents the maximum number of characters a column can hold at the standard font size.

Changing the font, the font size, and adding other characteristics to the font such as italics and bolding greatly reduce the maximum number of characters a column can hold. The default size of an Excel column is 8.43, which correlates to 64 pixels.

Rows can have a maximum height of 409. This number represents the how many 1/72nds of an inch the row can hold. The default size of an Excel row is 15, which correlates to 20 pixels or about 1/5th of an inch.

Using Excel’s AutoFit Feature

Suppose in your Excel worksheet you have text in the A1 cell that extends beyond the 8.43 (64 pixels) default column width. Notice that although the column’s width cannot contain the length of the text, Excel allows the text to spill over into adjacent columns.

Select Column A, click on the Home tab on the Ribbon, and locate a section of the Ribbon almost all the way to the right labeled Cells.

Click on the button titled Format and locate a section of the menu labeled Cell Size. Notice that there are three options for changing the width of a column.

Column Width – This option lets you manually change the width of a column by typing in a number. This option isn’t useful because you can more easily accomplish the same thing by simply dragging the column to your desired size.

AutoFit Column Width – This is the option we want. This option will change the size of the column to a new size depending on the length of the contents of the cell in the column that takes up the most space.

Default Width – This option doesn’t actually change the width of any columns; it simply changes the default width of the columns for a particular worksheet.

On the Format button’s menu, select AutoFit Column Width and notice that the width of Column A has changed to contain the length of the text in the A1 cell.

Note that you can also autofit a column by simply selecting the column or columns and then double-clicking on the right-hand boundary of any selected column.

If you want to reset all column widths back to the default width, just select Format – Default Width and type in 8.43. You can also use a keyboard shortcut to autofit columns in Excel.

Just press ALT + H and then press O and then I. You can let go ALT and H once you have pressed them. So the full key combination is ALT + H + O + I.

Unlike column widths, Excel automatically adjusts the height of a row to accommodate the height of the text that takes up the most vertical space in each row.

Therefore, the AutoFit Row Height feature found on the Format button is not as useful as the AutoFit Column Width feature.

When pasting data into an Excel worksheet, there are times when the row heights do not adjust automatically. When this happens, text will be cut off rather than spill over into another row either above or below.

To fix this, select the row with the cut-off text and click on Format > AutoFit Row Height. This will force Excel to change the height of the row to accommodate the unusually tall text.

For rows, you can use a very similar keyboard shortcut of ALT + H + O + A to autofit row heights.

Using Excel’s AutoFit feature you can automatically change the width of columns and the height of rows in a worksheet to accommodate different sized text without having to manually change the width and height values.

A real time saver, the AutoFit feature can also make data in your worksheet easier to access and read. Enjoy!

Related posts

• Kudar Khadka Dib-u-Celinta Toosan ee Qorshaha Kala firdhisan ee Excel

• Sida loo sameeyo Histogram gudaha Excel

• Sida loo xafido erayga sirta ah ee Excel File

• Sida Loo Sameeyo Jadwalka socodka gudaha Word iyo Excel

• Sida Loo Sameeyo Calaamadaha Erayga laga bilaabo xaashida faafinta ee Excel

• Geli xaashida shaqada ee Excel Word Doc

• Isku xidh Unugyada u dhexeeya Xaashiyaha iyo Buugaagta Shaqada ee Excel

• Sida Looga Daro Baararka Cilada ee Excel

• Hagaha Dhammaan Kordhinta Faylka Excel & Waxa ay ula jeedaan

• Sida loola socdo isbedelada Excel

• Sida loo Furo Tusaalooyin Badan oo Excel ah

• 40 ka ugu wanaagsan ee Keyboard-ka Microsoft Excel

• 13 Tabaha OneNote & Tabaha loogu Abaabulayo Qoraaladaada si ka Wanagsan

• Sida loo barbar dhigo labada faylal ee Excel oo loo muujiyo faraqa u dhexeeya

• Isticmaal Hawlaha Kooban si aad u soo koobto Xogta ku jirta Excel

• Sida Si Toos ah Loogu Soo Kabto Dukumeenti Word OneDrive

• Sida Loo Isticmaalo Shaqada YEARFRAC gudaha Excel

• Sida loogu daro faallooyinka unugga Xaashida shaqada ee Excel

• Casharrada Aasaasiga ah ee Microsoft Excel - Barashada Sida loo Isticmaalo Excel

• Sida loo isticmaalo Excel AutoRecover iyo AutoBackup Features