EXCEL SHORTKEYS ” To get speed for computer Work and Save Your Time.”

Here are some commonly used Excel commands and their functions:

Basic Commands

1. Ctrl + C: Copy the selected cells.
2. Ctrl + V: Paste the copied content.
3. Ctrl + X: Cut the selected cells.
4. Ctrl + Z: Undo the last action.
5. Ctrl + Y: Redo the last undone action.
6. Ctrl + S: Save the current workbook.

Navigation Commands

1. Arrow Keys: Move one cell up, down, left, or right.
2. Ctrl + Arrow Key: Move to the edge of the current data region.
3. Home: Move to the beginning of the row.
4. Ctrl + Home: Move to the beginning of the worksheet.
5. Ctrl + End: Move to the last cell with data.

Formatting Commands

1. Ctrl + B: Apply or remove bold formatting.
2. Ctrl + I: Apply or remove italic formatting.
3. Ctrl + U: Apply or remove underline formatting.
4. Alt + H + H: Open the Fill Color menu.
5. Alt + H + B: Open the Border menu.

Formulas and Functions

1. =SUM(A1

   ): Adds all numbers in the range A1 to A10.

2. =AVERAGE(A1

   ): Calculates the average of the numbers in the range A1 to A10.

3. =IF(A1>10, “Yes”, “No”): Returns “Yes” if A1 is greater than 10, otherwise returns “No”.
4. =VLOOKUP(value, table, col_index, [range_lookup]): Looks up a value in the leftmost column of a table and returns a value in the same row from a specified column.
5. =INDEX(array, row_num, [column_num]): Returns the value of an element in a table or array, selected by the row and column number indexes.
6. =MATCH(lookup_value, lookup_array, [match_type]): Searches for a specified item in a range of cells and returns the relative position of that item.

Data Manipulation

1. Ctrl + T: Convert the selected range into a table.
2. Alt + E + S + V: Paste Special Values.
3. Ctrl + D: Fill down.
4. Ctrl + R: Fill right.

Data Analysis

1. Alt + A + T: Open the Filter menu.
2. Alt + D + F + F: Apply or remove a filter.
3. Alt + N + V: Open the PivotTable Wizard.

Useful Functions

1. =CONCATENATE(text1, text2, …): Joins several text items into one text item.
2. =LEFT(text, [num_chars]): Returns the specified number of characters from the start of a text string.
3. =RIGHT(text, [num_chars]): Returns the specified number of characters from the end of a text string.
4. =MID(text, start_num, num_chars): Returns a specific number of characters from a text string, starting at the position you specify.

Cell and Range Selection

1. Ctrl + A: Select the entire worksheet.
2. Shift + Arrow Keys: Extend the selection by one cell.
3. Ctrl + Shift + Arrow Key: Extend the selection to the last non-blank cell in the same column or row as the active cell.

Advanced Navigation

1. Ctrl + Page Down: Move to the next sheet in the workbook.
2. Ctrl + Page Up: Move to the previous sheet in the workbook.
3. Alt + Tab: Switch between open applications.

Row and Column Operations

1. Ctrl + Space: Select the entire column.
2. Shift + Space: Select the entire row.
3. Ctrl + Shift + Plus Sign (+): Insert new cells, rows, or columns.
4. Ctrl + Minus Sign (-): Delete the selected cells, rows, or columns.
5. Ctrl + 0 (Zero): Hide the selected columns.
6. Ctrl + 9: Hide the selected rows.
7. Ctrl + Shift + 0 (Zero): Unhide hidden columns.
8. Ctrl + Shift + 9: Unhide hidden rows.

Workbook and Worksheet Management

1. Ctrl + N: Create a new workbook.
2. Ctrl + O: Open an existing workbook.
3. Ctrl + W: Close the current workbook.
4. Alt + F + A: Save As.
5. Shift + F11: Insert a new worksheet.
6. Alt + H + D + S: Delete the active worksheet.

Data Validation and Protection

1. Alt + D + L: Open the Data Validation dialog box.
2. Alt + R + P: Protect the worksheet.
3. Alt + R + U: Unprotect the worksheet.

Error Checking and Debugging

