manipulating columns and rows Flashcards
(7 cards)
Action: Insert Column
📘 Description: Adds a new column to the left of the selected column.
✅ How To:
Right-click the column letter (e.g., “C”).
Click “Insert 1 left” (or “Insert column”).
Action: Insert Row
Description: Adds a new row above the selected row.
✅ How To:
Right-click the row number (e.g., “5”).
Click “Insert 1 above” (or “Insert row”).
Action: Delete Column
Description: Removes the entire selected column.
✅ How To:
Right-click the column letter.
Click “Delete column”
Action: Delete Row
Description: Removes the entire selected row.
✅ How To:
Right-click the row number.
Click “Delete row”.
Action: Resize Column
Description: Adjust column width.
✅ How To:
Hover between column letters (e.g., between B and C) until the resize icon appears.
Click and drag to resize, or double-click to auto-fit contents.
Action: Resize Row
Description: Adjust row height.
✅ How To:
Hover between row numbers (e.g., between 4 and 5).
Drag to resize, or double-click to auto-fit.
Action: Hide/Unhide Column or Row
Description: Temporarily removes column or row from view.
✅ How To:
Hide: Right-click the column/row header > Click “Hide”.
Unhide: Select the range around hidden column/row > Right-click > “Unhide
