Excel Tips, Tricks, and Shortcuts

Hello there. I'm Michael Leng. Today, in my blog "Exceltip2day" , I'm going to tell you how to use the shortcut keys: Shift + Space bar Let's see more details below. Tip Quiz Do you know the shortcut key to edit active cell instantly? Do you know what to do if you need to select the whole cells in a row? There are two ways to operate as I am going to tell you now below: 👉   1] To click on the number of any row to be selected. For example, if we want to select the row no. 5, therefore, hover your mouse over, which are you wanting to and click on it such as the row no. 5 as shown you as the image below. Figure no.1 Show how to click on a row no.5 Addition:  If you would like to select for multiple rows. You can move your mouse cursor to click on any number of rows at the farthest left hand as much as you want. For example, if you want to select the row no. "1" to no. "19", move the mouse cursor and click...