Скачать или смотреть How to use clear option in excel ?

Clear option has multiple uses in Excel. Clear content, Clear formats, Clear comments, Clear hyperlink, Remove hyperlink and Clear All.

In Excel, if you copy some data from other file format and paste to a worksheet, then split the data by Text to Column function, then in next time when you paste data with a similar type to worksheet, the data will be automatically split to columns. Sometimes, you want to prevent the data being split. Here I will tell you how to stop the auto text to column in Excel.

For Excel VBA, please check the below Playlist,

   • Excel VBA  

For If function and its uses, please check the below play list,

   • If function  

Please check other basic videos in our channel. Please like, comment and subscribe to the channel.