Technical Tip To Select Or Copy Data Entered Between Range Of The Particular Cells And Uppermost Cell (A1) | Exceltip2day
Hello there.
I'm Michael Leng. Today, in my blog "Exceltip2day", I'm going to talk about:
How to select the cells range
Tip Quiz
What is the shortcut to minimize an Excel workbook?
Eventually, I found the ideal way to copy or select the desired group of cells as follow:
As per the screenshot for an example to show, you right here. Suppose to select and/or copy the wanted cells, which begins from the cell “E13” and the cell “A1”. Including all cells in the range to the upward, cell “E1”, and to the leftward, cell “A13”
1] Hover your mouse to cell "E13" and "Click" on it. (In yellow)
2] Press "Ctrl" "Shift" "Home" buttons at the same time together.
Get Done! Now, you can do whatever as you desire such copy, delete, format,...
Tip Answer
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 spending your time with us.
Thanks for your share with. It's the cool one.
ReplyDelete