Excel Row & Column Formatting Short cut Keys

  1. To select the entire Row – Shift + Space
  2. To select the entire Column – Ctrl + Space
  3. To delete a column – Alt + H + D+ C
  4. To delete a row – Shift + Space, Ctrl + –
  5. T o hide a selected row – Ctrl + 9
  6. To unhide a selected row – Ctrl + Shift + 9
  7. To hide a selected column – Ctrl + 0
  8. To unhide a selected column – Ctrl + Shift + 0
  9. To group rows or columns – Alt + Shift + Right Arrow
  10. To ungroup rows or columns – Alt + Shift + Left Arrow

Leave a comment

Your email address will not be published. Required fields are marked *