If the user has about 8 worksheets and is working on the 7 th but wants to check some data on the 3 rd, then all he has to do is hold down the Ctrl button and press the page up 4 times. Ctrl + Page Up moves to the previous worksheet whereas the Ctrl + Page down moves to the next. Instead of crawling through the lines, users can jump from one worksheet to another with ease through this keyboard shortcut. The Ctrl + Page Down or Ctrl + Page Up button helps in quickly surfing through worksheets in excel. To extend the selection to the starting point in a row, combine Shift + Home and to extend the selection to the beginning of the worksheet, click Ctrl + Shift + Home buttons. When working in a cell, using the Home/End buttons allows users to conveniently move to the beginning and the end of a cell data. Users can move to the beginning of a worksheet by combining Ctrl + Home buttons. If a menu or sub-menu is open, the home button selects the first command on the visible menu. If the scroll lock is turned on, clicking the ‘Home’ button takes the user to the cell in the window’s upper-left corner. When working on the excel spreadsheet, the Home button on the keyboard conveniently takes the user back to the beginning of a row with just a click. TEXT and String Functions in Excel (26+).Lookup and Reference Functions in Excel (36+).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |