Thursday, 29 January 2015

MS Excel Custom Formatting - Show Units Of Measure Without Changing Your Numbers To Text

Without Changing Your Numbers To Text Show Units Of Measure in MS Excel with Example.(adsbygoogle = window.adsbygoogle || []).push({}); Many of you don't know that you can display a unit of measure (eg. lb., kg., km., in., etc...) in a cell of MS Excel worksheet without changing your numbers to text, so you can still use them in calculations?It is not a very tough work, it's very easy! All you need to do is create a Custom Number Format.To Add Measure...

Tuesday, 6 January 2015

Hide Duplicate / Repeating Values in a Column in MS Excel.

How to hide Repeating /  Duplicate Values In A Column in Microsoft Excel with Example? (adsbygoogle = window.adsbygoogle || []).push({}); As you are working with lists in MS Excel, after sorting, you may find that, you have multiple rows with the same values repeating down one or more columns. If you are printing this list as a report, for aesthetic (pleasing) purposes, you may prefer to have only the first instance of each item shown.One option...

Friday, 5 December 2014

Use Line Breaks In Complex Formulas To Make Them Easier To Read in MS Excel with Example

How to break complex/Long Formulas into multiple lines to make them easier to Read in Microsoft Excel with Example.(adsbygoogle = window.adsbygoogle || []).push({}); Everyone know that in Excel, he/she can get very creative with formulas and do things most users would never have thought possible. There is one drawbacks with long, complex formulas that they are often difficult to understand - especially when a person go back and look at them long...

Wednesday, 3 December 2014

About Lotus Temple / Bahai Temple New Delhi

Lotus Temple / Bahai Temple New Delhi (Must Visit / See places in Delhi, India) (adsbygoogle = window.adsbygoogle || []).push({}); In the attraction places of New Delhi India, Lotus temple is one them. Lotus temple has an awesome architecture and great historical importance. Everyone wants to know the history behind it. So, what is the historical importance of lotus temple and awesome architecture of it.Lotus Temple Night ViewBRIEF HISTORY OF LOTUS...

Show or Display Dashes instead of Zeros in MS Excel Spreadsheet.

Display Dashes (-) Instead Of Zeros (0) in MS Excel Worksheet with Example. (adsbygoogle = window.adsbygoogle || []).push({}); Sometimes we may want our report to display dashes instead of zeros, especially those Excel spreadsheets that contain a lot of zeros. Display zeros as dashes in Excel 2007We can do this with a simple change to our current number format.To do this simple change follow the given below steps:-1) Select the cells where We want...

Thursday, 27 November 2014

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...

Wednesday, 26 November 2014

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...