Forum Discussion
Constant range in conditional formatting
Thanks for quick response.
I figured it works properly wit "Paste values" option (or whatever it is called in english version) however it is quite annoying to search for that in ctrl menu every time and it takes more time than a simple ctrl+c and ctrl+v.
I will try the second method though and I will let you know if it worked.
Thank you for your help Sergei :)
Arek,
Yes, it takes some time, but that's not something significant. In my daily work I quite often Copy (Ctrl+Ins) and Paste (Shift+Ins) as values (Ctrl, Down, Down, Enter). The latest takes less than a second and you don't need to search any icons, just use your keyboard.
If to paste formulas and number formatting as well, avoiding only cell formatting, that will be (Ctrl, Right, Right, Enter), etc.