Christopher Sirali – Page 5

Align Dollar Sign to the Left in Excel

A dataset that has the dollar sign closely attached to the currency values does not look visually appealing. This is so especially if…

When you type a number that has more than 15 digits in a cell in Excel, Excel converts any digit beyond the fifteenth…

Sometimes you may want to check if cells in a worksheet contain any text. This tutorial shows you a technique for checking if…

At times you may want to check if cells in an Excel worksheet contain numeric characters. This tutorial shows you one technique for…

By default, Excel removes leading zeroes from any real number you enter in a cell. This is because the zeroes are insignificant. Sometimes…

Sometimes you may want to print only specific columns in your Excel worksheet. This tutorial shows you two methods of how to print…

Sometimes we may need to increase the size of the checkboxes in Excel to increase their visibility and accessibility. In this tutorial, we…

Sometimes you may see that the Conditional Formatting button in Excel is grayed out. This means it is unavailable. This tutorial explains why…

Sometimes we may want to show Yes or No in a PivotTable instead of other values. This tutorial shows you how to show…

An array formula performs many calculations on one or more items in an array. This tutorial shows how to insert a multi-cell and…