Feedback by UserVoice

Gareth Hayter

My feedback

  1. 86 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Gareth Hayter commented  · 

    I've created an Excel add-in which allows you to create custom 'tags', which are the same concept as 'groupings' referred to here. A sheet can be assigned one or many tags. The sheets can then be filtered by tag(s). It might prove useful until Microsoft adds the feature. FormulaDesk Navigator is still in beta, but you can try it here: https://www.formuladesk.com/formuladesk-navigator

    In addition, displayed sheet tabs can be filtered by color(s). Multi-row and vertical sheet tabs are also supported.

    Is anything missing?

  2. 307 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks to everyone who commented on this topic. This is certainly an idea that we’ll consider, but in the meantime, I wanted to mention that if you can’t see all the sheet tabs, you can right-click on the navigation arrows to bring up the “Activate” dialog, which gives a scrollable list of the sheets, so you can select the one you want and navigate to it. I know it’s not exactly what’s being suggested.

    As with other ideas, we’ll look to see how many people vote on this, so vote for it if this is an area you want to see improved.

    Thanks,
    Steve (MS Excel)

    Gareth Hayter commented  · 

    I've created an Excel add-in which adds multi-row tabs among other things, which might prove useful until Microsoft adds the feature. FormulaDesk Navigator is still in beta, but you can try it here: https://www.formuladesk.com/formuladesk-navigator Is anything missing?

    Gareth Hayter commented  · 

    I've just added a new feature to the FormulaDesk add-in called Quick Navigator which allows you to CTRL+TAB to switch between current sheet and previous sheet. Keeping CTRL pressed shows the Quick Navigator window. You can then TAB (or DOWN) to move down the list of recent sheets, or SHIFT+TAB (or UP) to move up. Hopefully it makes navigating sheets and workbooks much faster, until Microsoft adds similar native functionality to Excel. http://www.formuladesk.com Suggestions for improvements are welcome.

  3. 2 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Gareth Hayter commented  · 

    You can find this functionality in some add-ins, eg: the 'Track Active Cell' feature in FormulaDesk.

  4. 66 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Gareth Hayter commented  · 

    Does the Formula Explorer in the FormulaDesk add-in come close to what you want, or are there other features? https://www.formuladesk.com

  5. 24 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Gareth Hayter commented  · 

    Great suggestion. FYI: the FormulaDesk add-in enables CTRL+A in the formula bar (but not in the other places you mention).

  6. 5 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Gareth Hayter commented  · 

    The FormulaDesk add-in can disable the F1 key (and others) for you.

  7. 13 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Gareth Hayter supported this idea  · 
  8. 2 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Gareth Hayter commented  · 

    You can do this with the FormulaDesk addin: https://www.formuladesk.com

  9. 4 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Gareth Hayter commented  · 

    Yes, this is very useful and can cause many problems. Until Microsoft adds this, you can get this feature with the FormulaDesk add-in: https://www.formuladesk.com

  10. 4 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Gareth Hayter commented  · 

    I agree, that would be a very useful feature. The FormulaDesk add-in already has this feature. Click the 'Performance Viewer' button on the FormulaDesk menu to access the feature to find all volatile cells. https://www.formuladesk.com

  11. 7 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Gareth Hayter commented  · 

    @Lawrence, FormulaDesk now has a menu item to add unit formats, and even define your own. It is now easier to apply these formats directly via the menu, instead of typing the whole format string in the formatting dialog. Custom formats will now be available in every workbook (on your machine). See: https://www.formuladesk.com/productivity-tools

    Gareth Hayter commented  · 

    Lawrence, thank-you for your kind words! My goal with FormulaDesk has been to add core (deep) infrastructural-type features to Excel that substantially enhance the power and capabilities of Excel, as opposed to simple features that could be accomplished with a sprinkling of VBA. I'm trying to deliver features of what I envisage that the next (next, next?!) version of Excel should have.

    There are still many more features in the pipeline - the Math notation is about to gain some new capabilities too ;-)

    Yes, I would love FormulaDesk to be acquired by Microsoft and see it become an integral part of Excel.

    I will be launching a Pro version soon.

    Gareth Hayter commented  · 

    @Lawrence: I'm glad that it solves your problem! I only added many # characters to handle many decimal points and as an indication of the syntax for using it.

    Excel doesn't remember them across spreadsheets, but keep an eye on FormulaDesk (my free Excel add-in): I think that you'll like some upcoming features ;-)

    Gareth Hayter commented  · 

    You can accomplish the cell formatting like this:

    1) Right-click the cell(s)
    2) Click 'Format Cells'
    3) Choose 'Custom'
    4) Under 'Type:', enter: #.###### "kg"
    5) Click 'OK'

  12. 16 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Excel for Mac » Editing  ·  Flag idea as inappropriate…  ·  Admin →
    Gareth Hayter commented  · 

    [Windows only, not Mac] Until Microsoft adds the buttons to Excel, the FormulaDesk add-in adds them for you (works with Excel 32 bit and 64 bit): https://www.formuladesk.com/productivity-tools

    The keyboard shortcuts are:

    Subscript: CTRL+=
    Superscript: CTRL+?

  13. 265 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks to Jeffrey for suggesting the shortcut keys to format text as subscript or superscript. I can see that this would be useful and consistent with the other applications. As with all the requests, voting helps move the request up in our priority list, so keep the votes coming if this is important to you.

    Steve K (Microsoft)

    Gareth Hayter commented  · 

    Until Microsoft adds the buttons to Excel, the FormulaDesk add-in adds them for you (works with Excel 32 bit and 64 bit): https://www.formuladesk.com/productivity-tools

    The keyboard shortcuts are:

    Subscript: CTRL+=
    Superscript: CTRL+?

  14. 7 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Gareth Hayter commented  · 

    Until Microsoft adds this capability back, you can get it with the FormulaDesk add-in: https://www.formuladesk.com/navigation-tools

  15. 3 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Gareth Hayter commented  · 

    Until this gets added to Excel natively, you can use FormulaDesk add-in to accomplish this.

  16. 2 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Gareth Hayter commented  · 

    That's the reason that I added the calculation mode alert to the FormulaDesk add-in, because if it's set to manual you might not even realize it, and bad things start to happen.

  17. 1 vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Gareth Hayter commented  · 

    Until Microsoft adds something like this to Excel, you can use the Formula Explorer in the free FormulaDesk add-in: http://www.formuladesk.com

  18. 1 vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Gareth Hayter commented  · 

    You can accomplish this with the ALT+LEFT, ALT+RIGHT shortcuts in the FormulaDesk add-in. There are also little back and forward dropdown buttons on the ribbon menu that display a list of the last 20 locations, allowing you to navigate to one directly.

  19. 23 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Interesting idea. Thanks for the feedback. We’ll consider this in our future planning. Please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

    Gareth Hayter commented  · 

    The FormulaDesk add-in allows you to do this via the context-menu. Right-click a chart, then 'Save as image'. http://www.formuladesk.com

  20. 1 vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Gareth Hayter commented  · 

    @Charles: it's not impossible - FormulaDesk does it. Just get the location of Excel.exe from the registry, then inspect the PE Header to determine the bitness of the actual exe file.

← Previous 1 3

Feedback and Knowledge Base