Excel Archive
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 your password in a safe …
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 you see on the screen, …
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 an ideal method when using …
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 text by formatting the cells. In …
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 value not just a number. …
