Submit a question to our community and get an answer from real people.

In excel if the range data is Qtr1, Qtr2, what will be the result if you drag the fill handle over one more cell

Report as

It depends on your platform- but Excel tries to 'guess' what you are trying to do. I just tried this on both a Mac (using Excel 2011 for mac) and on a PC (using MS Excel 2010) and both understood this to be quarters so as i dragged, it completed the list as Qtr3, Qtr4, Qtr1, Qtr2, etc...

Helpful Fun Thanks for voting Comments (0)
Report as
Add a comment...
Do you have an answer?
Answer this question...
Did you mean?
Login or Join the Community to answer