MS Excel Basics – Insert Sheet, Duplicate Copy, Rename, Sort, Filter, Home Menu & Wrap Text

Microsoft Excel has many features that are used in day-to-day work. In this blog, we will learn in detail about Insert Sheet, Duplicate Copy, Rename Sheet, Sort, Filter, Home Menu, and Wrap Text.

Insert Sheet

 Insert Sheet

There are two ways to insert a new sheet in Excel:

1. Insert with Button

• Click the “+” button near the last sheet tab.

• A new sheet will be added automatically.

2. Insert with Right-Click

• Right-click on any sheet tab.

• Select Insert → Worksheet → OK.

• A new sheet will be created.

Duplicate Copy

 Duplicate Copy of a Sheet

• Press and hold the Ctrl key.

• Drag the sheet tab to a new position.

• A duplicate copy of the sheet will be created.

Rename A Sheet

✏️ Rename a Sheet

There are two ways to rename any sheet:

1. Double-click on the sheet tab → type a new name.

2. Right-click → Rename → type a new name.

Position Change

↔️ Change Position of a Sheet

• Click and drag the sheet tab to a new position.

• Release it where you want the sheet to appear.

Sort 

Sort in Excel

Simple Sort

• Go to Home → Sort & Filter → Sort A to Z / Sort Z to A.

• It arranges data in Ascending (A–Z / Smallest to Largest) or Descending (Z–A / Largest to Smallest) order.

Custom Sort 

Custom Sort

• Go to Home → Sort & Filter → Custom Sort.

• When duplicate values exist, Custom Sort helps arrange data properly according to a specific column.

Filter

 Filter in Excel

• Go to Home → Sort & Filter → Filter.

• It allows you to filter and display only the required values.

• Shortcut: Ctrl + Shift + L

? Example: If you have a list of fruits and want to see only “Apple,” you can apply Filter and select Apple.

Home menu

 Home Menu – Merge Options

1. Merge & Center

• Merges multiple cells and aligns text at the center.

2. Merge Across

• Merges cells horizontally, but not vertically.

3. Merge Cells

• Merges selected cells both horizontally and vertically.

4. Unmerge Cells

• Splits merged cells back into individual cells.

Wrap Text

 Wrap Text

Wrap Text is used to display long text on multiple lines within a single cell.

How to Use:

1. Select the cell(s).

2. Go to the Home tab → Wrap Text (Alignment group).

3. Excel will adjust the row height automatically.

Shortcut: Press Alt + H + W.

LINK: Insert Sheet, Duplicate Copy, Rename Sheet, Sort, Filter, Home Menu, Wrap Text in hindi 

Thanks To Google

Thanks To ChatGPT