![]() Alt+F11: Open the Microsoft Visual Basic For Applications Editor.Alt+F8: Create, run, edit, or delete a macro.Ctrl+Tab: Switch between open workbooks.Ctrl+F: Search in a spreadsheet, or use Find and Replace.Alt+F1: Create an embedded bar chart based on select data (same sheet).F11: Create a bar chart based on selected data (on a separate sheet). ![]() Ctrl+Shift+U: Expand or collapse the formula bar.F9: Calculate all worksheets in all open workbooks.Alt+Q: Go to the “Tell me what you want to do” box. ![]() For example, if the last thing you typed in a cell is “hello,” or if you change the font color, clicking another cell and pressing F4 repeats that action in the new cell. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |