Ctrl+0(Zero) Excel Shortcut Key To Hide The Selected Column | ExcelTip2Day


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 my today's article, it consists of how to use the shortcut keys to hide the selected column in an Excel sheet.

The first part, I'll describe to you why you have to use the shortcut keys as I have mentioned above.

Sometimes, when you operate on an Excel worksheet if you 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.

Here is the table of the shortcut key buttons to proceed to hide the column.

Shortcut for: Hide the selected column.

Windows shortcut


Ctrl0(Zero)


Now, I'll tell you the step by step of using the shortcut key buttons.

👉 Use your mouse click into any cell of the column you want to hide.

👉 Press the Ctrl+0 key buttons at the same time.

👉 Release your fingers out of the buttons.

See the snapshot below which are showing how to operate it.


Figure no.1 shows the cell Column C before getting hidden.

Figure no.2 shows the cell Column C after getting hidden


That brings me to the end of my posting.

So, from now on, if you would like to hide any column in your Excel sheet, you know to use the shortest way to handle your task quicker than the regular method.



Tip Answer

 a. It's both Ctrl+;

 b. It's both Ctrl+:

 c. It's both Ctrl+-


Link recommended👉 : Shortcut Keys How To Fixing Monitor Screen Accidentally 'Upside Down'

Link recommended👉 : English Numbers In Words 1 to 1000000

Before I am about to say goodbye to you, I hope that what I have posted and shared with you today. They will be beneficial for you, your company, and any relevant.

If you like our post, we are happy to learn that.

Well, if you think this article is useful for the other, please share this with them, then I will smile widely for your expanding this Excel tip and shortcut post.

I hope to receive any feedback from you guys. Because they will be such treasures--any error in this blog--for future improvement.

Thanks for reading.

Bye,

Posted by: Michael Leng



I've known, then I've grown. See more articles:

Ctrl+; Shortcut Excel To Insert The Current Date In Any Cell Of A Worksheet | ExcelTip2Day


Hello there.

I'm Michael Leng. Today, in my blog "Exceltip2day", I'm going to talk about:

Ctrl + ; To Insert The Current Date.


Simply use the Ctrl + ; Shortcut Excel To Insert The Current Date. Find the great instruction with full details about Excel tips, shortcuts, trick and solving methods Excel tip, how to fix,
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 the 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)


Ctrl + ; Shortcut Excel To Insert The Current Date in any cell you want.
Figure no.2 Shown the result of the current date.

** To correct the mistaken words in the figure no.2 from "C4" to "B4"


Shortcut for: Insert the current date.

Windows shortcut


Ctrl  ;


***

Now, you can check the answer for the tip quiz right below;


Tip Answer


 a. It's Ctrl + -

 b. It's Ctrl + :

 c. It's Ctrl + ;



Source: Little Known Ways: Simply Deleting Cell(s) in Excel Worksheet
Link recommended👉 : Shortcut Keys How To Fixing Monitor Screen Accidentally 'Upside Down'

Link recommended👉 : English Numbers In Words 1 to 1000000


That brings me to the end of my posting.

Before I am about to say goodbye to you, I hope that what I have posted and shared with you today. They will be beneficial for you, your company, and any relevant.

If you love it, I will be happy. If you share this with your friends, I will be shiny.

I hope to receive any feedback from you guys. Because they will be such treasures--any error in this blog--for future improvement.

Thanks for reading.

Bye,

Posted by: Michael Leng



I've known, then I've grown.

Ctrl+'(apostrophe) To Fill Cell Formulas Down From The Adjacent Cell Above | Exceltip2day


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)


Ctrl + ' (apostrophe) To Fill Cell Formulas Down From The Adjacent Cell Above | ExcelTip2Day  ExcelTip2Day-Shortcut, Trick and Solving Methods Excel tip, how to fix, shortcuts, how to handle Excel problem by yourself
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.


