Press [Ctrl]+ [Shift]+= to insert the appropriate number of rows or columns. This shortcut will insert cells instead of entire rows and columns, if you don’t select an entire row or column first.

Open your spreadsheet in Microsoft Excel and look at the numbers list. You need to determine the range of numbers you wish to consider. This range might be based on the lowest and highest values ...

First, delete any numbers you have already typed automatically in column A. To do this, press Ctrl+Shift+Home to go to cell A1 before using the Arrow keys to navigate to the correct cell.