Excel Archive

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 an ideal method when using …

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 text by formatting the cells. In …

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 value not just a number. …

Editing Data

After entering the data in every cell of the worksheet and you might want to edit or adjust to make it more visible and display the way you want, you can do that anytime in Excel. In this article you will learn …

Entering Data in Excel

Using a spreadsheet, you will not enter series or repetitive data manually. In this lesson you will learn how to enter, consecutive data and create custom list to automate repeated data entries. First, we have to show is how you can easily …