Excel Deselect Cells/All

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

Capture




Pic 2

Capture

To deselect all without changing the active cell, press keyboard shortcut Shift+Backspace

Hope this helped.

Share The Knowledge

Random Posts

  • VBA To Open Latest Excel Workbook

    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

    Share The Knowledge
  • Create A Horizontal Scrolling Table In Excel

    Let’s understand how to create a horizontal scrolling table in excel as shown below. The data that is used to […]

    Share The Knowledge
  • Insert File Extension In File Name In Excel

    In this post we will see how we could insert a file extension like .txt,.xlsx,.pdf etc in a file name […]

    Share The Knowledge
  • Unit Conversion In Excel

    Let’s see how to do unit conversion in excel. We will see how we could leverage a simple convert function […]

    Share The Knowledge

Leave a Reply