Results 1 to 5 of 5
  1. #1
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Watch your P's and Q's (All)

    Actually, just watch your Q's when you autofill:

    I was very amused today when a colleague showed me some strangeness about autofill. As most of you know when you autofill text with a number suffix, Excel increments the number. For example if you enter P2 into a cell, select the cell, and drag the lower-right corner, then you will see popup for P3, P4,P5... and when you release the mouse, these values appear in the cells. BUT, try this with say, Q3, and a seemingly bizzar fill occurs: Q3, Q4, Q1, Q2, Q3, Q4, Q1.... At first I laughed that Microsoft coud make such a stupid mistake. But then, after a simple Google search (left as an exercise for the reader) revealed that this was by design I was <img src=/S/rofl.gif border=0 alt=rofl width=15 height=15> that Microsoft would make such a stupid design decision. Now, I'm wondering (for my soon to be published Encyclopedia of Usless Excel Information) if they changed the letter for different language versions of Excel? For example, in the Dutch edition does T<span style="background-color: #FFFF00; color: #FFFF00; font-weight: bold">rimester</span hide> autofill as T1, T2, T3, T4, T1, T2,...?
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Watch your P's and Q's (All)

    No, in Dutch it is the K for <span style="background-color: #FFFF00; color: #FFFF00; font-weight: bold">Kwartaal</span hide>.

  3. #3
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Watch your P's and Q's (All)

    You may think that's a stupid design decision - I, on the other hand, find it extremely useful! <img src=/S/yep.gif border=0 alt=yep width=15 height=15>
    Regards,
    Rory

    Microsoft MVP - Excel

  4. #4
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Watch your P's and Q's (All)

    Sam - given M$' (original) target market and the "raging popularity" of Q as an English Language Prefix, I would suggest they made a smart design decision. Now, if we were talking Unix, I would agree with you......

    BTW the French interface does a Trimester autofill as T1, T2, T3, T4, T1, T2,.... (Q acts the same as P does in English.) German is the same as English (presumably for Quartal). I don't have any other languages installed.

    HTH
    Gre

  5. #5
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts

    Re: Watch your P's and Q's (All)

    Sammy,

    I'm with Rory - I think having 4 quarters for business applications that span multiple years is useful. That's what I use it for. But I can see a benefit if you wanted to number rows q1 to, say, q20 for 20 questions that might be useful to do it differently

    But if you want to fill q5, q6, etc, starting the list with 2 items like q4 and q5 tells Excel that the "quarterly" assumption is off. Likewise, you could do something like ="q" & (ROW()-n) where n is a number to change the numeric part of q depending on your starting row. These will fill properly without wrapping after 4.

    Fred

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •