This post demonstrates how to deselect all the cells without changing the active cell in excel
The features is available in Excel 2016
Pic is showing the selected range with active cell as A1 and we want to deselect all and get back to the original state where A1is the active cell as show in pic 2
Pic 1
Pic 2
To deselect all without changing the active cell, press keyboard shortcut Shift+Backspace
Hope this helped.
vba to open latest excel workbook in a folder, how to open most recent file from a folder in excel vba, open latest file from folder in excel vba, open most recent workbook in excel, code to open the most recent file from a folder in vba
Let’s understand how to create a horizontal scrolling table in excel as shown below. The data that is used to […]
In this post we will see how we could insert a file extension like .txt,.xlsx,.pdf etc in a file name […]
