MS Excel Shortcut Keys & Formulas Finder
Quickly find Excel shortcuts and formulas to boost your productivity. Perfect for students and professionals!
How to Use This Tool:
1. Type in the search box to find specific shortcuts or formulas
2. Click the keyword buttons below to instantly see related Excel features
3. Browse the tables to discover new time-saving tricks
Shortcut Keys
| Function | Shortcut | Description | ๐ |
|---|---|---|---|
| Copy | Ctrl + C | Copies selected cells | ๐ |
| Paste | Ctrl + V | Pastes copied content | ๐ |
| Cut | Ctrl + X | Moves selected data | ✂️ |
| Undo | Ctrl + Z | Reverts last action | ↩️ |
| Redo | Ctrl + Y | Repeats last undone action | ↪️ |
| Save | Ctrl + S | Saves current file | ๐พ |
| Ctrl + P | Prints the spreadsheet | ๐จ️ | |
| Bold | Ctrl + B | Applies bold formatting | ๐ |
| Italic | Ctrl + I | Applies italic formatting | ๐ผ |
| Underline | Ctrl + U | Applies underline formatting | ๐ |
| Find | Ctrl + F | Opens find dialog | ๐ |
| Replace | Ctrl + H | Opens find and replace dialog | ๐ |
| New Workbook | Ctrl + N | Creates a new workbook | ๐ |
| Open Workbook | Ctrl + O | Opens an existing workbook | ๐ |
| Close Workbook | Ctrl + W | Closes current workbook | ❌ |
| Insert Hyperlink | Ctrl + K | Inserts a hyperlink | ๐ |
| Insert Table | Ctrl + T | Converts range to table | ๐ |
| AutoSum | Alt + = | Inserts SUM function automatically | ∑ |
| Edit Cell | F2 | Enters cell edit mode | ✏️ |
| Calculate Sheet | F9 | Recalculates formulas | ๐ |
| Create Pivot Table | Alt + N + V | Opens PivotTable dialog | ๐ |
| Insert Chart | Alt + F1 | Creates embedded chart | ๐ |
| Apply Filter | Ctrl + Shift + L | Toggles filters on/off | ๐ |
| Conditional Formatting | Alt + H + L | Opens conditional formatting menu | ๐จ |
| Format Cells | Ctrl + 1 | Opens Format Cells dialog | ๐️ |
Common Excel Formulas
| Formula | Usage | Description | ๐ |
|---|---|---|---|
| =SUM(A1:A10) | Summation | Adds values from A1 to A10 | ➕ |
| =AVERAGE(A1:A10) | Average | Calculates the average of selected cells | ๐ |
| =IF(A1>10, "High", "Low") | Conditional | Returns "High" if A1 > 10, else "Low" | ๐ข |
| =VLOOKUP(1001, A2:C10, 2, FALSE) | Lookup | Searches for 1001 and returns the corresponding value from the second column | ๐ |
| =HLOOKUP(50, A1:Z3, 2, FALSE) | Horizontal Lookup | Searches for 50 in the first row and returns the corresponding value from the second row | ๐ |
| =NOW() | Current Date/Time | Returns current system date and time | ⏰ |
| =LEFT(A1, 4) | Text Extraction | Extracts first 4 characters from A1 | ๐ค |
| =CONCATENATE(A1,B1) | Text Combination | Combines text from A1 and B1 | ๐ |
| =COUNTIF(A1:A10,">5") | Conditional Count | Counts cells greater than 5 in range | ๐ข |
| =SUMIF(A1:A10,">5") | Conditional Sum | Sums cells greater than 5 in range | ➕ |
| =INDEX(A1:C10,2,3) | Array Reference | Returns value at 2nd row, 3rd column of range | ๐ |
| =MATCH("Apple",A1:A10,0) | Position Finder | Returns position of "Apple" in range | ๐ |
| =ROUND(A1,2) | Number Formatting | Rounds A1 to 2 decimal places | ⏺️ |
| =TRIM(A1) | Text Cleanup | Removes extra spaces from text | ๐งน |
| =LEN(A1) | Text Length | Returns number of characters in A1 | ๐ |
| =DATE(2023,12,31) | Date Creation | Creates date value for Dec 31, 2023 | ๐ |
| =NETWORKDAYS(start,end) | Workday Count | Counts workdays between two dates | ๐ |
| =PMT(rate,nper,pv) | Loan Payment | Calculates loan payments | ๐ฐ |
| =PV(rate,nper,pmt) | Present Value | Calculates present value of investment | ๐ต |
| =PIVOTDATA() | Pivot Table | References data in a PivotTable report | ๐ |
| =FILTER(A1:C10,B1:B10="Yes") | Filter | Filters range based on criteria | ๐ |
| =TEXTJOIN(",",TRUE,A1:A10) | Text Function | Combines text with delimiter | ๐ค |
| =EOMONTH(start,months) | Date Function | Returns last day of month | ๐ |
| =NPV(rate,value1,[value2],...) | Financial | Net present value of investment | ๐ฒ |
No comments:
Post a Comment