Feb 24 2021 08:51 PM
Excel changes the format when I do not ask it to. I format the cell for no wrap, make changes in a cell that includes imbedded carriage returns, new lines or something like that, and Excel changes it to wrap, forcing me to change it back to no wrap. I want to keep it at no wrap, and I have it in a lot of cells. How can I make the change to "no wrap" permanent? This is on an iMac with Catalina
Feb 27 2021 11:43 AM
I'm going to start with the observation that your question has been here in this forum for three days now with zero replies. That suggests to me that what you're asking doesn't totally sound like an Excel problem per se, certainly not an Excel problem that the experts here are particularly interested in. I'm not that much of an exception, but that you asked piqued my curiosity, so I thought I'd dive in with a question or two for a more complete description.
I ask, because Excel, though it can handle text, isn't primarily a text editor. Text can be there as part of a database, or report, and can play a crucial role in very valid Excel applications, but it's rarely the heart and soul of the application.
Feb 28 2021 01:22 PM
Feb 28 2021 01:52 PM
Oh, my! So you are using Excel really as a database manager. Excel does work for that, has some really good tools for it, in fact. You might want to look into a full database manager instead. Access (sadly) isn't available for Apple (I'm on Apple's various computers as well; iMac, MacBook, Mac Mini).... I used to have Access, at work, on a Windows system. It's powerful.
There are alternatives, but I've not had any real need. Airtable is one, and I do know folks have had good results with it.
In Excel, I'm going to defer to somebody else on your formatting/re-formatting frustrations. I have no magic bullet there.
One thought I have, though, is to separate that column with all the comments from the rest of your table. Make sure there's a project code or some other unique identifier so that you can join the two tables whenever you want to (joining in much the way you would with a relational database).
But that may not be functional with how you actually USE your data.
Are you familiar with the new Dynamic Array functions? FILTER in particular, and how it could help in your searching of all those rows based on multiple criteria? If not, here's a helpful introduction:
https://www.youtube.com/watch?v=9I9DtFOVPIg
I'm sorry I can't be more helpful....it really does sound more like an application calling for a more robust database manager.
Mar 02 2021 08:01 AM