Selecting a Formatted Table in a Formula

You can select a formatted table when you have a cell or range selected in the table by pressing Ctr + A. But that shortcut won’t work when creating a formula that refers to a formatted table.

To select the table in a formula you must click a cell in the table and press Ctrl + Shift + Spacebar.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.