Tables make it much easier to rearrange data with drag and drop. Watch the video below for a quick rundown. These shortcuts make selections that run precisely to the edge of the table, even when you can't see the edge of the table. For example, you can select rows with shift + space, and columns with control + space. When you convert regular data to an Excel Table, almost every shortcut you know works better. Excel will navigate to the table, even if it's on a different tab in a workbook. Just click the menu, and select the table. Like named ranges, tables will appear in the namebox dropdown menu. When you click OK, Excel will create the table. First, remove blank rows and make sure all columns have a unique name, then put the cursor anywhere in the data and use the keyboard shortcut Control + T.
You can create an Excel Table in less than 10 seconds. If you need a range that expands to include new data, and if you want to refer to data by name instead of by address, Excel Tables are for you. This article provides an introduction and overview. Excel Tables are one of the most interesting and useful features in Excel.
0 kommentar(er)
