⌨️ 𝔼𝕩𝕔𝕖𝕝 𝕋𝕚𝕡𝕤 𝕋𝕣𝕚𝕔𝕜𝕤 𝕒𝕟𝕕 𝕊𝕙𝕠𝕣𝕥𝕔𝕦𝕥𝕤

Hello there. I'm Michael Leng. Today, in my blog "Exceltip2day" , I'm going to talk about: Ctrl + ; To Insert The Current Date. Figure no.1 Shown how to proceed with the shortcut key "Ctrl" + " ; " Tip Quiz What is the shortcut to delete cell(s) in Excel Worksheet? Yes, it's not complicated at all if you are trying to insert the current date into any cell in an Excel worksheet. Just follow the step by step Keyboard Excel and Shortcut key as below: In the cell B4, just press and hold down the " Ctrl " key button. While holding, pressing the other key, it's the " ;  " button. Then the cell B4 will turn out the result of the current date as shown as figure no. 2 as below. (The date 25/8/2018 is the date that I have input the formula and prepared it for adding onto this post) Figure no.2 Shown the result of the current date. ** To correct the mistaken words in the figure no.2 from " C4 "

Hello there. I'm Michael Leng. Today, in my blog "Exceltip2day" , I'm going to talk about: Ctrl + ' (apostrophe) Tip Quiz What is the shortcut key to select the entire worksheet or the data-containing area? In Excel worksheet, if you have filled some formulas into a cell. And if you want to use those formulas again, but for the cell which is beneath them. You just only the 2 keys as the shortcut to operate it as the instruction as follows: Shortcut for:  To fill cell formulas down and edit. Windows shortcut Ctrl   ' To let you see more in the clear picture, take a look the figures describe all steps below: 👉   In the cell B2, it contains the formula syntax  " =1+1" (Take a look the figure no. 1) Figure no. 1 Show the formula = 1+1 in cell B2 👉  In this step, pay attention to the cell B3. For this step, just press the 2 keys Ctrl + ' into the cell B3 and move your fingers out of them. Figure no.2 S