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? One technical tip of Excel using of today that I want to share you all, it is the only private trick that I have tried many times to discover the simple way to copy the data entered between the range of particular cells and an uppermost cell (A1) . 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 to...