1. F2: Edit the active cell.
2. Shift + F3: Open the Insert Function dialog box.
3. Alt + M + X: Open the Evaluate Formula dialog box.
4. Ctrl + `: Show or hide formulas.

Printing

1. Ctrl + P: Open the Print dialog box.
2. Alt + F + P + S: Open the Page Setup dialog box.
3. Alt + P + P: Open the Print Preview window.
4. Ctrl + F2: Print Preview.

Conditional Formatting

1. Alt + O + D: Open the Conditional Formatting Rules Manager.
2. Alt + H + L + N: Create a new rule.
3. Alt + H + L + E: Edit the selected rule.
4. Alt + H + L + D: Delete the selected rule.

Charts and Graphs

1. Alt + N + C: Insert a Column Chart.
2. Alt + N + L: Insert a Line Chart.
3. Alt + N + P: Insert a Pie Chart.
4. Alt + N + B: Insert a Bar Chart.
5. Alt + N + S: Insert a Scatter Chart.
6. Alt + J + C + R: Change the chart type.

Special Functions

1. =TEXT(value, format_text): Convert a value to text in a specific number format.
2. =ROUND(number, num_digits): Round a number to a specified number of digits.
3. =SUMIF(range, criteria, [sum_range]): Sum the values in a range that meet a criteria.
4. =COUNTIF(range, criteria): Count the number of cells in a range that meet a criteria.
5. =PMT(rate, nper, pv, [fv], [type]): Calculate the payment for a loan based on constant payments and a constant interest rate.
6. =LEN(text): Return the number of characters in a text string.
7. =TRIM(text): Remove all spaces from text except for single spaces between words.

Data Analysis Tools

1. Alt + A + E: Open the Text to Columns wizard.
2. Alt + A + Q: Open the Remove Duplicates dialog box.
3. Alt + A + M: Open the Data Model view.
4. Alt + N + T: Open the PivotTable and PivotChart Wizard.
5. Alt + D + G: Open the Group and Outline settings.

Excel Macros

1. Alt + F8: Open the Macro dialog box.
2. Alt + F11: Open the Visual Basic for Applications editor.
3. Alt + F11, F5: Run the current macro in the VBA editor.

PivotTables

1. Alt + N + V: Create a PivotTable.
2. Alt + J + T + F: PivotTable Field List.
3. Alt + J + T + P: PivotTable Options.

Time-Saving Tips

1. Ctrl + ;: Insert the current date.
2. Ctrl + Shift + :: Insert the current time.
3. Ctrl + Shift + $: Apply currency format.
4. Ctrl + Shift + %: Apply percentage format.
5. Ctrl + Shift + #: Apply date format.

Collaboration and Sharing

1. Alt + R + S: Share Workbook.
2. Alt + R + M: Add a comment.
3. Alt + R + T: Track Changes.
4. Alt + W + I: Freeze Panes.

Advanced Functions

1. =INDIRECT(ref_text, [a1]): Returns the reference specified by a text string.
2. =OFFSET(reference, rows, cols, [height], [width]): Returns a reference to a range that is a specified number of rows and columns from a cell or range of cells.
3. =CHOOSE(index_num, value1, [value2], …): Returns a value from a list of values based on a specified position number.
4. =ARRAYFORMULA(formula): Enables the use of array formulas, allowing you to perform multiple calculations in one go.
5. =TRANSPOSE(array): Converts a vertical range of cells to a horizontal range, and vice versa.
6. =ARRAYFORMULA(formula): Perform calculations over an entire range of data rather than a single cell.

Data Analysis Tools

1. Alt + T + I: Open the Solver Add-In.
2. Alt + A + Y1: Perform a data analysis with the Analysis ToolPak.
3. Alt + N + D: Insert a Data Table.

Power Query and Power Pivot

1. Alt + A + P + R: Open the Power Query Editor.
2. Alt + N + V + T: Add a new table to Power Pivot.
3. Alt + N + Z: Insert a Power Map.

Advanced Charting

1. Alt + N + G: Insert a Treemap Chart.
2. Alt + N + K: Insert a Combo Chart.
3. Alt + N + F: Insert a Funnel Chart.
4. Alt + N + I: Insert a Histogram Chart.

3D Maps

1. Alt + N + V + R: Open 3D Maps.
2. Alt + N + M: Add a Map Chart.

Sparklines

1. Alt + N + S + S: Insert Sparklines.
2. Alt + N + S + O: Insert a Sparkline Column.
3. Alt + N + S + W: Insert a Win/Loss Sparkline.

Advanced Formulas and Array Formulas

1. Ctrl + Shift + Enter: Enter an array formula.
2. =SUMPRODUCT(array1, [array2], …): Multiply corresponding components in the given arrays, and return the sum of those products.
3. =MMULT(array1, array2): Returns the matrix product of two arrays.

Dynamic Arrays and Functions (Excel 365)

1. =UNIQUE(array): Returns a list of unique values in a list or range.
2. =FILTER(array, include, [if_empty]): Filters a range of data based on criteria you define.
3. =SORT(array, [sort_index], [sort_order], [by_col]): Sorts the contents of a range or array.
4. =SEQUENCE(rows, [columns], [start], [step]): Generates a list of sequential numbers in an array.
5. =RANDARRAY([rows], [columns], [min], [max], [whole_number]): Returns an array of random numbers.

Advanced Macros

1. Alt + F8: Open the Macro dialog box.
2. Alt + F11: Open the VBA Editor.
3. Alt + F11, F5: Run a macro in the VBA Editor.
4. Ctrl + Shift + F11: Insert a new module in VBA.

Slicers and Timelines

1. Alt + N + S + L: Insert a Slicer.
2. Alt + N + S + T: Insert a Timeline.

Add-Ins

1. Alt + T + I: Open the Add-Ins dialog box.
2. Alt + F + T + A: Manage Excel Add-Ins.

Tips and Tricks

1. Quick Analysis Tool (Ctrl + Q): Analyze data quickly by selecting a range and using the Quick Analysis tool.
2. Flash Fill (Ctrl + E): Automatically fill in data based on a pattern you provide.
3. Format Painter (Ctrl + Shift + C / Ctrl + Shift + V): Quickly copy formatting from one place to another.
4. Data Validation Lists: Create drop-down lists using Data Validation (Alt + D + L).
5. Name Ranges (Ctrl + F3): Define and manage named ranges for easier reference in formulas.

Custom Views

1. Alt + W + I: Open the Custom Views dialog box.
2. Alt + W + I + A: Add a new custom view.
3. Alt + W + I + S: Show a custom view.

Hyperlinks

1. Ctrl + K: Insert a hyperlink.
2. Alt + N + H: Open the Insert Hyperlink dialog box.

Collaborative Tools

1. Alt + R + S: Share Workbook.
2. Alt + R + M: Add or view comments.
3. Alt + R + T: Track Changes.

Protecting Data

1. Alt + R + P: Protect the current worksheet.
2. Alt + R + U: Unprotect the current worksheet.
3. Alt + T + P + S: Protect the workbook structure.