Mar kasta oo aad xirto feylka Microsoft Excel oo aad dib u furto, feylku, asal ahaan, wuxuu u boodaa unuga ugu dambeeya ee ay ku jiraan xog ama qaabeynta. Si kastaba ha ahaatee, haddii aadan jeclayn hab-dhaqankan caadiga ah, waxaad abuuri kartaa makro. Waxay si toos ah dib ugu habeyn doontaa unugii ugu dambeeyay ee faylka Excel^{(reset the last cell on an Excel file)} adiga. Eeg, sida loo sii wado.

Dib u deji unugii ugu dambeeyay xaashida shaqada ee Excel

Markaad dib u eegto faylkaaga Excel oo aad isku daydo inaad kaydiso, abka, marka lagu daro dib u eegis, sidoo kale wuxuu kaydiyaa qayb kasta oo ka kooban xog ama qaabaynta. Sidan oo kale, unug kasta oo madhan oo ka kooban habayn iyo been ka baxsan tirada unugyada ay ku jiraan xogta ayaa lagu dari karaa. Tani waxay keeni kartaa korodhka xajmiga faylka ee buugga shaqada. Waxa kale oo laga yaabaa inay keento bogag daabacan oo badan markaad daabacdo buuga shaqada. Si taas looga fogaado, dib u dabee unuggii ugu dambeeyay adiga oo u wareegaya Amarka Qaabaynta Unugyada Xad-dhaafka ah ee Nadiifinta^{(Clean Excess Cell Formatting)} , oo laga heli karo tab Excel 's Inquire .

1. Aad Faylka^(File)
2. Dooro Ikhtiyaarada^(Options) .
3. Dooro Add-ins .
4. Dooro COM Add-ins ee^(Manage) Maamulka
5. Hubi Weydiinta^(Inquire)
6. Under the Inquire tab, dooro Nadiifi Qaabaynta Unugyada Xad-dhaafka ah^{(Clean Excess Cell Formatting)} .

Aynu si faahfaahsan u aragno habka!

Tag faylka faylka^{(File )} ee ku yaal liiska Ribbon ee faylkaaga Excel .

Guji tab File si aad u aado Options (ka muuqda xagga hoose ee bar-dhinacyada).

Marka uu furmo daaqada Options Excel , dooro ^(Excel) Add-ins option in the sidebar.

Kadibna, dooro COM Add-ins ka maamul^(Manage) sanduuqa dhanka midig.

Ka raadi wax -is-dar- gelinta^(Inquire) , dooro ka dibna ku dhufo OK. Tabta Weydiinta^(Inquire) hadda waa in ay ka muuqataa ribbon.

Hadda, si aad uga saarto qaabka xad-dhaafka ah ee faylkaaga Excel ee hadda , u gudub tabka Weydii^(Inquire) oo dooro Nadiifinta Qaabaynta Unugyada Xad-dhaafka^{(Clean Excess Cell Formatting)} ah.

Marka qaabaynta xad dhaafka ah meesha laga saaro, dhagsii Haa si aad u badbaadiso isbedelada oo aad uga baxdo.

Waxaa lagu talinayaa in la abuuro nuqul ka mid ah faylka jira ka hor inta aan la samayn isbeddelada tan iyo, tiro aad u tiro yar oo kiisas ah ayaa la soo sheegay halkaas oo habka uu u horseeday korodhka cabbirka faylka, mana jirin hab lagu beddelo isbeddelka.

Akhri soo socda^{(Read next)} : Sidee lagu helaa isbeddelka boqolleyda ee Excel^{(How to find the percentage change in Excel)} ?

Waxaan rajeynayaa in tani ay caawisay.

How to locate and reset the last cell on an Excel worksheet

Whenever yоu close a Microsoft Excel file and re-open it, the file, by default, jumps to the last cell containing data or formatting. However, if you do not like this default behavior, you can create a macro. It will automatically reset the last cell on an Excel file for you. See, how to proceed with it.

Reset the last cell on an Excel worksheet

When you revise your Excel file and attempt to save it, the app, in addition to revisions, also saves any part containing data or formatting. As such, any empty cells containing formatting and lying outside the range of cells containing data may get included. This may result in an increase in the file size of the workbook. It may also result in more printed pages when you print the workbook. To avoid this, reset that last cell by switching to the Clean Excess Cell Formatting command, available on Excel’s Inquire tab.

1. Go to File
2. Select Options.
3. Choose Add-ins.
4. Select COM Add-ins in the Manage
5. Check Inquire
6. Under the Inquire tab, select Clean Excess Cell Formatting.

Let’s see the process in a bit of detail!

Go to the File tab on the Ribbon menu of your Excel file.

Click the File tab to go to Options (visible at the bottom of the sidebar).

When the Excel Options window opens, choose Add-ins option in the sidebar.

Then, select COM Add-ins from the Manage box on the right.

Look for the Inquire add-in, select it and then click OK. The Inquire tab should now be visible in the ribbon.

Now, to remove the excess formatting from your current Excel file, go to the Inquire tab and choose the Clean Excess Cell Formatting option.

Once excess formatting is removed, click Yes to save changes and exit.

It is advisable to create a backup copy of the existing file before making the changes since, quite a few numbers of cases have been reported where the process had led to an increase in the file size, and there was no way to undo the change.

Read next: How to find the percentage change in Excel?

Hope this helped.

Related posts

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

• Sida loo tiriyo lambarka Haa ama Maya ee Excel

• Excel, Word ama PowerPoint ma bilaabi karaan markii ugu dambeysay

• Sida loo isticmaalo sifada Nooca Xogta tooska ah ee Excel

• Microsoft Excel waxay isku dayaysaa inay soo ceshato macluumaadkaaga

• Sida loo isticmaalo Muddada Dhaqaale Function gudaha Excel

• Sida loo geliyo shaxda firfircoon ee xaashida Excel

• Sida waqti loogu daro ama loogu daro Microsoft Excel

• Sida loo abuuro oo loo isticmaalo Koontaroolada Foomka gudaha Excel

• Sida loo midoobo oo loo kala saaro unugyada Excel

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

• Sida loo isticmaalo EDATE iyo EOMONTH Functions gudaha Excel

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

• Sida loo isticmaalo DCOUNT iyo DCOUNTA Function gudaha Excel

• Sida loo xidho unugyada qaacidada Excel si loo ilaaliyo

• Sida loo abuuro Bracket tartanka gudaha Windows 11/10

• Sida loo abuuro Shaxda Radar gudaha Windows 11/10

• Sida loo dayactiro buug-shaqeedka Excel ee xumaaday

• Sida loo qaybiyo hal tiir oo loo kala qaybiyo tiirar badan oo Excel ah