Skip to main content

logoCorrectSize.png

Adaptive Insights LLC.

Use Named Ranges

Named Ranges

To link a table from OfficeConnect for Excel to OfficeConnect for PowerPoint,  define the table as a named range.

named range is a user-defined area of cells, rows, or columns in an Excel file. With a named range, you can perform operations on that area as a whole. For example, you can jump quickly to the named range from wherever you are in the workbook. Also, you can copy a named range from OfficeConnect for Excel and link it in a PowerPoint slide.

Within a named range, you can move or change data, and add or delete rows or columns.  The named range maintains its integrity as a single object.  Any change you make to the named range in Excel, the change is reflected in PowerPoint as soon as you refresh the presentation.

Search for Named Ranges in Excel online help for information.

 

  • Was this article helpful?