Provided Enhanced Text Functionality
Excel isn't used just for numbers. Many reports, from CRM systems especially, are text heavy and Excel works better for sortable data than Word tables, but the text functionality in Excel needs an upgrade. Perhaps a "text mode" could be created that opens up a new Ribbon tab with options such as bullets, line spacing, and spelling/grammar check that uses the Word/PowerPoint red/green squiggles. It would also be helpful for Find to highlight the item being searched for rather than the entire cell.
please restore bullet point and numbering option back to Ribbon Bar
Bullets and numbering are included in the list of All Commands for Excel. But when you add this function to your Excel toolbar, they are NOT available. This makes no sense.
When you copy a bullet list into the space at the top of the spreadsheet workscreen for a single cell, the bullet list is entered into that single cell. When you enter the bullet list into the cell itself, it is copied into multiple cells in the same column.
This ALSO makes no sense.
Suggestions for fixing these make-no-sense inconsistencies in Excel cell formatting have been made for year, and Microsoft has done exactly nothing to fix them.
This makes the LEAST SENSE of all.
I like all of the elements of this suggestion. The ability to turn on the red underlining for misspelled words would be the most helpful for me. Having to click on a "Spell check" button has become so alien because all other applications show spelling errors as you type. We've literally been conditioned to not use the Check Spelling option.
Please give us at least an option to turn on a "Highlight spelling errors in text cells as you type"
Although I'd like to see text-based improvements, maybe the focus should be on fixing Word tables instead.
One of the worst things about text functionality in Excel is the different behavior of text when editing, in print preview, and in hard copy. Lines that fit perfectly on screen are suddenly too long and drop down, causing the last line of text to disappear. I waste huge amounts of time, paper and ink trying to get text-heavy spreadsheets to print out properly.