Skip to main content

Keyboard Shortcuts in MS Excel

Select the whole column
SELECTION
CTRL + SPACE
Select the whole row
SELECTION
SHIFT + SPACE
Select table
SELECTION
SHIFT + CTRL + SPACE bar
Save
SELECTION
CTRL + s
Select visible cells only
SELECTION
ALT + ;
Select entire region
SELECTION
CTRL + A
Select range from start cell to far left
SELECTION
SHIFT + Home
Select range from start cell to end in direction of arrow
SELECTION
SHIFT + End + arrow
Select a continuous range of data (e.g. pivot), no matter where your cursor is.
SELECTION
CTRL + *
Select blank cells
SELECTION
F5 + ALT + S + K + ENTER
Select all cells with comments
SELECTION
CTRL + SHIFT + O
Select all cells that are directly or indirectly referred to by formulas in the selection
SELECTION
CTRL + SHIFT + {
Select all cells with formulas that refer directly or indirectly to the active cell
SELECTION
CTRL + SHIFT + }
Selects all the way to a1 from cursor position
SELECTION
CTRL + SHIFT + HOME
Select cells in the direction of arrow
SELECTION
CTRL + SHIFT + Arrow
Previous sheet
NAVIGATION
CTRL + Page Up
Next sheet
NAVIGATION
CTRL + Page Down
Launch GO TO Dialog (from here you can select special or jump to a cell or range)
NAVIGATION
F5
Go to top left (will go to top left of freezed pane if set)
NAVIGATION
CTRL + Home
Go to last non-blank cell
NAVIGATION
CTRL + end
Go to previous sheet
NAVIGATION
CTRL + PgUp
Go to next sheet
NAVIGATION
CTRL + PgDn
Print
NAVIGATION
CTRL + p
Toggle between workbooks in a given session of excel.
NAVIGATION
CTRL + TAB
Change the type of cell reference from relative to absolute or semi-absolute
FORMULAS
F4
Repeat whatever you did last
FORMULAS
F4
Debug portions of a formula (select and press)
FORMULAS
F9
Sum range
FORMULAS
ALT + =
Enter array formula
FORMULAS
CTRL + SHIFT + Enter
Select array formula range
FORMULAS
CTRL + /
Display range names (can be used when typing formulas)
FORMULAS
F3
Evaluate formulas. (its easy to remember when working with some “tuf” formulas!)
FORMULAS
ALT + TUF
Copy a formula from above cell and edit
FORMULAS
CTRL + '
Display the formula palette after you type a valid function name in a formula
FORMULAS
CTRL + A (while writing a formula)
Alternate between displaying cell values and displaying cell formulas
FORMULAS
CTRL + ` (Single Left Quotation Mark)
Calculate formulas
FORMULAS
F9
Select all precedent cells
FORMULAS
CTRL + [
Select all dependent cells
FORMULAS
CTRL + ]
Format Selection (cells, objects, charts)
FORMATTING
CTRL + 1
Bold a cell’s content
FORMATTING
CTRL + B
Format Painter – Paste formats from selection
FORMATTING
ALT + EST
Format as number with 2 dp
FORMATTING
CTRL + SHIFT + 1
Format as local currency
FORMATTING
CTRL + SHIFT + 4
Format as percentage with 0 dp
FORMATTING
CTRL + SHIFT + 5
Hide row
FORMATTING
CTRL + 9
Hide column
FORMATTING
CTRL + 0
Unhide row
FORMATTING
CTRL + SHIFT + 9
Unhide column
FORMATTING
CTRL + SHIFT + 0
Display the style command format menu
FORMATTING
ALT + '
Sets/removes strikeout in current cell
FORMATTING
CTRL + 5
Show/hide the top bar when you have a group
FORMATTING
Crtl + 8
Single border around selected cells
FORMATTING
CTRL + SHIFT + 7
Sort
FORMATTING
ALT + DS
Insert hyperlink
FORMATTING
CTRL + K
Freeze panes
FORMATTING
ALT + WFF
Remove grid lines or (alt+t)ov(alt+g)[enter]
FORMATTING
ALT + WVG (2007+)
To wrap lines
FORMATTING
ALT + HW (2007+)
Save as
EXCEL OPTIONS
F12
Collapse the ribbon (press again to expand)
EXCEL OPTIONS
CTRL + F1
Opens print preview
EXCEL OPTIONS
CTRL + F2
Maximize the current window
EXCEL OPTIONS
ALT + SPACE X
Activate next window
EXCEL OPTIONS
ALT + TAB
Activate previous window
EXCEL OPTIONS
ALT + SHIFT + TAB
Close an excel workbook
EXCEL OPTIONS
crtl + F4
Split screens
EXCEL OPTIONS
ALT + W + S
Create a pivot table in new sheet (of course after selecting the range)
EVERYTHING ELSE
ALT + DPF
Create a pivot table in the same sheet.
EVERYTHING ELSE
ALT + DPN
Show visual basic editor
EVERYTHING ELSE
ALT + F11
Macro dialog
EVERYTHING ELSE
ALT + F8
Apply/remove filter
EVERYTHING ELSE
ALT + DFF
Keep filter on columns, but show all rows
EVERYTHING ELSE
ALT + DFS
Insert pivot table
EVERYTHING ELSE
ALT + NVT
Turn filter on or off
EVERYTHING ELSE
CTRL + SHIFT + L
Paste values only
EDITING
ALT + ESV
Edit a cell, place cursor at the end
EDITING
F2
Show in-cell drop down with previously entered values
EDITING
ALT + Down arrow
Fills down value from cell above
EDITING
CTRL + D
Add a comment or Edit comment
EDITING
SHIFT + F2
Insert new sheet
EDITING
SHIFT + F11
Insert row
EDITING
CTRL + +
Delete row
EDITING
CTRL + -
Copy
EDITING
CTRL + C
Paste
EDITING
CTRL + V
Cut
EDITING
CTRL + X
Undo
EDITING
CTRL + Z
Get a line break inside the cell
EDITING
ALT + Enter (while editing the cell)
Clear all contents
EDITING
ALT + EAA
Copy
EDITING
CTRL + insert
Paste
EDITING
SHIFT + Insert
Make chart/pivot chart
EDITING
F11
Edit a cell in Apple Macs
EDITING
CTRL + U
Copy the value from the cell above the active cell into the cell or the formula bar
EDITING
CTRL + SHIFT + "
Copies whatever is in the cell to the left of it.
EDITING
CTRL + R
Delete box (cell, row, column)
EDITING
ALT + ED
Insert box (cell, row, column)
EDITING
ALT + IE
Enter current date
AUTO COMPLETE
CTRL + ;
Enter current time
AUTO COMPLETE
CTRL + :

Microsoft Office Error Code Solutions:

  1. Error code 0-1011900
  2. Error code 0-1012 (0)
  3. Error code 0-1018 (0)
  4. Error code 0-1028 (0)
  5. Error code 10106-4
  6. Error code 1084-13
  7. Error code 1392-4
  8. Error code 216-13
  9. Error code 30013-39
  10. Error code 30015-1011 (3)
  11. Error code 30015-1011 (5)
  12. Error code 30015-11 (5)
  13. Error code 30015-4 (3)
  14. Error code 30016-22
  15. Error code 30016-23
  16. Error code 30034-4
  17. Error code 30068-4 (1053)
  18. Error code 30068-4 (1715)
  19. Error code 30088-1007 (0)
  20. Error code 30088-1015 (0)
  21. Error code 30088-1021 (0)
  22. Error code 30088-1028 (0)
  23. Error code 30094-1011 (0)
  24. Error code 30101-11
  25. Error code 30125-1011
  26. Error code 30125-1011 (500)
  27. Error code 30126-1011 (12152)
  28. Error code 30175-4
  29. Error code 30175-13

Comments

Popular posts from this blog

Poomully Mana- Mana for Ayurveda- An Overview

1. Tell us a brief history of Poomully Mana family ? The Poomully Namboothiri family, whose ancestral home was known by the name “Poomully Mana,” resided in Urakam of Peruvanam village in the interiors of Kerala. This family lived in an era that dates back by about 900 years. They built the original Ammathiruvadi Temple and left all their ancestral wealth to the Goddess and its administration to the Kingdom of Kochi. The family then relocated to Peringode (present-day Palakkad).  In the 'Aithihyamala' (a collection of centuries-old stories from Kerala, covering a vast spectrum of lives, famous people and events), Poomully Mana features as one of the families that had a glorious history. The members of Poomully Mana were famous Ayurvedic exponents and practitioners of the Rig Veda, Yoga, Kalaripayattu (a form of martial art), music and other cultural arts. Some of the better known members are the Late Sri Poomully Narayanan Namboodirippad (father of Aaramthampu...

Microsoft Error Code Support/Solution Online

Error code 0-1011900 http://microsoftchatsupport.com/answers/office-error-code-0-1011900/ Error code 0-1012 (0) http://microsoftchatsupport.com/answers/office-error-code-0-1012-0/ Error code 0-1018 (0) http://microsoftchatsupport.com/answers/error-code-0-1018-0-office-installation/ Error code 0-1028 (0) http://microsoftchatsupport.com/answers/office-error-code-0-10280/ Error code 10106-4 http://microsoftchatsupport.com/answers/microsoft-office-error-code-10106-4/ Error code 1084-13 http://microsoftchatsupport.com/answers/error-code-1084-13-office-365-office-2013/ Error code 1392-4 http://microsoftchatsupport.com/answers/tag/error-code-1392-4/ Error code 216-13 http://microsoftchatsupport.com/answers/office-2013-office-2016-office-365-error-code-216-13/ Error code 30013-39 http://microsoftchatsupport.com/answers/office-error-code-30013-39/ Error code 30015-1011 (3) http://microsoftchatsupport.com/answers/tag/error-code-30015-1...

Té Sencha Adelgazante BIO, 45 bolsitas individuales

  Link : https://tetique.com/products/hosteleria-piramides-te-sencha-adelgazante-biologico-45-unidades El Té Sencha Adelgazante BIO de Tetique es una opción saludable y conveniente para aquellos que quieren disfrutar de una taza de té en cualquier lugar y en cualquier momento. Este té verde sencha orgánico se presenta en 45 bolsitas individuales, lo que las hace perfectas para llevar contigo mientras te desplazas o para servir a tus clientes de manera rápida y eficiente en tu cafetería o restaurante. Somos los mejores - Proveedor de infusiones España , Tes premium   La mezcla de té verde sencha con mate y ortiga verde en esta deliciosa bebida es ideal para ayudar a controlar el apetito y acelerar la pérdida de peso. Además, el Té Sencha Adelgazante BIO de Tetique es rico en antioxidantes y nutrientes que lo hacen una opción saludable y deliciosa para cualquier momento del día. Si estás buscando una bebida saludable y deliciosa para ofrecer a tus clientes, no busques más allá ...