1 vote0 comments · Excel for Windows (Desktop Application) » Editing · Flag idea as inappropriate… · Admin →H Dum shared this idea ·
91 votes23 comments · Excel for Windows (Desktop Application) » Opening and Saving Files · Flag idea as inappropriate… · Admin →
Great idea in theory, in practice, office is used by to large and varied of user types that it's a nightmare. The average home user who loses their data because they constantly don't save it's a life saver and is clearly the targeted audience. The everyday cooperate, small business, or even run of the mill geek, is reversed, we're losing our data due to auto save
71 votes4 comments · Excel for Windows (Desktop Application) » Tables, Sorting and Filtering · Flag idea as inappropriate… · Admin →
294 votes28 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.
490 votes76 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →
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,326 votes71 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]
@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.