Learn New Things: How to Clear Excel Sheet Text Format, Underline, Color, Hyperlink, Comments

How to Clear Excel Sheet Text Format,Underline,Color,Hyperlink,Comments,how to clear text in excel,clear hyperlink,excel sheet clear format,text format,clear Hyperlink,remove colour,remove formatting,underlines,comments,remove all formatting of text,excel text format,copy & paste webiste,internet data clear format,cell,row,columns,how to clear text formatting,remove format from text,image,data,excel worksheet text format remove Clear All text format from Excel sheet, this method will work all the version for Microsoft Excel like, 2007, 2010, 2013 and 2016. Click here for more detail..

When we copy paste text or data from internet website or other apps it comes with underline, colors, hyperlinks, comments, specially in excel this will really headache to remove formatting from text, so here I will show you how to remove all formats in Excel by single click.

1. Select entire excel sheet or required area

2. Click on “Home” and extend the “Clear” select “Clear Format”

3. If you still have some issue than clear the “comments”, “clear hyperlinks” or “remove hyperlinks”

Watch video tutorial… Please like, share & subscribe