In this article, we will learn How to modify default cell styles in Excel. Scenario: A style is a named group of formatting characteristics....
If you wish to hide the formula in your excel sheet, follow the below approach:- Please not that this will only hide the formulas not the the resul...
If you install Excel 2003 you'll find that all the menus are not visible. To see a full menu requires that you either click the expand button at the...
Follow below quick Tip to hide / unhide the ribbon bar. Press Control + F1 and ribbon disappears and press again to reappear ribbon. You can als...
If you wish to hide any data from praying eyes, follow the below process:- Select the cell / range you want to hide. Go To Format=>...
In this article, we will learn How to format all worksheets in one go in Excel. Scenario: When working with multiple worksheets in Excel. Be...
We all know that how to split a worksheet using menu / ribbon bar available OR by using keyboard shortcut (Alt + W + S), but below is one more tricky ...
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.