Unhide A single Hidden Rown or Column in MS Excel with Example.

How to Unhide A Single Hidden Row Or Column in Excel Worksheet with Example. (adsbygoogle = window.adsbygoogle || []).push({}); There is question here that is there an easy way or way to unhide a single column when multiple columns are hidden?The Answer is Yes, there is an easy way.If an excel user have a multiple rows or columns hidden and he/she needs to unhide just one. Some people unhide all hidden columns or rows and then re-hide all except...

Read More

Print Files directly from File Explorer.

How to Print Files Directly From File Explorer (#A.K.A. Windows Explorer) / How to Print Files without opening it?(adsbygoogle = window.adsbygoogle || []).push({}); #Also Know As (A.K.A or AKA)Did you know that you don't have to open a file to print it?There is a hidden trick by which you can save a significant amount of time.There is a quick little known trick that lets you to print a document directly from File Explorer (formerly known as Windows...

Read More

Use of SUBSTITUTE function/Formula with Example in Microsoft Excel.

Use of SUBSTITUTE function/Formula with Example in Microsoft Excel.(adsbygoogle = window.adsbygoogle || []).push({}); SUBSTITUTE is a great function/Formula in MS Excel that you may not have aware of, but now that you are about to learn, you will probably find everyday uses for it in Data Analysis.In Microsoft Excel, you use the SUBSTITUTE function/Formula when you wish to replace specific text in a text string.There are three pieces of information...

Read More