Explore Excel like a pro! Enhance your spreadsheet skills with this comprehensive guide to one hundred essential shortcuts and hotkeys, designed to boost your efficiency and streamline your Excel experience. Dive into Excel mastery and elevate your productivity today!
1. Navigation and Selection Shortcuts
Ctrl + Arrow Keys: Navigate to the edge of data regions.
Ctrl + Space: Select entire column.
Shift + Space: Select entire row.
Ctrl + A: Select entire worksheet.
Shift + Arrow Keys: Expand selection in the direction of the
arrow.
Ctrl + Shift + Arrow Keys: Select to the edge of data
region.
Ctrl + Page Up/Page Down: Switch between worksheets.
Ctrl + Home/End: Navigate to the beginning/end of a
worksheet.
Ctrl + G (or F5): Go To (navigate to a specific cell).
Ctrl + Tab/Shift + Ctrl + Tab: Switch between open
workbooks.
2. Editing Shortcuts
F2: Edit the active cell.
Ctrl + C: Copy selected cells.
Ctrl + X: Cut selected cells.
Ctrl + V: Paste copied/cut cells.
Ctrl + Z: Undo last action.
Ctrl + Y: Redo last undone action.
Ctrl + D: Fill down (copy cell above).
Ctrl + R: Fill right (copy cell to the left).
Ctrl + ' (Apostrophe): Copy formula from the cell above.
Ctrl + Shift + "+": Insert a new cell, row, or
column.
3. Formatting Shortcuts
Ctrl + B/I/U: Bold/Italic/Underline.
Ctrl + 1: Format Cells dialog box.
Ctrl + Shift + $/%/#: Apply currency/percentage/general
format.
Ctrl + Shift + L: Toggle filters.
Ctrl + Shift + T: Create a table.
Alt + H, B, A (sequentially): Add or remove cell borders.
Alt + E, S, V (sequentially): Paste Special.
Ctrl + ' (Apostrophe): Copy formula from the cell above.
Ctrl + Shift + "_": Remove outline borders.
Ctrl + Shift + "&": Apply outline border to
selected cells.
4. Data Entry and Validation Shortcuts
Ctrl + ; (semicolon): Insert the current date.
Ctrl + " (double quotation): Copy value from cell
above.
Ctrl + Enter: Fill selected cells with the active cell's
value.
Ctrl + Shift + "colon": Enter the current time.
Ctrl + K: Insert a hyperlink.
Ctrl + ~ (tilde): Toggle between showing cell values and
formulas.
Ctrl + Shift + "plus sign": Insert a new cell,
row, or column.
Ctrl + - (minus sign): Delete a cell, row, or column.
Ctrl + Shift + Arrow Keys (while entering data): Extend the
selection for data entry.
Ctrl + Shift + P: Display the Format Cells dialog box with
the Font tab selected.
5. Formula and Calculation Shortcuts
= (Equal Sign): Start a formula in a cell.
Alt + E, S, V (sequentially): Paste Special.
F9: Calculate the active worksheet.
Ctrl + Shift + "%": Format as percentage.
Ctrl + Shift + "~ (tilde): Toggle formulas on/off in
cells.
Ctrl + Shift + "$": Format as currency.
Ctrl + ' (Apostrophe): Copy formula from the cell above.
Ctrl + Alt + V: Paste Special menu.
Ctrl + Alt + Arrow Key: Rotate text in a cell.
F4: Repeat the last action.
6. PivotTable and PivotChart Shortcuts
Ctrl + Shift + "$" (in a PivotTable): Show/hide
value field settings.
Ctrl + Alt + "+": Insert a blank row in a
PivotTable.
Ctrl + Alt + "-": Delete a row in a PivotTable.
Alt + Shift + J: Collapse/expand field in a PivotTable.
Ctrl + Alt + L: Toggle PivotTable Field List.
Alt + J, T, F (sequentially): Change field layout in a
PivotTable.
Ctrl + Alt + V, E, S (sequentially): Paste Values and Source
Formatting.
Ctrl + Alt + V, E, W (sequentially): Paste Values and Source
Widths.
Ctrl + Alt + V, E, T (sequentially): Paste Values and Source
Formulas.
Ctrl + Alt + V, E, N (sequentially): Paste Values and Number
Formatting.
7. Chart Shortcuts
F11: Create a chart on a new sheet.
Alt + F1: Create an embedded chart.
Alt + Shift + F1: Create a chart on the same sheet.
Alt + H, N, R (sequentially): Switch Row/Column in a chart.
Alt + J, D: Add data labels to a chart.
Alt + J, A, D (sequentially): Add a data table to a chart.
Alt + J, A, R (sequentially): Add a trendline to a chart.
Alt + J, A, G (sequentially): Add a gridline to a chart.
Alt + J, A, T (sequentially): Format chart title.
Alt + J, A, L (sequentially): Format legend in a chart.
8. Data Analysis Shortcuts
Alt + D, P: Create a PivotTable.
Alt + D, S, P (sequentially): Sort PivotTable data.
Alt + D, S, F (sequentially): Filter PivotTable data.
Alt + D, G, R (sequentially): Group data in a PivotTable.
Alt + D, U, U (sequentially): Ungroup data in a PivotTable.
Alt + D, G, F (sequentially): Group selection in a
PivotTable.
Alt + D, U, F (sequentially): Ungroup selection in a
PivotTable.
Alt + A, M, A (sequentially): Remove duplicates.
Alt + A, A, E (sequentially): Advanced Filter.
Alt + A, A, O (sequentially): Sort ascending.
9. Workbook and Worksheet Shortcuts
Ctrl + N: Create a new workbook.
Ctrl + O: Open a workbook.
Ctrl + S: Save the workbook.
Ctrl + P: Print the active sheet.
Ctrl + F2: Print Preview.
Ctrl + F12: Save As.
**Alt + H, W
No comments:
Post a Comment
ENGLISH: You are warmly invited to share your comments or ask questions regarding this post or related topics of interest. Your feedback serves as evidence of your appreciation for our hard work and ongoing efforts to sustain this extensive and informative blog. We value your input and engagement.
HAUSA: Kuna iya rubuto mana tsokaci ko tambayoyi a ƙasa. Tsokacinku game da abubuwan da muke ɗorawa shi zai tabbatar mana cewa mutane suna amfana da wannan ƙoƙari da muke yi na tattaro muku ɗimbin ilimummuka a wannan kafar intanet.