| Data Type | Description | Example |
|---|---|---|
| Text | Words, names, or labels | Rahul Kumar |
| Number | Numeric values | 25000 |
Data Entry and Formatting
Microsoft Excel allows users to enter, edit, organize, and format data efficiently. Proper data entry and formatting help create professional worksheets that are easy to read, understand, and analyze.
Entering and Editing Data
Data entry is the process of adding information into worksheet cells. Excel supports various types of data such as text, numbers, dates, percentages, and formulas.
Types of Data in Excel
| Data Type | Description | Example |
|---|---|---|
| Text | Words, names, or labels | Rahul Kumar |
| Number | Numeric values used for calculations | 25000 |
| Date | Date values | 05-Jun-2026 |
| Percentage | Percentage values | 85% |
| Formula | Calculation expressions | =A1+B1 |
Steps to Enter Data
- Select the desired cell.
- Type the required information.
- Press Enter to move to the next row.
- Press Tab to move to the next column.
Example
| Name | Course | Fee |
|---|---|---|
| Amit | Advanced Excel | 5000 |
Editing Data
Editing means modifying existing data in a cell without deleting the entire worksheet.
Methods to Edit Data:
- Double-click the cell.
- Press F2.
- Edit directly from the Formula Bar.
Clearing Data
- Select the cell or range.
- Press Delete key.
- Only the content is removed; formatting remains unchanged.
Copy, Cut, and Paste
Copy, Cut, and Paste commands are used to duplicate or move data from one location to another.
Copy Data
Copy creates a duplicate of the selected data while keeping the original data intact.
- Select the cell or range.
- Click Copy from the Home tab.
- Select the destination cell.
- Click Paste.
Shortcut: Ctrl + C
Cut Data
Cut removes data from its original location and moves it to a new location.
- Select the cell or range.
- Click Cut.
- Select the destination cell.
- Click Paste.
Shortcut: Ctrl + X
Paste Data
Paste inserts copied or cut data into a selected location.
Shortcut: Ctrl + V
Paste Special Options
| Option | Purpose |
|---|---|
| Values | Pastes only values. |
| Formulas | Pastes only formulas. |
| Formats | Pastes only formatting. |
| Transpose | Converts rows into columns and columns into rows. |
Shortcut: Ctrl + Alt + V
Cell Formatting
Cell formatting helps improve the appearance and readability of worksheet data. Excel provides several formatting tools through the Font Group and Alignment Group located on the Home tab.
Font Group
The Font Group controls the appearance of text inside cells.
| Tool | Purpose |
|---|---|
| Font Name | Changes the font style. |
| Font Size | Changes the size of text. |
| Bold | Makes text thicker. |
| Italic | Makes text slanted. |
| Underline | Adds an underline below text. |
| Font Color | Changes text color. |
| Fill Color | Adds background color to cells. |
| Borders | Adds borders around cells. |
Example
Format the heading “Student Report” with:
- Bold
- Font Size 16
- Blue Font Color
- Yellow Fill Color
Alignment Group
The Alignment Group controls how data is positioned inside cells.
| Tool | Purpose |
|---|---|
| Left Align | Aligns text to the left side. |
| Center Align | Aligns text in the center. |
| Right Align | Aligns text to the right side. |
| Top Align | Aligns content at the top. |
| Middle Align | Aligns content in the middle. |
| Bottom Align | Aligns content at the bottom. |
| Merge & Center | Merges multiple cells and centers the content. |
| Orientation | Rotates text in different directions. |
Example
Create a title “Student Performance Report” and use Merge & Center across cells A1:E1 to display it in the center.
Common Shortcut Keys
| Shortcut Key | Function |
|---|---|
| Ctrl + C | Copy |
| Ctrl + X | Cut |
| Ctrl + V | Paste |
| Ctrl + B | Bold |
| Ctrl + I | Italic |
| Ctrl + U | Underline |
| F2 | Edit Active Cell |
“`
