Excel Tricks with Tejraj

We have seen previously in brief about how we can “ Format Cell Values in Excel ”. In that blog post we have learned about converting cell values in various formats but in a brief way and now we will focus on “Currency Format in Excel” in this blog post. In our previous blog post we have seen different  03 methods to go to additional options of formatting cell values. If you missed to read those methods, please click here before going for this blog post. We can use any of these 03 methods to get the “Format Cells” dialog box and select “Currency” Category as shown in below image. With this we can see all the additional options under Currency Formats in excel. The additional options which are available under “Currency Format” are as below: Sample : This option is common in all the formats which we can see under Category in above image which we can use to see how the selected numbers will look in currency format. Decimal Places : With this we can increase or decrease the decimal p...

We have seen previously in brief about how we can “ Format Cell Values in Excel ”. In that blog post we have learned about converting cell values in various formats but in a brief way. We will focus on “Number Formats in Excel” in this blog post. In our previous blog post we have seen 03 methods to go to additional options of formatting cell values . If you missed to read those methods, please click here before going for this blog post. We can use any of these 03 methods to get the “Format Cells” dialog box and select “Number” Category as shown in below image. With this we can see all the additional options under Number Formats in excel. The additional options which we can see under “Number Format” are as below: Sample : This option is common in all the formats which we can see under Category in above image. This will show how our selected format will look. Decimal Places : With this we can increase or decrease the decimal places of selected numbers. Use 1000 Separator : This option ...

In our previous blog post we have seen few options from "GoTo Special" dialog box in Excel (Click here to read about GoTo Special in Excel Part 1 ). In this blog post we will see remaining options. Column differences: This option will help us to select the cell values which are different that selected  cell  value in respective column. 1. We have listed few numbers in a column as shown in below image. Now we have selected entire range and the  cell  value which is selected in this cell range is from cell address “B2” (We can see the cell address in Name Box and value from this cell address in Formula Bar ). 2. Select option “Column differences” in “GoTo Special” dialog box and click on “OK” button. 3. As a result we can see that all the cell values which are different that cell value in cell “B2” will get selected. Precedents (Direct only, All levels): This option will help us to select the all the cells which are involved in the formula applied in currentl...