Many of us know how to use this software. Yes, so far I have been talking about MS Excel shortcut key. Many of us may know how to use it but it is very important to know some techniques and shortcuts to speed up our work and time. Let’s speed up you
MS Excel Shortcut:
- Go to Next / Previous Worksheet> Ctrl + PgDn, Ctrl + PgUp
- Go to Next / Previous Workbook> Ctrl + tab, Ctrl + shift + tab
- Ribbon Expansion / Compression> Ctrl + F1
- Use autofilter> Ctrl + shift + L
- Select multiple columns or rows> Shift + Ctrl + Arrow key (left, right, up, down)
- Place the cursor or cell point in the first and last cell of the worksheet> Ctrl + Home, Ctrl + End
- Move the cursor inside the data range> Ctrl + Arrow key (left, right, up, down)
- Finding and Replacing> Ctrl + F, Ctrl + H
- Select column and row> Ctrl + Spacebar, Shift + Spacebar
- View Active Cells in Worksheet> Ctrl + Backspace
- Go to Display Box> Ctrl + G
- Create a new line in the same cell> Alt + Enter
- Input the same value in multiple cells> Ctrl + Enter
- Add time and date to worksheet> Ctrl + for time; Ctrl + Shift + for the date:
- Use Bold / Italic / Underline> Ctrl + B, Ctrl + I, Ctrl + U
- Edit in any format> Ctrl + 1
- Automatically drop the selected cell> Alt + =
- Show and hide the formula in the cell> Ctrl +
- Automatically attach Excel function> Tab
- Attaching Function Arguments> Ctrl + Shift + A
- Insert one or more columns / rows> Ctrl + Shift + +
- Delete one or more columns / rows> Ctrl + –
- Show and hide one or more columns> Ctrl + Shift + 0
- Show and hide one or more rows> Ctrl + 9 (hidden), Ctrl + Shift + 9 (show)
- Adding a Chart to the Current Sheet> Alt + F1
You may also like to Learn about MS office formula