Getting Started with Excel

Before working with data in Microsoft Excel, it is important to understand how to open Excel files, enter data, manage rows and columns, rename worksheets, and use Excel’s powerful Fill features. These basic skills form the foundation for all advanced Excel operations.

Opening an Excel File

An Excel file is called a Workbook. You can create a new workbook or open an existing workbook.

Steps to Open an Existing Workbook

1. Open Microsoft Excel.
2. Click File → Open.
3. Browse to the file location.
4. Select the workbook.
5. Click Open.

Shortcut Key

• Ctrl + O → Open Workbook

Entering Data in Excel

Data can be entered into any cell in a worksheet. Excel supports different types of data.

Steps to Enter Data

1. Select a cell.
2. Type the required data.
3. Press Enter.

Example

Adding Rows

New rows can be inserted whenever additional records need to be added.

Steps to Insert a Row

1. Select the row number.
2. Right-click the row heading.
3. Click Insert.

A new row will be inserted above the selected row.

Ribbon Method

• Home → Cells Group → Insert → Insert Sheet Rows

Adding Columns

New columns can be inserted when additional fields are required.

Steps to Insert a Column

1. Select the column letter.
2. Right-click the column heading.
3. Click Insert.

A new column will be inserted to the left of the selected column.

Ribbon Method

• Home → Cells Group → Insert → Insert Sheet Columns

Deleting Rows

Steps to Delete a Row

1. Select the row number.
2. Right-click the row heading.
3. Click Delete.

Ribbon Method

• Home → Cells Group → Delete → Delete Sheet Rows

Deleting Columns

Steps to Delete a Column

1. Select the column letter.
2. Right-click the column heading.
3. Click Delete.

Ribbon Method

• Home → Cells Group → Delete → Delete Sheet Columns

Renaming a Worksheet

Worksheet names can be changed to make data easier to identify.

Method 1

1. Double-click the sheet tab.
2. Type the new name.
3. Press Enter.

Method 2

1. Right-click the sheet tab.
2. Select Rename.
3. Type the new name.
4. Press Enter.

Example

• Sheet1 → Students
• Sheet2 → Attendance
• Sheet3 → Marks

Fill Option Using Ribbon

The Fill command helps copy data, formulas, and patterns to adjacent cells.

Location

• Home → Editing Group → Fill

Available Fill Options

• Fill Down
• Fill Up
• Fill Right
• Fill Left
• Series

Example

If cell A1 contains “January”, use Fill Series to generate:

• January
• February
• March
• April

Fill Option Using Formula

Formulas can be copied to multiple cells using Excel’s Fill feature.

Example

After entering the formula, use Fill Down to copy it to other rows.

Fill Handle

The Fill Handle is a small square located at the bottom-right corner of a selected cell.

Uses of Fill Handle

• Copy data.
• Copy formulas.
• Create number series.
• Create date series.
• Create month and day sequences.

Example 1: Number Series

Enter 1 in A1 and 2 in A2. Select both cells and drag the Fill Handle downward.

Excel automatically creates:

• 1
• 2
• 3
• 4
• 5

Example 2: Month Series

Enter January and drag the Fill Handle.

Excel automatically generates:

• January
• February
• March
• April

Example 3: Formula Copy

If C2 contains the formula =A2+B2, dragging the Fill Handle downward automatically adjusts the formula references for each row.

Important Shortcut Keys