Hello there.
I'm Michael Leng. Today, in my blog "Exceltip2day", I'm going to talk about how to use the keyboard shortcut of:
Ctrl + A
Tip Quiz
What is the shortcut to edit active cell and positions the insertion point at the end of the data entered?
Have you ever known or used this trick of keyboard shortcut keys for selecting the cells in the same range of Excel spreadsheet before?
First, to explore what it is inside Excel spreadsheet/worksheet together. The number of columns in Excel version 2007 and 2010 has the same amount at 16,384, which is column A : XFD.
In addition, in a spreadsheet/worksheet makes 17,179,869,184 cells each.
First, to explore what it is inside Excel spreadsheet/worksheet together. The number of columns in Excel version 2007 and 2010 has the same amount at 16,384, which is column A : XFD.
In addition, in a spreadsheet/worksheet makes 17,179,869,184 cells each.
Therefore, imagine that how hard it is to select all active cells in an Excel spreadsheet that containing the data entered or even empty cells, which are connected to the other cells in the same range as well. The entire cells with data entered and adjacent empty cells.
Right here at the below method. Now everybody will know and discover the letter keys in a keyboard for performing the shortcut way selecting the completely active cells having data entered into them and their borders adjacent one another in Excel spreadsheet(worksheet).
Just use the two letter keys are "Ctrl" and "A" buttons to do shortcut as the method below.
Method:
Tip Answer
Additional:
This will help you to save time for selecting all the data in the whole sheet you have been working on it. Continuously if you want to select all cells in the whole sheet, just press the Ctrl and A buttons again.
You can also apply this shortcut to use in another program like MS Word, Blog, Powerpoint, etc.
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 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.
See more articles:
Right here at the below method. Now everybody will know and discover the letter keys in a keyboard for performing the shortcut way selecting the completely active cells having data entered into them and their borders adjacent one another in Excel spreadsheet(worksheet).
Just use the two letter keys are "Ctrl" and "A" buttons to do shortcut as the method below.
Method:
- Click mouse onto any cell that is within the range.
- Press the "Ctrl" button and hold it.
- Again, press the "A" button while still keeping the"Ctrl" button down.
- Then, release the two buttons.
Shortcut for: Select the current region around the active cell.
Windows shortcut
Ctrl A
Tip Answer
Additional:
This will help you to save time for selecting all the data in the whole sheet you have been working on it. Continuously if you want to select all cells in the whole sheet, just press the Ctrl and A buttons again.
You can also apply this shortcut to use in another program like MS Word, Blog, Powerpoint, etc.
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 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.
See more articles:
Thanks so much. It's very good article that you have written and shared with. It's clear and understandble to follow your tips.
ReplyDelete