71 votes4 comments · Excel for Windows (Desktop Application) » Tables, Sorting and Filtering · Flag idea as inappropriate… · Admin →
468 votes47 comments · Excel for Windows (Desktop Application) » Collaboration and Sharing · Flag idea as inappropriate… · Admin →
Hello, we are working on this request for Excel Online – https://excel.uservoice.com/forums/274580-excel-online/suggestions/8192445-allow-for-personal-user-views-filters, more updates are coming later for Win32.
527 votes82 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →H Dum commented
Not being buried would be great.
Personally I'd still use merge cells, currently to cumbersome to center across some and merge others. Center across in not effective when you have text you've rotated vertically, and want it to go across multiple rows. Ex- have multiple items offered in several selections, but one item is not offered in one grouping of selections. Marge and center with vertical text Not Available.
@Monte Tucker Conditional formatting is under styles, which generally is on the ribbon. Conditional formatting pre-dates the ribbon. You can customize what color the cell is under what circumstance by defining the rule.
1,413 votes90 comments · Excel for Windows (Desktop Application) » Editing · Flag idea as inappropriate… · Admin →
Thanks very much for your votes. And to those who took the time to fill in the survey, thank you! This is a brief update to let y’all know that we’ve started work on this feature request along with the one on changing numbers to scientific notation.
- Urmi [Msft]H Dum commented
@Scott McGee I have Office 365 on my Desktop Excel 2016 version 1711, on a computer that is just barely 2 months old, Nov 2017, and it does not do leave leading zero's. It is Office 365 personal, maybe only home version. Why Microsoft would include it in one version and not another, whether Office 365 or Office home and student which is not even $4 less than 365 personal bare basic programs and no apps, nor in office online, is ludicrous.
When I choose I want Excel to handle numbers as text as the description/comment is "Text format cells are treated as text even when a number is in a cell. The cell is displayed exactly as entered."
Deleting a leading zero is not exactly as entered.
When I'm trying to track 10 digit identification/account/record numbers or 8 digit identification/account/record, and I have clients that have had their accounts 40+ years and they now have leading zeros because when they were issued in both situations some were only 6 digits, tracking those accounts is a nightmare as some are identical other than double zero's at the end, or to figure out if there's a data entry error when new accounts have been added.
Microsoft unfortunately is the industry standard now, I could make a tracking 'spreadsheet' with far more ease using DOS in the 90's. No automatically changes, it's my data, but I don't have control of it using a spreadsheet, particularly Excel.