Course Content
Excel Essentials
Excel Essentials
Inserting and Deleting Columns, Rows, and Cells
Sometimes you need to adjust the structure of your worksheet by adding or removing columns, rows, or cells.
Knowing how to insert and delete columns, rows, and cells allows you to manage your data layout effectively, ensuring your spreadsheets remain organized and functional.
Key Points
- Insert a column or row by right-clicking the column or row header and selecting Insert;
- Right-click any cell and choose Insert to add cells;
- Delete a column or row by right-clicking the header and selecting Delete;
- Right-click any cell and choose Delete to remove cells.
Task
- Right-click column
H
and select Insert. - Right-click
G6
, select Insert, and choose Entire Row. Choose to clear the formatting completely on the Insert Options button. - Right-click column
H
and select Delete. - Right-click
G6
, select Delete, and choose Entire Row.
Task
- Right-click column
H
and select Insert. - Right-click
G6
, select Insert, and choose Entire Row. Choose to clear the formatting completely on the Insert Options button. - Right-click column
H
and select Delete. - Right-click
G6
, select Delete, and choose Entire Row.
Everything was clear?
Choose your plan
Inserting and Deleting Columns, Rows, and Cells
Sometimes you need to adjust the structure of your worksheet by adding or removing columns, rows, or cells.
Knowing how to insert and delete columns, rows, and cells allows you to manage your data layout effectively, ensuring your spreadsheets remain organized and functional.
Key Points
- Insert a column or row by right-clicking the column or row header and selecting Insert;
- Right-click any cell and choose Insert to add cells;
- Delete a column or row by right-clicking the header and selecting Delete;
- Right-click any cell and choose Delete to remove cells.
Task
- Right-click column
H
and select Insert. - Right-click
G6
, select Insert, and choose Entire Row. Choose to clear the formatting completely on the Insert Options button. - Right-click column
H
and select Delete. - Right-click
G6
, select Delete, and choose Entire Row.
Task
- Right-click column
H
and select Insert. - Right-click
G6
, select Insert, and choose Entire Row. Choose to clear the formatting completely on the Insert Options button. - Right-click column
H
and select Delete. - Right-click
G6
, select Delete, and choose Entire Row.
Everything was clear?
Choose your plan
Inserting and Deleting Columns, Rows, and Cells
Sometimes you need to adjust the structure of your worksheet by adding or removing columns, rows, or cells.
Knowing how to insert and delete columns, rows, and cells allows you to manage your data layout effectively, ensuring your spreadsheets remain organized and functional.
Key Points
- Insert a column or row by right-clicking the column or row header and selecting Insert;
- Right-click any cell and choose Insert to add cells;
- Delete a column or row by right-clicking the header and selecting Delete;
- Right-click any cell and choose Delete to remove cells.
Task
- Right-click column
H
and select Insert. - Right-click
G6
, select Insert, and choose Entire Row. Choose to clear the formatting completely on the Insert Options button. - Right-click column
H
and select Delete. - Right-click
G6
, select Delete, and choose Entire Row.
Task
- Right-click column
H
and select Insert. - Right-click
G6
, select Insert, and choose Entire Row. Choose to clear the formatting completely on the Insert Options button. - Right-click column
H
and select Delete. - Right-click
G6
, select Delete, and choose Entire Row.
Everything was clear?
Sometimes you need to adjust the structure of your worksheet by adding or removing columns, rows, or cells.
Knowing how to insert and delete columns, rows, and cells allows you to manage your data layout effectively, ensuring your spreadsheets remain organized and functional.
Key Points
- Insert a column or row by right-clicking the column or row header and selecting Insert;
- Right-click any cell and choose Insert to add cells;
- Delete a column or row by right-clicking the header and selecting Delete;
- Right-click any cell and choose Delete to remove cells.
Task
- Right-click column
H
and select Insert. - Right-click
G6
, select Insert, and choose Entire Row. Choose to clear the formatting completely on the Insert Options button. - Right-click column
H
and select Delete. - Right-click
G6
, select Delete, and choose Entire Row.