Without going to Excel macro there are still quite a handful of keyboard shortcuts you can master. Alt + D + G + S – Show Grouped Rows / ColumnsĪpart from the above, here are few others shortcuts that you might find useful.Alt + D + G + H – Hide Grouped Rows / Columns.Alt + D + G + U – Ungroup Rows / Columns.This is useful if you need to routinely working with columns and rows and Excel formulas. Alt + H + L + C + S – Delete Conditional Format.Alt + E + S + V – Paste Values (after Ctrl + C ) * F4 repeats the same action to other cells after pasting once.Alt + E + S + T – Paste Formatting (after Ctrl + C ) * F4 repeats the same action to other cells after pasting once.Alt + E + S + F – Paste Formula (after Ctrl + C ) * F4 repeats the same action to other cells after pasting once.Alt + H + B + P – Top Border *for adding lines provides examples of Formulas, Functions and Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.
#Insert column excel shortcut office 2003 full#
If your Excel sheet is full of color you might want to master this section of keyboard shortcuts.
#Insert column excel shortcut office 2003 plus#
Ctrl + Plus (# pad) – Insert Row / Insert Column.Ctrl + Arrowkey – Jump to Edge of Content.Use this shortcut to quickly insert a table. If you want to add an outline (outer) border around your selected cells, just use this quick shortcut. Fills the cell beneath with the contents of the selected cell. Add border to cells PC: Alt+H, B Mac: +Option+0. 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. Navigating through Excel spreadsheet could be time-consuming, especially if you are dealing with a large data-set. Here are eight useful keyboard shortcuts to speed up your work in Excel.
Ctrl + Alt + V – Paste special, will trigger the prompt for more options.Alt + W + Q – Zoom in (type in % zoom, helpful with large dataset).