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 cel...
Share your knowledge. It’s a way to achieve immortality.
Comments
Post a Comment