formating
5 TopicsKeep conditional formatting range when inserting/deleting cells/rows/columns?
Hi, I sometimes use conditional formatting. For each entry, there's a cell range that it applies to. Often I need it to be used on the entire sheet, or at least a large range of it, i.e. all rows that have content. But then I need to insert or remove data, and that mucks up the range. It seems to copy the entry to the range above, the inserted range, and the range below. I want it to keep the range and entries as they are when I edit the sheet's data. How? I usually enter the range as e.g. $1:$1048576 or $A:$XFD.Solved147KViews3likes41CommentsProblems with formating text within a cell.
04.10.2017, 22:09 Uhr | 33 | 1 Hello. Since recently I have an annoying problem with Excel. I have a desktop computer, using Windows 10 Home Edition 64 bit with Excel 2016: Since a couple of time, Excel is just re-formating my texts within the cells. I am using my familiar format since 20+ years, so I did no major changes here. Right after I open up an Excel file, it re-formats the content in a second. I have a collection of text-modules and as soon as I underline a word or change it to bold characters, Excel converts all following text into MS Sans Serif Size 10. In the attempt to correct this, after the next opening of the file, Excel just makes it happen again (grrr). The initial format (which I use since ever) is Arial Size 11. And this unwanted re-formating happens only in cells, in which I did underline or bold-mark a word, the other cells are not affected. I sifted through several threads and did some tweaking on the registry and the Excel-options, but without any success. Has someone a solution for this painfull bug? And don't tell me, that might be a feature ;-) I put in a picture with an example. Thank you in advance, guys. Bye MattiSolved105KViews0likes13CommentsEngineering Notation Formatting Excel
Enhancement Suggestion Engineering Notation Formatting is one of the most useful yet least documented options. This is at least true for electrical or any other field with calculations requiring unit conversions and consolidation. ##0.0E+0 This should be in a more convenient category under beside or under Scientific Category vs 2 mouse clicks and a big scroll deeper as almost undocumented option under "Custom". How does ## make you intuitively guess this means Engineering notation? Ideally would also have option to fix the exponent . i.e so you could stay in the same units nanoseconds or millivolts even if move more than 1000 units.. A suggestion for one of my favorite tools.3.3KViews1like0Comments