msfreetuts Archive

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 …

Create, Rename or Delete Worksheet

In the other article, you already know how to create Workbook and save them if you read those articles, you know that a single workbook contains different types of related sheets. Now to make it easy to identify every sheet, we will …

How to Save Workbook

Saving workbook in Excel is easy, just like any other Windows programs that you use. But to make your workbook compatible with the older version of Excel (97-2003), you need to save it into .xls instead of the new .xlsx …