Shift + Home key : Expand the selected area to the first cell of the row.Ĭtrl + Shift + Home : Expand the selection to the first of the spreadsheet.Ĭtrl + Shift + End : Expand the selection to the last cell used on the spreadsheet (lower right corner). Shift + Page Down / Shift + Page Up : Expand the selected area to the bottom of the screen page / to the top of the screen. Shift + arrow keys : Expand the selection from a selected cell. Shift + Space key : Select the entire row.Ĭtrl + Space (Spacebar) : Select the entire column.Ĭtrl + Shift + * key (asterisk) : Select the entire area around the active cells.Ĭtrl + A (or Ctrl + Shift key + spacebar) : Select the entire worksheet (or the data container area).Ĭtrl + Shift + Page Up : Select the current and previous sheet in the same Excel file. Working with selected data: Select cells:
Home : Move to the first cell of a row in a spreadsheet.Ĭtrl + Home : Move to the first cell of a spreadsheet.Ĭtrl + End : Move to the last cell containing the content on a spreadsheet.Ĭtrl + F : Display the Find and Replace dialog box (open Search - Find).Ĭtrl + H : Display the Find and Replace dialog box (Open Replace - Replace).Ĭtrl + G (or F5) : Display the 'Go to' dialog box.Ĭtrl + left arrow / Ctrl + Right arrow : Inside a cell: Move to the left or right cell of that cell.Īlt + down arrow : Displays the AutoComplete list. T ab / Shift + Tab : Move a cell to the right / left in a spreadsheet.
Page Down / Page Up : Scroll to the bottom of the spreadsheet / top of the spreadsheet.Īlt + Page Down / Alt + Page Up : Move the screen to the right / left in a spreadsheet. Excel 2007, Excel 2010 shortcuts navigate in spreadsheets:Īrrow keys : Move up, down, left, or right in a spreadsheet.
Join the Network Administrator to collect your priceless Excel shortcuts in the summary below. If you can master the formulas, the shortcut key combination on Excel will be much faster and more convenient. However, if you use a mouse to calculate calculations, it will greatly reduce the speed. The basic functions in Excel will help a lot in computing, when the number of formulas you handle is too "terrible". With Microsoft Excel, calculations will become easier especially with accountants. 8 convenient tools in Excel you may not know yet.10 ways to recover corrupted Excel files.The more you upgrade the version, the Office suite not only changes the interface, but also provides many useful features to cater to a variety of needs such as editing, presenting or calculating user data. There is no denying the dense coverage of Microsoft Office software worldwide, as the number of users is increasing especially when the big Microsoft launches the latest version of Office 2016.
0 kommentar(er)
