Zack Barresse

My feedback

  1. 31 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)

      We’ll send you updates on this idea

      Zack Barresse supported this idea  · 
    • 253 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)

        We’ll send you updates on this idea

        Zack Barresse supported this idea  · 
        Zack Barresse commented  · 

        The problem goes much deeper than just sorting. Even inserting rows is impossible on a Table with sheet protection turned on. Good idea!

        Zack Barresse shared this idea  · 
      • 81 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)

          We’ll send you updates on this idea

          Good suggestion Frederic – thanks for taking the time to post it. We’ll take a look at the F4 loop and including other functionality like this as soon as we can. We’ll be spending more time on the things with more votes – so folks that really want to see this should keep voting it up.

          Best,
          John [MS XL]

          Zack Barresse supported this idea  · 
          Zack Barresse commented  · 

          Ditto to what Jan states. It's highly confusing with the different behaviors.

        • 14 votes
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)

            We’ll send you updates on this idea

            Zack Barresse commented  · 

            If we could customize the icons, as Ken mentioned, it would pretty much solve this problem too. :)

          • 23 votes
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)

              We’ll send you updates on this idea

              Zack Barresse commented  · 

              Charles Williams has something similar in FastExcel, titled AVLOOKUPNTH. This is similar to what I'm describing, but more like LOOKUPNTH.

              Zack Barresse shared this idea  · 
            • 7 votes
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)

                We’ll send you updates on this idea

              • 27 votes
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

                  Zack Barresse supported this idea  · 
                • 36 votes
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)

                    We’ll send you updates on this idea

                    Zack Barresse commented  · 

                    The arrows will only navigate the sheets, not actually make an activation. The elipses will actually make an activation on the next visible sheet on the far left/right.

                    You can also right-click the left/right arrows and get the activate sheet dialog box.

                    And I agree, I miss those buttons. :)

                  • 2 votes
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      Signed in as (Sign out)

                      We’ll send you updates on this idea

                      Zack Barresse commented  · 

                      Once the filter drop-down is activated, hit the E key to put your cursor in the search bar. :)

                      Check out Jon Acampora's blog post on it: http://www.excelcampus.com/keyboard-shortcuts/filter-dropdown-menu-shortcuts/

                    • 71 votes
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service
                        Signed in as (Sign out)

                        We’ll send you updates on this idea

                        This is an interesting idea. We will definitely consider it while planning our next round of features. Please continue to vote on this feature idea.

                        Thanks,
                        Scott [MSFT]

                        Zack Barresse commented  · 

                        This is something done quite often. We have to write code to do this currently, which is quite popular. Having this functionality natively would be used quite a bit I imagine. Good idea Rajender!

                      • 100 votes
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          Signed in as (Sign out)

                          We’ll send you updates on this idea

                          Zack Barresse commented  · 

                          I'd like to see it added to the Merge & Center split button. :)

                        • 3 votes
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            Signed in as (Sign out)

                            We’ll send you updates on this idea

                            Zack Barresse commented  · 

                            You can do this currently by defining a new Custom List. But yes, it would be nice. :)

                          • 9 votes
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service
                              Signed in as (Sign out)

                              We’ll send you updates on this idea

                              Zack Barresse commented  · 

                              You can do this programmatically now: http://www.rondebruin.nl/win/s2/win008.htm

                            • 140 votes
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service
                                Signed in as (Sign out)

                                We’ll send you updates on this idea

                                Thanks for the post Charles, and for the in person conversation at the latest MVP conference. We definitely understand the ask and will keep our eye on it – it looks like it’s moving up the vote charts pretty quickly. As always, keep upvoting the things you are about most.

                                Best,
                                John [MS XL]

                                Zack Barresse supported this idea  · 
                              • 16 votes
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service
                                  Signed in as (Sign out)

                                  We’ll send you updates on this idea

                                  3 comments  ·  Excel Online  ·  Flag idea as inappropriate…  ·  Admin →
                                  Zack Barresse commented  · 

                                  Should be using a Table. This problem never surfaces.

                                • 289 votes
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service
                                    Signed in as (Sign out)

                                    We’ll send you updates on this idea

                                    Hi Ken,

                                    Thanks for logging this one, and thanks to others for voting this up.. We’ve actually had this on our list to get to for some time and have been balancing doing this against other… The more the community helps us rank it higher, the better the signal on overall importance… so, for those that haven’t voted for this but want it, do vote!

                                    thanks
                                    ash [MS XL]

                                    Zack Barresse supported this idea  · 
                                  • 91 votes
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service
                                      Signed in as (Sign out)

                                      We’ll send you updates on this idea

                                      Thanks for the suggestion. I think I’ve seen some related requests, I’ll look at merging them to make sure the votes properly reflect the ask. We’ll prioritize this into the execution pipe appropriately based on the number of votes.

                                      Cheers,
                                      John [MS XL]

                                      Zack Barresse supported this idea  · 
                                    • 145 votes
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service
                                        Signed in as (Sign out)

                                        We’ll send you updates on this idea

                                        Thanks for the suggestion Nick. We’ve got some related work we’re looking at soon, and we’ll be sure to carefully consider if we can get a fix in for this then. As always, more votes helps – so keep voting for the things you care about most.

                                        Thanks,
                                        John [MS XL]

                                        Zack Barresse commented  · 

                                        This will be tough in the current process. It's possible with things like Excel DNA already though.

                                      • 9 votes
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          I agree to the terms of service
                                          Signed in as (Sign out)

                                          We’ll send you updates on this idea

                                          I assume you are referring to the new “Treemap” chart type in Excel 2016. Improving the VBA support is something we are looking at. Please continue to vote on this feature idea which will increase its likelihood of getting in the product.

                                          Zack Barresse commented  · 

                                          I'm all for having the object model be current with the current resources in the application.

                                        • 433 votes
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            I agree to the terms of service
                                            Signed in as (Sign out)

                                            We’ll send you updates on this idea

                                            Great suggestion – thanks again for taking the time to put it on this site and for the thoughtful followup comments. This is pretty related to some other work we’ve got going and already has a fair number of votes, so we’ll work on getting plans in place now and hope to get started on this soon.

                                            Thanks,
                                            John [MS XL]

                                            Zack Barresse supported this idea  · 

                                          Feedback and Knowledge Base