I like to prefix my ranges with “rng” to make them easier to find in formulas. This brings up a new window that allows you to name your range. The Name Manager window will appear, and you will want to click on the New button. On the Formulas tab in the ribbon, you want to select the Name Manager (or you could use the the Ctrl+ F3 keyboard shortcut instead). The next step in our process is to name our range for the “Products” Table that we just created. If you haven’t used Tables before, I recommend checking out my Excel Tables Tutorial Video. If we don't check that box, the column title will be included in our source range and will appear as one of the options in our drop-down list. Since our column begins with a header (“Products”), we want to make sure the checkbox that says “My table has headers” is checked. The Create Table window will appear, showing the range of cells that will be in your Table. The keyboard shortcut for inserting a Table is Ctrl+ T. On the Insert tab, you’ll chose the Table button. To begin, we will format our source range to be an Excel Table. Step 1 – Format the Source Range as a Table
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
May 2023
Categories |