vurapt.blogg.se

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.į9: Calculate all worksheets in all open workbooksĬtrl+Shift+U: Expand or collapse the formula barį11: Create a bar chart based on selected data (on a separate sheet)Īlt+F1: Create an embedded bar chart based on select data (same sheet)Ĭtrl+F: Search in a spreadsheet, or use Find and ReplaceĪlt+F8: Create, run, edit, or delete a macroĪlt+F11: Open the Microsoft Visual Basic For Applications EditorĬtrl+Left/Right Arrow: Move to the farthest cell left or right in the rowĬtrl+Up/Down Arrow: Move to the top or bottom cell in the columnį5 or CTRL + G: Go to any cell by pressing F5 and typing the cell coordinate or cell name. Page Up/Down: Move one screen up or down in a worksheetĪlt+Page Up/Down: Move one screen to the right or left in a worksheetĬtrl+W / CTRL + F4: Close a workbook (Alt + Space + C)į4: Repeat the last command or action. Home: Go to the leftmost cell in the current row (or go to the beginning of the cell if editing a cell)Ĭtrl+Home: Move to the beginning of a worksheetĬtrl+End: Go to the most bottom right used cell

Shift+Left/Right Arrow: Extend the cell selection to the left or rightĬtrl+Shift+Space: Select the entire worksheet Watch Video: 101 Excel Shortcuts Keys that will help to increase your Excel speedġ01 Shortcut of Excel in Hindi | Excel Shortcut in HindiĬtrl+Page Up/Down: Move to the previous or next worksheet.Download – 101 Shortcuts of Excel in Hindi.101 Shortcut of Excel in Hindi | Excel Shortcut in Hindi OMR Sheet Pdf Download 100 Questions ERP9 Tally Shortcut Keys PDF.