@@PercentTutorial Windows 11 Exterprise. After selection of blank rows, I have entered '=' symbol in formual bar and selected the below active cell as you shown but got results upside down. I am glad that you have seen my comments and replied fast.
@@vamshimedishetty5624 You're welcome, I will be happy to solve your problem. I meant the office version. Please try what I am saying. After the cells are selected, just in the formula bar type =A1 (name of the cell in the top row, f.e in video I write C3) and then press Ctrl + Enter, mean don't click anywhere with the mouse.
@@PercentTutorial I have followed as you said and tried multiple times. Getting results in bottom to top but not top to bottom as you shown in video. I will try again. Thank you so much.
👌🏻
Transpose could also be dony by using transpose function
Excellent.
Thank for your hard work.
For first short cut, is it not possible to do it reverse order. ( merging all cell data into one).
Thank you for your nice comment
Exactly in which step of the first trick do you have a problem?
Ctrl + A / Ctrl + G / Special / Blank / in fromula bar = and then press Ctrl + Enter
I have tried but this first trick is not working for updated window version.
Which version do you have? 2021?
@@PercentTutorial
Windows 11 Exterprise.
After selection of blank rows, I have entered '=' symbol in formual bar and selected the below active cell as you shown but got results upside down.
I am glad that you have seen my comments and replied fast.
@@vamshimedishetty5624
You're welcome, I will be happy to solve your problem.
I meant the office version.
Please try what I am saying. After the cells are selected, just in the formula bar type =A1
(name of the cell in the top row, f.e in video I write C3) and then press Ctrl + Enter, mean don't click anywhere with the mouse.
@@PercentTutorial
I have followed as you said and tried multiple times. Getting results in bottom to top but not top to bottom as you shown in video. I will try again.
Thank you so much.
Could you share the Microsoft shortcut URL.