Add shortcut for Copy and Paste Values in Quick Access Toolbar
Popular posts from this blog
Hiding Error Triangle from worksheet cells
Would you like a way to remove those green error checking triangles from worksheet cells, yet retain error checking? Go to File, Options, Formulas, Error Checking. Leave the “Enable background error checking” box checked, and change the Indicate errors using the color (default is green) to white. Of course, this only works if the cells are white. To turn off the error checking and the green triangles, change the “Enable background error checking” box to unchecked.
Hide the formula of cell in worksheet
Sometime you required to hide the formula in excel sheet. Firstly, un-protect your sheet and right click the cells where you want to hide the formula and click 'Format cells'. On the protection tab select the 'Locked' checkbox and then re-protect your sheet and the formula will not show up in the formula bar.
This trick is helpful when dataset is large.
ReplyDelete