Skip to main content

Posts

Showing posts from June, 2019

Microsoft Excel shortcut keys

Shortcut Description Tab Move to the next cell, to the right of the currently selected cell. Ctrl+A Select all contents of  a worksheet. Ctrl+B Bold all cells in the highlighted section. Ctrl+C Copy all cells in the highlighted section. Ctrl+D Fill down. Fills the cell beneath with the contents of the selected cell. To fill more than one cell, select the source cell and press  Ctrl+Shift+Down  to select multiple cells. Then press  Ctrl+D  to fill them with the contents of the original cell. Ctrl+F Search current sheet . Ctrl+G Go to a certain area. Ctrl+H Find and replace. Ctrl+I Puts italics on all cells in the highlighted section. Ctrl+K Inserts a hyperlink . Ctrl+N Creates a new workbook. Ctrl+O Opens a workbook. Ctrl+P Print the current sheet. Ctrl+R Fill right. Fills the cell to the right with the contents of the selected cell. To fill more than one cell, select the source cell and press  Ctrl+Shift+Right  to select multiple cells. Then press  Ctrl+R  to fill th