TToolardo
← Useful Tips
Microsoft ExcelExcel

Ctrl + T: Turn a data range into an Excel Table

Use Ctrl + T to turn a data range into an Excel Table. Useful for quick spreadsheet editing and formula debugging.

Ctrl + T

Why it helps

Use Ctrl + T to turn a data range into an Excel Table. Useful for quick spreadsheet editing and formula debugging.

How to use it

  1. Open the relevant app or terminal.
  2. Use the shortcut or command above in the relevant context.
  3. Check the result; for commands that change data, test on a small example first.
People also search for
Ctrl + T: Turn a data range into an Excel TableCtrl + Tturn a data range into an excel tablehow to turn a data range into an excel tableMicrosoft Excel turn a data range into an excel table

Related tips

Microsoft ExcelCtrl + ;

Ctrl + ;: Insert today’s date

Use Ctrl + ; to insert today’s date. Useful for quick spreadsheet editing and formula debugging.

Microsoft ExcelCtrl + Shift + ;

Ctrl + Shift + ;: Insert the current time

Use Ctrl + Shift + ; to insert the current time. Useful for quick spreadsheet editing and formula debugging.

Microsoft ExcelCtrl + `

Ctrl + `: Toggle formula view

Use Ctrl + ` to toggle formula view. Useful for quick spreadsheet editing and formula debugging.

Microsoft ExcelF4 while editing a formula

F4 while editing a formula: Cycle absolute and relative cell references

Use F4 while editing a formula to cycle absolute and relative cell references. Useful for quick spreadsheet editing and formula debugging.