Ctrl+Page Up/Down: Move to the previous or next worksheetĭownload the Excel Shortcut list in PDF format using the link given below. 
Alt+Page Up/Down: Move one screen to the right or left in a worksheet.I love to use Keyboard Shortcuts in Microsoft Excel and Word. Page Up/Down: Move one screen up or down in a worksheet Find out how you can download my charts and video recordings for Free.
Ctrl+Home: Move to the beginning of a worksheet. Home: Go to the leftmost cell in the current row (or go to the beginning of the cell if editing a cell). F5: Go to any cell by pressing F5 and typing the cell coordinate or cell name. Ctrl+End: Go to the most bottom right used cell. Ctrl+Up/Down Arrow: Move to the top or bottom cell in the column. Up/Down Arrow: Move one cell up or down. Ctrl+Left/Right Arrow: Move to the farthest cell left or right in the row. Left/Right Arrow: Move one cell to the left or right. You can use keyboard shortcuts to easily navigate throughout your worksheet, within a cell, or throughout your entire workbook. 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. F4: Repeat the last command or action. कंप्यूटर हिंदी नोट्स पीडीऍफ़ डाउनलोड करें.Excel Shortcut list PDF Download for free using the direct download link given at the bottom of this article.įirst, let’s take a look at some general keyboard shortcuts for manipulating workbooks, getting help, and a few other interface-related actions. What is Ribbon in MS-Excel? Ribbon Features in MS-Excel. History and Development of Microsoft Excel. How to use MS-Excel? What is MS-Excel in Hindi? How to start MS-Excel? Features of MS-Excel in Hindi. Learning MS-Excel in Hindi Computer Notes PDF. How to use MS-Excel? Elements of MS-Excel Program. Tags - What is MS-Excel? Uses of MS-Excel. ITI-COPA MS-Excel Practical MS-Excel Practicals for Computer Courses ITI-COPA, CCA, DCA, PGDCA, BCA and Competitive Examinations. Tags - What is MS-Excel? Applications of MS-Excel. In a workbook: activate previous workbook 
While typing a formula, switch between absolute /relativeĬreate name by using names of row and column labels
0 kommentar(er)
