Toggle Total Row in Excel (Ctrl + Shift + T)
The Toggle Total Row shortcut allows you to quickly show or hide the Total Row at the bottom of an Excel table. This row summarizes your table data using built-in functions like SUM, AVERAGE, COUNT, etc.
Keyboard Shortcut
| Windows | Mac |
|---|---|
| Ctrl + Shift + T | Cmd + Shift + T |
What Does This Shortcut Do?
Pressing this shortcut toggles the visibility of the Total Row in the active table. If the Total Row is hidden, it will appear; if it’s visible, it will be hidden.
How to Use the Shortcut
- Click anywhere inside the table
- Press Ctrl + Shift + T (Windows) or Cmd + Shift + T (Mac)
- The Total Row will appear or disappear
- Repeat the shortcut to toggle again
Tips & Best Practices
- Use the Total Row for quick calculations without inserting extra formulas
- Combine with table styles to highlight total values
- Ensure you are inside a table; this shortcut does not work on normal ranges
FAQ
- Q: Can I customize the functions in the Total Row?
- Yes, click the drop-down in each cell of the Total Row to select functions like SUM, AVERAGE, COUNT, etc.
- Q: Does this shortcut work in filtered tables?
- Yes, the Total Row adjusts calculations based on visible data.