Open the spreadsheet in Excel or Google Sheets. Ensure the column or row. Select the new position. Right-click on that column or row. Select the Insert option. Choose the column or row you want to ...

In order to apply shading to alternative rows and columns in Excel, you need to use Conditional Formatting. It is required to use this function: =MOD(ROW(),2)=0 or =MOD(COLUMN(),2)=0.

You can also freeze Excel rows and columns with keyboard shortcuts. Here’s a small list of the most popular commands: Step 1: Freeze both rows and columns: Press Alt+W+F+F , with each key tap ...

Excel will insert new columns to the left of the selected columns. The keyboard shortcut for this task is also Ctrl + Shift + +. This works with multiple rows but not non-contiguous selections.

In Excel 2003, choose Column or Row from the Format menu, and then select Hide. You can quickly discern that a row or column is hidden by the missing header. Unhiding is also simple.