How to clear cells in Excel? || How To Clear Cells in Microsoft Excel? || Why learn how to clear cells in Excel?

How To Clear Cells in Microsoft Excel

After you enter information in a cell, Microsoft Excel enables you to clear the data. You can choose to reduce the number of words only or remove the formatting, including the rows and columns on the spreadsheet. Learning how to delete the contents of a cell can help you refine the layout of a document and change the figures in a data set. In this article, we provide reasons for clearing cells on an Excel workbook and discuss ways to delete data on the workbook, including emptying the contents and deleting the formatting.

आपके द्वारा किसी कक्ष में जानकारी दर्ज करने के बाद, Microsoft Excel आपको डेटा साफ़ करने में सक्षम करता है. आप केवल शब्दों की संख्या कम करना या स्प्रेडशीट पर पंक्तियों और स्तंभों सहित स्वरूपण को हटाना चुन सकते हैं। कक्ष की सामग्री को हटाने का तरीका सीखने से आपको दस्तावेज़ का लेआउट परिशोधित करने और डेटा सेट में आंकड़े परिवर्तित करने में मदद मिल सकती है. इस आलेख में, हम किसी Excel कार्यपुस्तिका पर कक्षों को साफ़ करने के कारण प्रदान करते हैं और सामग्री को खाली करने और स्वरूपण हटाने सहित कार्यपुस्तिका पर डेटा हटाने के तरीकों पर चर्चा करते हैं.

-------------------------------------------------------------------------------------------------------------------------------

Why learn how to clear cells in Excel?

Learning how to clear cells in Microsoft Excel can be helpful if you wish to make major changes to the data on your spreadsheet. Here are some reasons you might use the clear feature that the program offers:

यदि आप अपनी स्प्रेडशीट के डेटा में बड़े बदलाव करना चाहते हैं तो Microsoft Excel में कोशिकाओं को साफ़ करना सीखना मददगार हो सकता है। यहां कुछ कारण दिए गए हैं कि आप प्रोग्राम द्वारा प्रदान की जाने वाली स्पष्ट सुविधा का उपयोग कर सकते हैं:

How to clear cells in Excel

Clearing cells on an Excel document means erasing the characters you typed inside, but the actual cell remains on the spreadsheet. Follow these steps to complete the task:

Excel दस्तावेज़ पर कक्षों को साफ़ करने का अर्थ है आपके द्वारा अंदर लिखे गए वर्णों को मिटाना, लेकिन वास्तविक कक्ष स्प्रेडशीट पर बना रहता है. कार्य को पूरा करने के लिए इन चरणों का पालन करें:

1. Open an Excel workbook

On your computer, look for an Excel workbook that you want to edit. After clicking on the program from your desktop, you can access the "File" tab, press "Open" and select the "Recent" tab to find documents you've edited the last time you used Excel. If you don't see your desired file on the list, press the "Browse" button at the bottom of the menu. You can see a dialog window that shows all the documents that are compatible with the program. Click on one of them to open it.

2. Find the area to clear

Review the contents of the spreadsheet to find the group of cells you want to clear. Click your cursor inside the cell and press and hold the mouse to select the adjoining cells. The highlight shows that you're applying the edits to this section, not to the rest of the document. Make sure you've included all the content you wish to erase to clear everything at once.

3. Locate the "Editing" section

Access the "Home" tab, which is visible in the ribbon at the top of the screen. On the far right of the menu, there's a section called "Editing." You can see a button that looks like a white eraser, which is the "Clear" option. Press the small arrow next to the icon to trigger a list of ways to empty a cell.

Related:

4. Select an option to clear the cells

Study the items on the "Clear" drop-down menu to determine how you want to erase the contents of the cell range you selected. Here are your options:

"Clear Contents": You can delete only the words and numbers you typed in the cells, which is an alternative to using the "Backspace" or "Delete" buttons on your computer keyboard. Be mindful that clearing the content can also clear the value of the entry, which can interfere with any calculations you included in the workbook.
"Clear Formats": This option clears the formatting you applied to the cell range, but the entries remain. For example, if you typed a percentage in a cell and applied a border, pressing "Clear Formats" deletes the border, but not the percentage.
"Clear Comments": If you've attached comments to a group of cells on the document, you can erase them by tapping this item. It maintains the contents and formatting of the cell.
"Clear Hyperlinks": If you've linked to websites on your spreadsheet, this option makes the link inactive, but you can still see the words for the URL. For instance, janedoe@email.com may not be clickable, but "janedoe@email.com" is visible inside the cell.
"Clear All": This option deletes everything in the cell, including the numbers and words you entered, the comments you left and the formatting you applied. You can clear the cell entirely if you wish to reset the content of your spreadsheet.