IMPORTANT INFORMATIONS YOU NEED TO KNOW ABOUT EXCEL.
Excel is a spreadsheet application published by Microsoft.
This enables users to store, arrange, and manipulate their data in tabular format.
Excel has a wide application in many areas, including budgeting and forecasting, data analysis.
In Excel, the default applied file format is .xlsx.
Each Excel version, which includes Excel 2019, Excel 2016, Excel 2013, and Excel 2010-.
Excel Shortcut Keys
Navigation
Ctrl + Home: Goes to cell A1
Ctrl + End: Move cursor to last used cell
Ctrl + Page Up/Page Down: Go between worksheets
Ctrl+ Tab: Toggles between open Excel files
Ctrl + F6: Move among open Excel files (alternative)
Ctrl + F11: Full-screen mode on/off
Ctrl + Shift + Tab: Switch between open Excel files – alternate
Cell Selection
A: SELECTS ALL THE CELLS
Ctrl + I: Select entire row
Ctrl + Space: Select all column
Shift + Space: Select entire row
Ctrl + Shift + Space: Select all in worksheet
Ctrl + Shift + Down Arrow: Select to last cell with data
Ctrl + Shift + Up Arrow: Select to first cell with data
Ctrl + Shift + >: Select to last cell with data in row
Ctrl + Shift + <: Select to first cell with data in row
Editing
Copy: Ctrl + C
Cut: Ctrl + X
Ctrl + V: Paste
Ctrl + Z: Undo
Ctrl + Y: Redo
F2: Edit cell
Alt + Enter: Insert new line in cell
F11: Toggle full screen
Ctrl + Shift + F: Open Font dialog
Formatting
Ctrl + 1: Apply general number format
Ctrl + Shift + !: Apply time format
Ctrl + Shift + $: Apply currency format
Ctrl + Shift + %: Apply percentage format
Ctrl + B: Bold
Ctrl + I: Italics
Ctrl + U: Underline
Ctrl + Shift + >: Make font larger
Ctrl + Shift + <: Decrease font size
Ctrl + Shift + F: Open Font dialog
Formulas and Functions
=: Begin formula
F3: Paste command
Shift + F3: Open function arguments dialog
Ctrl + Shift + Enter: Array formula
F5: Bring up formula
Ctrl + F3: Display Name Manager
F11: Open the Function Arguments dialog
Ctrl + Shift + F3 Open the dialog box for Function Arguments
Human-Data Inter
Ctrl + Shift + Down Arrow: Select to last cell in dataset
Ctrl + Shift + Up Arrow: Select to first cell with data
Ctrl + -: Row Deletion
Ctrl + +: Insert row
Ctrl + Shift + +: Insert column
Ctrl + -: Delete column
Ctrl + Shift + – : Delete Row (variant)
Ctrl + Shift + +: Insert column (alternative)
Shortcuts for Working with PivotTables
Alt + F1: Create PivotTable
Alt + F5: Update Pivot Table
Ctrl + Shift + F: Open PivotTable Field List
Ctrl + Shift + Down Arrow: To the last nonempty cell in a column
Ctrl + Shift + Up Arrow: Multi-select To Top Of First Column Containing Data In PivotTable
Shortcuts for Working with Charts
F11: Draw graph
Alt + F1: Graph modification
Ctrl + Shift + F : Display Chart Tools
Ctrl + Shift + Tecla Abajo: Selecciona hasta celda con el último dato en la tabla
Ctrl + Shift + Up Arrow: returns selection to the first cell containing data within the chart
Other Shortcuts
Ctrl + F: Find and replace
Ctrl + P: Print
File: Ctrl + S
F1: Aid
F5: Go to cell
F9: Worksheet Review
Ctrl + F9: Open Calculate Formula dialog
Shift + F11: Open dialog for function arguments
Ctrl + Shift + F11: Open Function Arguments dialog (alternative)
This information is a general guide for Excel, pointing out important information and shortcut keys. The mastery of these shortcuts will save you a big deal on time and improve your productivity in Excel.