Thank you. That explains a lot. Frankly speaking, I see Quora as a notepad for my future articles. If you have gone through my answers you may have noticed that most of them are all comprehensive. At the

hi @paulag, it is my own answer/article. From your reply, I understand that the already published Article/Answer should be shared along with links.

Thanks for sharing the link, @cheetah. That's my answer in Quora. I have written more than 400 answers in Quora, 99% of them related to Excel.

ComputerGaga is here :)

Glad that you like it. Actually I wrote it for the community. But missed the option to post it there. I will go with your explanation from next time :)

Another quick way to Navigate through sheets is by using Excel Name Box. To select a cell in another sheet from the active sheet, Type in the SheetName and Cell reference in the Excel Name box and press

Today, I completed 400 Answers in Quora, on different topics of Excel.

Glad to hear that. and I am excited about the development of this community.

If your data is supposed to change you should go for an Array formula using TRANSPOSE function. The array formula for the example shown in the screenshot is {=TRANSPOSE(B3:C14)} Now about how to enter

Excited!