Showing posts with label clear. Show all posts
Showing posts with label clear. Show all posts

Monday, March 14, 2016

Excel Tip: Clear / Unfilter FILTERs Quickly

In Order to Clear / Unfilter a filter quickly you can use the Filter Hotkey Two Times :

Press 2 Times : CTRL + SHIFT + L 






Created by DoMyExcel.com © | Excel & VBA Consulting | Customized Excel Solutions starting at 29 USD
Services provided to Individuals and Businesses | Free Quote: DoMyExcel@gmail.com
 Do My Excel Webpage

Monday, February 22, 2016

How to remove the hyperlinks from selected range in EXCEL

There is a built in function in EXCEL to remove the hyperlinks: Select the designated area and go to "Home" ribbon > "Clear" dropdown menu > and press "Clear Hyperlinks" :
 
 
 
Created by DoMyExcel.com © | Excel & VBA Consulting | Customized Excel Solutions starting at 29 USD
Services provided to Individuals and Businesses | Free Quote: DoMyExcel@gmail.com
www.domyexcel.com