Excel Archive

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 …

Excel Rows and Columns

When you open or create a workbook in Excel you will arrive in a grid layout called a worksheet or spreadsheet. And you will notice the letters on the top, it is called Column headings and on the left side you will …