Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Download it from http://www.addintools.com
The Cell Lens Of Locked&Unlocked render and change the background color of cells according to their lock/unlock state: the locked cells to gray, the unlocked cells to blue. Assist has also offered a Quick Lock button to lock the selected range at once and a Quick Unlock button to unlock immediately. Now you are very clear about which cells are locked and which cells are unlocked. Just cancel this Cell Lens, the background color will be restored. Cell Lens Of Data Type render and change the background color of cells according to their data type: Text to yellow, Number to blue, Date&Time to green ... Just cancel this Cell Lens, the background color will be restored. Converting Data Type could recognize these date format like 2004-12-31, 20041231 and will convert them to the locale format in your computer. It could convert data of cells to Text, Number or Date&Time type. If you merge some cells in Excel, just the data of first cell could be maintained and the data of other cells will be destroyed! Safety Merge of AddinTools Assist to merge the selected cells and maintain all data. Smart Unmerge to unmerge the selected cells and the data in every cell will be split into several cells! Virtual Screen Rulers help you to align the rows and columns in worksheet. It will draw a colored horizontal line under the active row in a worksheet, and draw a colored vertical line on the right of the active column. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Is it possible to sort a protected worksheet? | Excel Discussion (Misc queries) | |||
Unprotecting Cells in a Protected Worksheet | Excel Discussion (Misc queries) | |||
How can I activate cell shading in a protected worksheet? | Excel Discussion (Misc queries) | |||
How can I merge unlocked cells in a worksheet that has been protec | Excel Discussion (Misc queries) | |||
Protected cells -automatically format to a different color | Excel Discussion (Misc queries) |