Insights Blog
-- Browse All Articles --
Physics Articles
Physics Tutorials
Physics Guides
Physics FAQ
Math Articles
Math Tutorials
Math Guides
Math FAQ
Education Articles
Education Guides
Bio/Chem Articles
Technology Guides
Computer Science Tutorials
Forums
Chemistry
Biology and Medical
Earth Sciences
Computer Science
Computing and Technology
DIY Projects
Trending
Featured Threads
Log in
Register
What's new
Search
Search
Search titles only
By:
Chemistry
Biology and Medical
Earth Sciences
Computer Science
Computing and Technology
DIY Projects
Menu
Log in
Register
Navigation
More options
Contact us
Close Menu
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Forums
Other Sciences
Computing and Technology
Microsoft Excel background grid color default reverts
Reply to thread
Message
[QUOTE="Vanadium 50, post: 6835369, member: 110252"] Well, you might have said that at the beginning rather than getting grumpy about the imperfect mental telepathy of the readers here. For someone who demands a lot of help from PF, your sure don't make it easy. And easy is respectful. Excel stores cell attributes like color, fonts, etc. with the worksheet. I hope this is obvious - if it didn't, how would it remember them, especially across computers? So if you want to change the file contents, you need to open the file and change its contents. Again, I hope this is obvious. By far, the easiest solution is to follow Google's advice, and when you open a file to work on it, make the half-dozen clicks to change the color and save it. When you next open it, it will have the new colors. It is possible to automate the process with a combination of the Automate Tab and Scripts. [B]I strongly recommend against this[/B]., [LIST] [*]If it takes a few seconds to change the color, and an hour to write and debug the script, breakeven is at about a thousand files. Very, very few people have a thousand spreadsheets they are actively using. [*]The risk of damage is high. If you mess up manually, you might ruin a spreadsheet. If you automate the process you could ruin all of them. [*]When your code has changed the file and opened it, you must, must, must open it and make sure it wasn't broken. That removed any time savings. [/LIST] Mucking with the registry is almost never the right answer, and it is never the right first step. That would be like wanting to kearb to juggle and starting with chainsaws rather than bean bags. In the case at hand, the absolute best you can hope for is a change of cell background colors that have never been set. That is not what you say you wanted. [/QUOTE]
Insert quotes…
Post reply
Forums
Other Sciences
Computing and Technology
Microsoft Excel background grid color default reverts
Back
Top