๐ Entering, Editing & Managing Data in Excel
Now that you understand the Excel interface, let's learn how to work with data efficiently.
๐ 1. Types of Data in Excel
Excel mainly works with three types of data:
๐น Text
Used for names, cities, products, etc.
Examples: Rahul, Mumbai, Laptop
๐น Numbers
Used for calculations.
Examples: 100, 25000, 99.5
๐น Dates
Excel stores dates as serial numbers internally.
Examples: 15/06/2026, 15-Jun-2026, June 15, 2026
โ๏ธ 2. Editing Cell Contents
Method 1: Double-click the cell
Method 2: Select cell and press F2
This puts Excel into edit mode.
Example:
Cell A1 contains: Deepak
Press F2 to modify it without retyping.
๐ 3. Copy, Cut and Paste
Copy
Shortcut: Ctrl + C
Copies data without removing it.
Cut
Shortcut: Ctrl + X
Moves data from one location to another.
Paste
Shortcut: Ctrl + V
Inserts copied/cut data.
๐ฏ 4. Paste Special
Paste Special gives more control over what gets pasted.
Access: Ctrl + Alt + V
Common Options:
Option | Purpose
Values | Paste only values
Formulas | Paste only formulas
Formats | Paste formatting only
Transpose | Convert rows to columns
Example:
Original formula:
=A1+B1Paste Values converts the result into a fixed number.
๐ 5. Undo and Redo
Undo: Ctrl + Z
Reverses the last action.
Redo: Ctrl + Y
Restores an undone action.
๐ These are among the most frequently used shortcuts in Excel.
6. Selecting Data Efficiently
Select a Cell: Simply click the cell
Select Multiple Cells: Click and drag. Example: A1:D10
Select Entire Row: Shortcut: Shift + Space
Select Entire Column: Shortcut: Ctrl + Space
Select Entire Worksheet: Shortcut: Ctrl + A
๐ 7. AutoFill Feature
AutoFill automatically extends patterns.
Example Text:
Enter: Jan
Drag the fill handle down.
Excel generates: Jan, Feb, Mar, Apr
Example Numbers:
1, 2 โ Drag downward: 3, 4, 5, 6
๐ Huge time saver for analysts.
๐ 8. AutoSum
AutoSum quickly calculates totals.
Shortcut: Alt + =
Example:
100, 200, 300 โ AutoSum returns: 600
Equivalent Formula:
=SUM(A1:A3)๐ 9. Saving Excel Files
Save: Ctrl + S
Save As: F12
Common File Types:
Extension | Purpose
.xlsx | Standard workbook
.xls | Older Excel format
.csv | Data exchange
.xlsb | Faster for large files
๐๏ธ 10. Insert and Delete Rows & Columns
Insert Row:
1. Right-click row number
2. Click Insert
Delete Row:
1. Right-click row number
2. Click Delete
Insert Column:
1. Right-click column letter
2. Click Insert
๐ Excel automatically adjusts formulas when rows/columns are inserted properly.
๐ฏ Mini Practice Project
Create a workbook called: Employee_Database.xlsx
Columns:
Employee ID | Name | Department | Salary
E001 | Rahul | Sales | 50000
E002 | Priya | HR | 60000
E003 | Amit | IT | 70000
Practice:
โ Copy and paste records
โ Insert a new employee row
โ Use AutoSum on salaries
โ Use AutoFill for employee IDs
โ Save file as .xlsx
๐ End of Part 2
After completing Part 2, you should be able to:
โ Enter and edit data
โ Copy, cut, and paste efficiently
โ Use AutoFill and AutoSum
โ Select data quickly using shortcuts
โ Save and manage Excel files
โ Insert/delete rows and columns confidently
โก๏ธ Double Tap โค๏ธ For Part-3