Ctrl+L: Create Table Box

The shortcut Ctrl+L is to display the "Create Table" dialog box, which is the same as the shortcut "Ctrl+T".

Example:

Step 1: Click anywhere in the data range, or select the data part you want to create a table;

This image has an empty alt attribute; its file name is excelctrlt001.jpg

Step 2: Press the key "Ctrl" from the keyboard and hold it, then click the letter "L" from the keyboard. This will bring up the "Create Table" window;

This image has an empty alt attribute; its file name is excelctrlt002.jpg

Step 3: Click "OK" in the "Create Table" window and the data range you selected turns into a table.

This image has an empty alt attribute; its file name is excelctrlt003.jpg

If you already created a table, you can resize the table by clicking the right-bottom corner, then hold and drag to the size you need.

Check More Excel Shortcuts

Leave a Reply