Here is a list of excel shortcuts that I use everyday. Therefore I call them everyday excel shortcuts. I stongly recommend evereybody to learn and start to use these shortcuts. They will boost your speed significantly.

Here is my everyday Excel shortcuts:

Cut, Copy, Paste with lightning speed.Ctrl + X : Cuts selected cellCtrl +C : Copies selected cellCtrl + V: Pastes the information you previously cut or copied into selected cellPaste as valuesMenu Key + V : If you prefer to paste values only, this is your shortcut. If your keyboard doesn't have a menu key (i.e. laptop keyboard), you can try "Fn + Ctrl + V" in this order. Select a group of cellsCtrl + A : When one of a group of cells is selected, this key combo selects the whole group.Instantly move to end of a row or column of valuesCtrl + Arrow Keys : This shortcut will teleport your selection to last unempty cell in a column or row. Select Cells with keyboardShift + Arrow Keys : With holding down Shift key, you can select cells by using arrow keys.Instantly select whole column or row of cellsCtrl + Shift + Arrow Keys : This one combines previous 2 shortcuts and selects whole rows or columns of data instantly.Autosum a column or row of valuesCtrl + = : This works as a substitute for the autosum button located on home ribbon near filters. Adds a SUM function into the cell and selects the row or column of cells next to itself. Just hit Enter then.Apply last used formattingF4 : When you are going to dye a bunch of seperate cells or chart elements, or add border, etc. Select the first one and apply that formatting. Then select next and hit F4. Be aware that it will only apply last formatting done.Refresh all pivot tables and chartsAlt + A + R + A : This will refresh all pivot tables and charts at once. Super handy.Apply filter to columnsCtrl + Shift + L : No more selecting title row and clicking here and there for adding filter. Select any cell on title row and use this shortcut. I will add filter to all cells on that row.Access cell propertiesCrtl + 1 : This shortcuts does the same thing as right-clicking on a cell and select Format Cells.Toggle edit mode in a cellF2 : While on a cell with a formula, you need to double click or go to formula bar to edit contents of that cell. If you directly start inputting, it will replace cell content. This shortcut lets you toggle input mode without touching your mouse.Mass Input same value or formula into selected cellsCtrl + Enter : When you need to input same value into a group of cells, like same month number next to a list, select the cells and input your values. Instead of pressing Enter button alone, press Ctrl + Enter. Same value will be inputted into all selected cells at once.

Please feel free to let us know about your everyday excel shortcuts by leaving a comment below. We can all benefit from your experince and add one into our everyday excel shortcuts too.