formating

5 Topics

Keep 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.
Solved
Kjell Rilbe
Feb 14, 2025 Place Excel
147KViews
3likes
41Comments
Problems 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 Matti
Solved
Maciej Fox
May 31, 2023 Place Excel
105KViews
0likes
13Comments
not able to type number and text in same cell?
Hi experts while typing a number with a unit inside the cell, im getting an error massage, any idea what am i missing here? Yossi while typing a number with a unit inside the cell, im getting an error massage
Solved
Deleted
Jun 05, 2020 Place Excel
4.4KViews
0likes
4Comments
Engineering 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.
Stuart Currie
Nov 06, 2018 Place Excel
3.3KViews
1like
0Comments
Excel 365, V16.17, pasting timestamp with microsecond causes unwanted behaviour
MacOS, High Sierra The presence of .000000 causes excel to switch to a different format. How do I prevent this behaviour?
dmytro.korol
Sep 15, 2018 Place Excel
661Views
0likes
0Comments