I could use that same procedure to obtain BLAKE2sp hashes for the files that would result from unzipping those. The other post describes how I obtained BLAKE2sp hashes for each of the original files, before they were compressed into those. In other words, it didn’t seem to be storing up a hundred deletion commands, if I pressed Alt-D for a long time: it was only thinking that I had held down the Alt-D combination for 15 seconds, and therefore it would delete as many rules as 15 seconds would buy, at its plodding half-second pace per deletion.Īs discussed in another post, I had used WinRAR to facilitate backup onto a series of Blu-ray discs. But it seemed to keep deleting at that pace for as long as I held down the keys. This didn’t seem to speed up the rate of deletion: Excel still seemed to take a half-second or so to delete each individual rule. That is, I didn’t have to hit that key combination repeatedly it continued to work for as long as I held down the two keys. The suggestion or observation that I intended to share was just that the manual deletion process seemed to go somewhat faster, at least in this version of Excel, when I selected the first unwanted rule and then just held down the Alt-D key combination. The keyboard shortcut way of getting there faster was just Alt-O D. In this version of Excel, the Conditional Formatting dialog was available via menu > Home tab > Styles group > Conditional Formatting > Manage Rule. That was the thought that led me to compose this post. For earlier versions, it appeared that users might appreciate a suggestion on how to speed up the manual deletion process somewhat. The timing of that posted question led me to assume that Excel 365 and Excel 2021 might be, so far, the only versions with the option to Clear Rules from Selected Cells. The answer, at that point, was that there was no way around it, unless maybe someone came up with VBA to automate it. A variation on that suggestion might have been to use something like AutoHotkey to automate the requisite deletion key sequence. For instance, in August 2020, one user posted a question at My Online Training Hub, asking whether there was some way to avoid having to delete rules one at a time. That was my impression, as a long-time Excel user. It looked like that was going to fix the problem for me.īefore I discovered that option, my search led to numerous indications that users had no alternative but to select and delete rules individually. In the process of writing this post, I discovered that Excel Pro 2021 had another option, adjacent to the one just described: Clear Rules from Selected Cells. I did not want to do that in this case: I had rules in other columns that I wanted to keep. In Excel Professional 2021, that option was available via menu > Home tab > Styles group > Conditional Formatting > Clear Rules > Clear Rules from Entire Sheet. Since I had not recently changed these two columns, however, I doubted that would help.Īnother solution would have been to clear all conditional formatting rules through the entire spreadsheet. One solution would have been to just restore a backup or revert to a previous version of the spreadsheet. But I didn’t want them in these two columns. Those rules may have been fine, wherever they originated. I suspected that, at some point in the past, I had copied one or more cells from some other column and pasted them down through these columns. While working in a Microsoft Excel spreadsheet, I found that two columns had somehow become infected with hundreds if not thousands of conditional formatting rules.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |