39 votes6 comments · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
Yes, it's a shame this isn't getting more traction. I didn't clock that PBI already has this when I looked at this thread before. Thing is we all have Excel/PQ and Power Pivot and can "publish" to our intranets or sharepoint/MS Teams directly from it. To do the same with PBI your organisation has to hand over some more dosh to MS - I guess for that extra dosh it had better have some extra features - even if, like this, I suspect the feature would be trivial for MS to add to Excel.
528 votes82 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →
Bills original point was not only to add a centre -across selection icon front and centre in the standard interface but also to discourage (three cheers from me) the use of merged cells. Only very occasionally is there really no other way than using merged cells. I guess MS could add "Left Across Selection", "Right Across Selection" etc, although I think that would be overkill. I would think that most of us that use "Centre Across Selection" a lot, like me, have recorded and then minimally edited and assigned to a shortcut a little macro that does it. The same could easily be done for "Left Across Selection" etc if you use that a lot. I think the thing is to stop people using merge....
786 votes213 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →
Thanks to Graham for starting this conversation. If you would also like Excel to maintain named range references and structured table references in the “applies to” field for Conditional Formatting rules, please add your comments and vote this one up. We will prioritize accordingly.
Steve (MS Excel)
otimo solucao Celia. Parece pra me imediatement comprehensivel e elegante. Ha outra solucao de vba aqui de Laurence Dunn, e eu tem aquele tambem. Nao tentei usar o solusao dele, mais, so dei um olhado e o codigo parece bem mais complicado do seu. Para ser justo de Laurence tambem o solucao dele pode ser mais sofisticado tambem, mais seu parece suficiente bom por me.
Hope my Portuguese is intelligible :-)
1,073 votes174 comments · Excel for Windows (Desktop Application) » Tables, Sorting and Filtering · Flag idea as inappropriate… · Admin →
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!
Lead Program Manager
hey, OMISSION, that's a big word, how about calling it an OM, nice and short. Meaning code that should have been written to do something that everyone thinks should have been done by now that hasn't been written yet. Hey MS, sort this OM, now.
Also, I think MS are balancing this request against the fact that "Professional" developers writing apps and forms etc will be using a database product or programming language that can do all this. So programmers writing code for mere Excel mortals to be able to do the same with XL are eating their own lunch and MS if they make XL able to do this are eating into their SQL server market. They are a business. That said, I think they should eat it and do this. Oh, and another thing, this forum doesn't seem to work for me in Edge.
I have voted for this and I can't wait for them to do it. However, its bugging me that people are referring to this as a bug. It isn't a bug. A bug is an error or usually unfortunate unforeseen consequence of code. This is an OMISSION. They simply haven't written the code to make tables play nicely with worksheet protection. I agree they should get on and do it, but, it isn't a BUG.
Data validation is a usable stop gap if you have a limited distribution but I don't think its a substitute for what's being asked for here - which is, the ability to add a row to a table on a protected worksheet.
2,531 votes675 comments · Excel for Windows (Desktop Application) » Viewing / Navigating Workbooks · Flag idea as inappropriate… · Admin →
Thanks everyone for all of the passion about this suggestion! The number of votes has increased greatly in the last couple months and we’re taking notice! We’ve got a bunch of other Excel endpoints behaving this way already and we’re evaluating getting it done in the Windows versions sooner based on the number of votes it gets – so keep the votes coming!
Eric Patterson (Program Manager – MSFT)
Fair point, it isn't used just as a number cruncher. I notice that many people use Excel as a sort of "Project Management" or "Progress Chasing" tool and work with large text based tables - often brightly coloured. I see them sitting at break out tables in meetings all with colour printouts of these things. Perhaps they should be using Project Management Software? MS is probably wary of making something too capable in that area to be part of O365 as Project Management Software is still pretty pricey - which is why people use Excel for it.....
I understand the frustration with this, but, I also have sympathy with MS not prioritising it. I say this as I think Excel's core mission is to crunch the numbers, and although they certainly do pay attention to how it looks and visual ergonomics there are other programs out there where presentation is a higher priority and perhaps people could consider using those to present work having crunched the numbers in Excel.