Five Excel secrets exposed! Number one. Navigate to excel.new in your web browser and you can use Excel on the web entirely for free. Number two. Highlight a list of values and then press the alt key together with equals (=) and you can very quickly sum up your data. Number three. Highlight a row or a column, then hover over the edge of the cell with your mouse and press the shift key and drag the row or the column to a new position. Number four. Highlight a set of values. You get some very quick metrics down below in the status bar. You can click on any one of them and that adds it to your clipboard, and you can now paste that anywhere. Number five. Go up to home and then analyze and you can have Excel analyze your data for you.