How to use Ctrl + ' (apostrophe) To Fill Cell Formulas Down From The Adjacent Cell Above | ExcelTip2Day  ExcelTip2Day-Shortcut, Trick and Solving Methods Excel tip, how to fix, shortcuts
Figure no.2 Show how to use the shortcut key Ctrl + ' in the cell B3

👉 In this last step, take a notice in the cell B3. You will see the formula which is as the same as the cell B2.


Show you step by step how to use Ctrl + ' (apostrophe) To Fill Cell Formulas Down From The Adjacent Cell Above | ExcelTip2Day  ExcelTip2Day-Shortcut, Trick and Solving Methods Excel tip, how to fix, shortcuts
Figure no.3 Show the result of the same formulas as the above cell.



Tip Answer

 a. It uses the keys Ctrl+B.

 b. It uses the keys Ctrl+A.

 c. It uses the keys Ctrl+C.


Link recommended👉 : Shortcut Keys How To Fixing Monitor Screen Accidentally 'Upside Down'

Link recommended👉 : English Numbers In Words 1 to 1000000


That brings me to the end of my posting.

Before I am about to say goodbye to you, I hope that what I have posted and shared with you today. They will be beneficial for you, your company, and any relevant.

If you love it, I will be happy. If you share this with your friends, I will be shiny.

I hope to receive any feedback from you guys. Because they will be such treasures--any error in this blog--for future improvement.

Does it help?

Thanks for reading.

Bye,

Posted by: Michael Leng



I've known, then I've grown.
See more articles:

4 Aspects Deleting: How To Use Keyboard Shortcut Ctrl+-(Minus) For Deleting Cell, Row, Column | ExcelTip2Day


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?


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 beneficial about an Excel tip. Of course, I guess you have seen it already as it is in the prior paragraph above.

👉 2nd part: 

On the second part, now I will show you the shortcut excel keys to use for deleting cells, columns, and rows in 4 different purposes.

Windows shortcut 



Ctrl -


👉 3rd part:


Refer to the shortcut from the 2nd part, here I'll describe and also show you all 4 purposes of deleting works.

Figure number 1. This is the scenario figure that I have prepared for you to be understood them more easily.

It contains the 10 rows and 5 columns. In the mid, cell d5:d7, is the mark for future proceeding the "Ctrl" + "-".


Figure no. 1

Let' have a look the figure no.2 below, once I have pressed the "Ctrl" + "-" buttons, the square box " Delete?" will instantly show as you can see it in the image.

Then, I have selected the choice "Shift cells left"


Figure no. 2

The figure no. 3 shows us the result after I clicked on the "OK" button. The 3 cells from left columns move to replace the previous cells d3:d7.



Figure no. 3

Let's move to the figure no. 4. In this image, I have selected the round checkbox "Shift cells up".


Figure no. 4

The figure no. 5. You can see the result after I deleted by "Shif cells up". The figure explains it very well, right?


Figure no. 5

The figure no. 6 below shows us how to delete by the "Entire row".


Figure no. 6

What's the figure no. 7 tell us. Good job! The row no. 4-6 have gone.


Figure no. 7

This is the last deleting aspects. It's the "Entire column" delete.


Figure no. 8

Hooyah, the entire column no. 3 has been disappeared. And the meantime, all the columns from the left moved and replaced respectively.


Figure no. 9


👉 4th part:


The tip answer, this is for you to find your best choice. Also, you can check both its answer and data source.


Tip Answer

 a. Use the shortcut key " ALT" + "Select Object"


 b. Use the shortcut key "Ctrl" + "Select Object"...


 c. Use the shortcut key " Shift" + "Select Object".



Link recommended👉 : Shortcut Keys How To Fixing Monitor Screen Accidentally 'Upside Down'

Link recommended👉 : English Numbers In Words 1 to 1000000


Now, that's the end of my presentation.

Thanks for reading.

Bye,

Posted by: Michael Leng



I've known, then I've grown.
See more articles: