Clear Formatting, Contents, Comments & Hyperlinks in Microsoft Excel. First go on the Home tab, in the Editing group, click the arrow next to the Clear button , and then clear all contents, formats, and comments that are contained in the selected cells, click Clear All. To clear only the formats that are applied to the selected cells, click Clear Formats.
👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra
👉Some Helpful Videos of Excel
▶ Change Case of Text in Microsoft Excel - https://www.youtube.com/watch?v=H46Au...
▶ Excel VBA - Autofit Cell Content - https://www.youtube.com/watch?v=wr13w...
▶ Insert Picture into an Excel Cell - https://www.youtube.com/watch?v=BKzec...
▶ How to Apply, Create & Merge Cell Styles - Excel - https://www.youtube.com/watch?v=M8nwK...
▶ Filter or Copy Unique Records Only - Excel - https://www.youtube.com/watch?v=xrj6H...
▶ Data Validation #Dependent Drop Down Lists in Excel - https://www.youtube.com/watch?v=YOvFf...
▶ Excel Data Validation #Prevent Entries After Certain Amount - https://www.youtube.com/watch?v=MI5G1...
▶ Excel VBA #Change Font and Background Color of Cells - https://www.youtube.com/watch?v=lLFbK...
▶ Use of COUNTIF with Multiple Criteria - Excel - https://www.youtube.com/watch?v=TRTSH...
▶ Data Validation #Prevent Duplicate Entries in Excel - https://www.youtube.com/watch?v=Xa-8N...
▶ Copy Format with Auto Fill Handle in Excel - https://www.youtube.com/watch?v=u0_0d...
▶ Apply Superscript & Subscript in Excel - https://www.youtube.com/watch?v=FzxsN...
▶ Excel Conditional Formatting #Highlight a Cell with an Entry - https://www.youtube.com/watch?v=b27XW...
▶ Excel VBA Message Box #How to Create MsgBox - https://www.youtube.com/watch?v=HmwoG...
▶ How to Split Full Name to First and Last Name in Excel - https://www.youtube.com/watch?v=x8arT...
▶ How to Hide/Unhide Worksheet and Cell Contents in Excel - https://www.youtube.com/watch?v=cP3pA...
▶ Conditional Formatting #Apply Color on Every Other Row or Column - https://www.youtube.com/watch?v=iqXOp...
▶ Excel VBA #Select a Cell & Write Value into it - https://www.youtube.com/watch?v=q3IIh...
▶ Protect Different Ranges with Different Password in a Worksheet - https://www.youtube.com/watch?v=9vxG7...
▶ How to Hide and Protect Formulas - Excel - https://www.youtube.com/watch?v=QY736...
▶ Excel Conditional Formatting #Use of Isblank Function - https://www.youtube.com/watch?v=LK6oJ...
▶ Excel Conditional Formatting Based on Another Cell - https://www.youtube.com/watch?v=09sEq...
▶ Protect Selected Cells #Type on Specific Area - Excel - https://www.youtube.com/watch?v=dYz5v...
▶ Protect Data from Copying in Excel - https://www.youtube.com/watch?v=VILPc...
▶ Sort Data Horizontally in Excel - https://www.youtube.com/watch?v=oypnM...
▶ Shortcut Key for Data Validation Dialog Box in Excel - https://www.youtube.com/watch?v=onH6B...
▶ Tricks for Custom Number Format in Excel (Must watch) - https://www.youtube.com/watch?v=5iGF0...
▶ Fill Colors, Patterns and Gradients to Cells in Excel - https://www.youtube.com/watch?v=hiT0s...
▶ Shortcut for Custom Sort in Excel - https://www.youtube.com/watch?v=diHAk...
▶ Insert, Design and Remove a Table without losing Data in Excel - https://www.youtube.com/watch?v=MuW4p...
▶ Paste as a Picture Link in Excel 2010 - https://www.youtube.com/watch?v=nN_HF...
▶ Repeat Rows and Columns as Titles on Every Printed Pages in Excel - https://www.youtube.com/watch?v=BzBI0...
▶ How to Paste Horizontal to Vertical and Vertical to Horizontal in Excel - https://www.youtube.com/watch?v=B-Vm4...
▶ Freeze or Lock Row and Column Separately or Together in Excel - https://www.youtube.com/watch?v=orEj6...
▶ How to Apply or Remove Filter with Keyboard in Excel - https://www.youtube.com/watch?v=zfVh1...
Removing Cell Formatting in Excel | |
| 0 Likes | 0 Dislikes |
| 1,086 views views | 4,858 followers |
| How-to & Style | Upload TimePublished on 9 May 2016 |
No comments:
Post a Comment