Step 3: Pick Insert 3 columns left or Insert 3 columns right, depending on where you want the columns. Google Sheets automatically enters the number of columns you have selected in the drop-down menu.

Once your columns or rows are all revealed they will stay that way indefinitely. In order to hide them once more you'll have to manually right-click the first cell in each column or row you want ...