Adding Password to Workbook and Worksheet

Adding password can prevent from unauthorized opening or modifying your Excel Workbook. But keep in mind that if you lose or forget your password it cannot be recovered and your workbook will be useless, so keep … Read more

Printing Sheets

Now you have a workbook full of data and you want to have a hard copy of it. You’ve printed it and it looks like a mess. Excel worksheet doesn’t look exactly the same on what … Read more

Inserting and Deleting Rows and Columns

When creating your worksheet you cannot avoid making mistakes like omitting an entries. Although you can move the following rows and columns to leave an empty space where you can insert the omitted entries, it’s not … Read more

Cell Formatting

When we  format cells in Excel, we change the appearance of the data inside the cells without changing the data itself. And in the previous article, we have already explained how to format numbers and … Read more

Formatting Text and Numbers

Formatting text and numbers in Excel makes it more presentable and readable to whoever use your worksheet, like on the currency, it’s way better to have a currency symbol before the number to determine the exact … Read more