If data exists in clipboard: Display the Insert dialog box to insert blank cells.Įdit the active cell with cursor at end of the line.ĭelete the character to the left of the insertion point, or delete the selection. If data exists in clipboard: Display the Paste Special dialog box. Paste content from clipboard into selected cell. Insert and Edit Data Undo / Redo Shortcuts Shortcut Key Select from the insertion point to the beginning / to the end of the cell. Select or unselect one word to the left / to the right. Select or unselect one character to the left / to the right.Ĭtrl+Shift+Arrow Left/Ctrl+Shift+Arrow Right Move active cell right / left in a selection. Usearrow keys and shift+arrow keys to add to selection. Select only the active cell when multiple cells are selected.Īdd another (adjacent or non-adjacent) range of cells to the selection. Move active cell down / up in a selection. Move to the right / to the left between non-adjacent selections (with multiple ranges selected). Move clockwise to the next corner of the selection. Turn on extension of selection with arrow keys without having to keep pressingshift. Select the current and previous sheet in a workbook.Įxtend the selection to the beginning of the row.Įxtend the selection down one screen /up one screen. Select the current region around the active cell.Įxtend the selection to the last cell with content in row or column.Įxtend the selection to the last used cell on the worksheet (lower-right corner).Įxtend the selection to the beginning of the worksheet. Pressing ctrl+a a second time then selects entire worksheet. Select the entire worksheet or the data-containing area. Work with Data Selections Select Cells Shortcut Key Move one cell to the right / to the left in a worksheet. Move one screen down / one screen up in a worksheet. Inside a cell: Move to the beginning / to the end of a cell entry. Move to the beginning of a row in a worksheet. From here use arrow keys to move by blocks of data, home to move to last cell, or enter to move to the last cell to the right. In End mode, press arrow keys to move to the next nonblank cell in the same column or row as the active cell. Move to the last cell with content on a worksheet.ĭisplay the Find and Replace dialog box (with Find selected).ĭisplay the Find and Replace dialog box (with Replace selected). Inside a cell: Move one word to the left / to the right. Move to the edge of next data region (cells that contains data) Move one screen to the right / to the left in a worksheet.
Move one cell up, down, left, or right in a worksheet.ĭisplay the AutoComplete list e.g.
EXCEL KEYBOARD SHORTCUTS REARRANGE SHEET PDF
Click Here to download PDF print version.
EXCEL KEYBOARD SHORTCUTS REARRANGE SHEET WINDOWS
keyboard layout and Windows Operation system. Note: The complete list of Excel 2010 keyboard shortcuts are for U.S.
0 kommentar(er)
