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 cell
Ctrl +C : Copies selected cell
Ctrl + V: Pastes the information you previously cut or copied into selected cell
Paste as values
Menu 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 cells
Ctrl + 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 values
Ctrl + Arrow Keys : This shortcut will teleport your selection to last unempty cell in a column or row.
Select Cells with keyboard
Shift + Arrow Keys : With holding down Shift key, you can select cells by using arrow keys.
Instantly select whole column or row of cells
Ctrl + Shift + Arrow Keys : This one combines previous 2 shortcuts and selects whole rows or columns of data instantly.
Autosum a column or row of values
Ctrl + = : 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 formatting
F4 : 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 charts
Alt + A + R + A : This will refresh all pivot tables and charts at once. Super handy.
Apply filter to columns
Ctrl + 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 properties
Crtl + 1 : This shortcuts does the same thing as right-clicking on a cell and select Format Cells.
Toggle edit mode in a cell
F2 : 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 cells
Ctrl + 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.
Source: BeatExcel Picture Source: Technolly
--
We are also on Face Book, Click on Like to jois us
FB Page: https://www.facebook.com/pages/Hyderabad-Masti/335077553211328
FB Group: https://www.facebook.com/groups/hydmasti/
https://groups.google.com/d/msg/hyd-masti/GO9LYiFoudM/TKqvCCq2EbMJ
---
You received this message because you are subscribed to the Google Groups "Hyderabad Masti" group.
To unsubscribe from this group and stop receiving emails from it, send an email to hyd-masti+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment