Microsoft Excel - Modifying an excel worksheet

Hiding and Unhiding Excel Rows and Columns

Hiding Rows/Columns: Select them → Right-click → Hide.
Unhiding Rows/Columns: Select nearby rows/columns → Right-click → Unhide.

Renaming an excel sheet

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

Note: Similarly we can delete the sheet.

Changing the Width and Height of Cells

Drag row/column border or Right-click → Row Height / Column Width → Enter value.

Moving and Copying an Excel Worksheet

Move: Drag sheet tab to new spot.
Copy: Hold Ctrl and drag sheet tab.

Move or copy an excel sheet from one to another workbook

Right-click sheet tab → Move or Copy → Choose workbook → Check Create a copy (if needed) → Click OK.

Inserting and Deleting Rows and Columns

Insert:

• Use Ctrl + + (plus).
• Or Right-click → Insert.

Delete:

• Use Ctrl + – (minus).
• Or Right-click → Delete.

Tip: Ctrl + Shift + + inserts entire row/column.