Hello there.
I'm Michael Leng. Today, in my blog "Exceltip2day", I'm going to talk about how to use what the shortcut key to get your cursor to the first cell in the same line. They are as below:
"Ctrl" + "Home"
Don't leave us if you use Excel office in your working life!Well, what you may know the Ctrl and Home button on your desktop/laptop/tablet/mobile phone and many more devices. But today, we are going to learn the "Home" key button in program Microsoft Excel Office software.
It can do more for the unexpected useful functions that you might have never known before.
I am glad to tell you what it, "Home Button", is able to ease the difficulty of your Excel office jobs. What and where to use the letter key shortcut button as I have mentioned previously.
Tip Quiz
Do you know the shortcut for how to copy and paste the entry data?
The two main shortcut ways are defined as below:
1] To move the cursor from the cell in a row that the cursor is occupied to the farthest left cell at the end of the same row in an Excel worksheet.
Figure no.1 How to use the shortcut to go to the first cell on the same line. |
2] Move the cursor from the currently active cell data entry that the cursor is blinking inside to the beginning data entry in the same cell in a worksheet.
Figure no.2 How to use the shortcut to go to the first letter in the same line. |
These are all the two shortcut tips of "Ctrl" + "Home" letter key. If you use the Microsoft Excel Office Program in your office as a routine job. Do not forget to use these shortcut methods to help you get your job done faster than it used to be.
After you press the shortcut button, then you can apply data validation to the cell that is already activated.
Hereafter the sum up in the table for more understanding easily.
Shortcut for:
➮ Move to the beginning of a "ROW" in a worksheet.
➮ Move to the beginning of a "CELL DATA ENTRY"[Inside a cell].
Windows shortcut
CtrlHome
Tip Answer
Link recommendedπ : Shortcut Keys How To Fixing Monitor Screen Accidentally 'Upside Down'
Link recommendedπ : English Numbers In Words 1 to 1000000
Thanks for reading.
Bye,
Posted by: Michael Leng
I've known, then I've grown.
See more articles:
Nice Blog Post !
ReplyDelete