HrformatsI am attaching herewith the excel formula sheet. Please go through and let me know your valuable inputs.
| Function keys in Microsoft Excel | ||||||
| Function Key | SHIFT | CTRL | ALT | CTRL+SHIFT | ALT+SHIFT | |
| F1 | Display Help or the Office Assistant | What’s This? | Insert a chart sheet | Insert a new worksheet | ||
| F2 | Edit the active cell | Edit a cell comment | Save As command | Save command | ||
| F3 | Paste a name into a formula | Paste a function into a formula | Define a name | Create names by using row and column labels | ||
| F4 | Repeat the last action | Repeat the last Find (Find Next) | Close the window | Exit | ||
| F5 | Go To | Display the Find dialog box | Restore the window size | |||
| F6 | Move to the next pane | Move to the previous pane | Move to the next workbook window | Move to the previous workbook window | ||
| F7 | Spelling command | Move the window | ||||
| F8 | Extend a selection | Add to the selection | Resize the window | Display the Macro dialog box | ||
| F9 | Calculate all sheets in all open workbooks | Calculate the active worksheet | Minimize the workbook | |||
| F10 | Make the menu bar active | Display a shortcut menu (right click) | Maximize or restore the workbook window | |||
| F11 | Create a chart | Insert a new worksheet | Insert a Microsoft Excel 4.0 macro sheet | Display Visual Basic Editor | ||
| F12 | Save As command | Save command | Open command | Print command | ||
Thank u for your valuable post. Please let me know to use Vlookup with example.
I need this excel sheet.