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

Hello there. I'm Michael Leng. Today, in my blog "Exceltip2day" , I'm going to talk about the shortcut keys: Ctrl+0(Zero) to hide the column. Tip: Quiz Do you know what is the shortcut key to insert the current date in any cell of a worksheet? In this article, it consists of how to use the shortcut keys to hide the selected column in an Excel sheet. Tab:  Learn Pure Thai FB Tab:  E n  Numbers In Words In the first part, I'll describe to you why I have to use the shortcut keys as I have mentioned above. Sometimes, when we operate on an Excel worksheet if we want to hide any column in order not to see any data in them or to shrink them, whereas getting more the other columns to come to appear in your window monitor. Here is the table of the shortcut key buttons to proceed to hide the column. Shortcut for:  Hide the selected column. Windows shortcut Ctrl 0(Zero) Now, I'll tell you the step by step of using the shortcut key buttons.

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

Hello there! I'm Michael Leng. Today, in my blog "Exceltip2day" , I'm going to talk about: How to use " Ctrl " + " - "(Minus) Tip Quiz How to delete all the objects in an Excel worksheet? (Check answer at the end of this post) In my article today, I'm going to show you how to use the shortcut key and its 4 deleted options for Excel users to select according to his/her aspects. All the 4 options are as following; Delete "Shift cell left" Delete "Shift cell up" Delete "Entire row" Delete "Entire column" Notify: Please use it with care, it may cause your related data, such as formulas, table,  border... In case of wanting to resume your last action, you can  redo  ( Ctrl + Y ) and undo  ( Ctrl + Z ) to fix it. My article consists of 4 parts. 👉  1st part:  In the first part, you will see the "Tip Quiz" box questioning the benefits of an Excel tip. Of course, I