The way Microsoft has developed excel always makes me speechless. Though I am QA by professional, but I always wanted to thank MS Office developer to make such a great piece of art. With every exploration I am being left speechless.
Today though I discovered very small piece of knowledge, what amazed me was the thought process of the people who work for the betterment of the customer. Thinking as in customer and coming up with smaller smaller idea-tic enhancements after reaching that far is really what I like most in MS Office team. Kudoos to whole team.
Discovery of the day!!
Was going through the test data in excel sheet, where I noticed that first row gets merged in the header as I scroll the data. It left me to restless curious situation.. exploring, exploring and exploring... HOW?... and here I go...
Excel has a feature where in when you convert your data to table form (selecting that you have header provided in the data) sets your header visible throughout the table scrolling. If you scroll while your focus is not on the table area you won't get the table header replaced with column header in excel. Let's move it diagrammatically..
Header merge with the column header when focus is on table area.
Header do not merge with column header when focus is on non-table area.
That's All Folk!!
Today though I discovered very small piece of knowledge, what amazed me was the thought process of the people who work for the betterment of the customer. Thinking as in customer and coming up with smaller smaller idea-tic enhancements after reaching that far is really what I like most in MS Office team. Kudoos to whole team.
Discovery of the day!!
Was going through the test data in excel sheet, where I noticed that first row gets merged in the header as I scroll the data. It left me to restless curious situation.. exploring, exploring and exploring... HOW?... and here I go...
Excel has a feature where in when you convert your data to table form (selecting that you have header provided in the data) sets your header visible throughout the table scrolling. If you scroll while your focus is not on the table area you won't get the table header replaced with column header in excel. Let's move it diagrammatically..
Header merge with the column header when focus is on table area.
Header do not merge with column header when focus is on non-table area.
That's All Folk!!

