Excel Operation Guide

Sheet Structure and Layout

Operations for inserting rows and columns, adding sheets, unhiding, and cleaning layout.

insert rowinsert columnnew sheetunhidegroupungroupalt h o ialt w f f

Related shortcuts

Insert Cells/Rows/Columns

Ctrl + Shift + +

Insert New Worksheet

Shift + F11

Unhide Row

Ctrl + Shift + 9

Unhide Column

Ctrl + Shift + 0

Select Entire Row

Shift + Space

Select Entire Column

Ctrl + Space

Start shortcut practice for this operation