Feedback by UserVoice

Sergei Baklan

My feedback

  1. 106 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    18 comments  ·  Excel for the web » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Sergei Baklan commented  · 

    Now we could use Office Script to return the same what CELL() do, but with that we have no compatibility with desktop version. Built-in CELL() is quite desirable.

    Sergei Baklan supported this idea  · 
  2. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Sergei Baklan commented  · 

    Nested data types are available for the part of insiders

  3. 90 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Sergei Baklan commented  · 

    Right pane is usually opened in any case. Anyway, If people vote for it they know such shortcut will be quite useful for them. That's great, let it'll be. I only would like to say I'm personally have no any need in it.
    For me more useful will be shortcut to open "Manage data model" interface, aka Power Pivot. But that's also "nice to have", that's not the operation which I repeat every few minutes or which requires a lot of clicks to perform or which is hided deeply in navigation menu.

    An error occurred while saving the comment
    Sergei Baklan commented  · 

    Honestly, how often do you do File->Data->Get Data->Launch Power Query Editor to assign shortcut on it? I never. Entry or from right pane to perform some action on existing query, or from Get data to add new one.

  4. 0 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Sergei Baklan commented  · 

    At least one exists, it is called "Dynamic array formulas"

  5. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Sergei Baklan commented  · 

    Where are folders in Power Pivot? Here are tables. Separate ones could be for measures only.

  6. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Sergei Baklan commented  · 

    You may select entire sheet, e.g. by clicking on the magic corner on the top of 1 and to the left of A, after that unhide all what was hided.

  7. 51 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Sergei Baklan supported this idea  · 
  8. 16 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Sergei Baklan shared this idea  · 
  9. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Sergei Baklan commented  · 

    If select File->Options->Advanced->Automatically insert a decimal point->Places:=2 when typing 1210 you'll have 12.10

  10. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Sergei Baklan commented  · 

    You may select an option File->Options->General->User Interface options section->Collapse the Microsoft Search box by default

  11. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Sergei Baklan commented  · 

    To send feedback File->Feedback->Send a Frown. Microsoft monitors it. As for an issue I can't reproduce it.

  12. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Sergei Baklan commented  · 

    You shall unselect "Use Custom lists when sorting" in PivotTable options, at the bottom of Total & Filters tab in options

  13. 74 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Sergei Baklan commented  · 

    That could be like
    =TRANSPOSE(FILTERXML("<r><n>" & SUBSTITUTE(A1,",","</n><n>") & "</n></r>", "//n"))
    If extract, for example, 2nd word
    =FILTERXML("<r><n>" & SUBSTITUTE(A1,",","</n><n>") & "</n></r>", "//n[2]")

    An error occurred while saving the comment
    Sergei Baklan commented  · 

    Fabio, I guess practically all of us use such formula, but SPLIT() will be much more suitable

    An error occurred while saving the comment
    Sergei Baklan commented  · 

    like =SPLIT(<text>,<delimiter>,[<splitby>],[<splitto>)
    where
    splitby
    -1 by first delimiter
    0 by each delimiter (default)
    1 by right delimiter

    splitto
    TRUE to columns (default)
    FALSE to rows

    Sergei Baklan supported this idea  · 
  14. 244 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Sergei Baklan commented  · 

    As a workaround that could be
    =TRANSPOSE(FILTERXML("<r><n>" & SUBSTITUTE(A1,",","</n><n>") & "</n></r>", "//n"))

    Sergei Baklan supported this idea  · 
    An error occurred while saving the comment
  15. 74 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Sergei Baklan commented  · 

    Excel Online has this functionality. Hope will be on desktop one day

    Sergei Baklan supported this idea  · 
  16. 176 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Sergei Baklan supported this idea  · 
  17. 1,422 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for logging this great suggestion, Zack, and to others for voting it up. We’ll prioritize this according to the number of votes, so if there’s more interest, please make sure to register your vote!

    Thanks

    Ashvini Sharma
    Lead Program Manager
    Excel

    Sergei Baklan supported this idea  · 
  18. 848 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Sergei Baklan supported this idea  · 
  19. 567 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thank you for taking your time to suggest and vote for allowing interaction with Excel while in Power Query Editor window. We do think that this suggestion has merit but we don’t think that we’ll be able to devote time to it in the near future. We’ll continue tracking votes for it.

    Guy Hunkin
    Excel Team

    Sergei Baklan supported this idea  · 
  20. 243 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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]

    An error occurred while saving the comment
    Sergei Baklan commented  · 

    I voted since that's better than nothing. But I definitely would like to have an option to switch on/switch off such expanding. In general that's much better to have separate formatter or Advance Editor, more they are integrated into Excel the better.

    Sergei Baklan supported this idea  · 
← Previous 1 3 4 5 6 7

Feedback and Knowledge Base