Manage the Size of Sticky with Ideate Sticky for Revit

The size of a Sticky in Revit is determined by the named regions defined within the associated Excel worksheet. Ideate Sticky will default to use the defined Print Area (which is a type of named region in Excel) if it is available. Learn more about this in the Help topic: Preparing the Excel File in Ideate Sticky for Revit. Once the Sticky has been created within Revit, it can be re-sized. Note that any changes to the size will be overwritten if the Sticky is updated (manually or automatically), so the recommended method of changing the size is to edit the Excel file itself. Within the Ideate Sticky Sample Files for Revit Modeling folder you can try these two Excel files that have been setup to fit the height of a typical imperial and metric Revit sheet:

Managing Multiple Pages

The Revit Schedule Header cannot be split, so to divide a single Excel worksheet into multiple Stickies,we recommend using Named Regions within Excel to define the size of each 'page' and then consider using the Excel function to repeat the rows along the top with each region.

To make a Named Region in Excel:

  1. Within Excel, use the mouse to select a number of cells as shown in the image below.  This is also known as a region.

  2. In the upper left corner edit the name of the selected region.  (You may also right-click on the mouse when the cells have been selected and select the Define Name option.) The region name cannot have any spaces.  These regions can later be modified in Excel from the Formulas tab> Defined Names> Name Manager.

Examples of multi-page Stickies can be seen within these Ideate Sticky Sample Files for Revit Modeling: ISB-Multi-Page_Spec.xls and ISB-Multi-page_Revisions-Fixed_Length.xlsx.

To make a Named Region in Excel with Ideate Sticky for Revit

Repeat Rows at Top

Ideate Sticky will utilize Excel’s ability to include certain rows with every region or Print Area defined.  This is very useful when dealing with long documents.  To access this Excel function, go to the Page Setup tool and within the Sheet tab, specify a range such as $1:$5, to ensure that every page always includes these (5) rows.

Submit feature or issue request for Ideate Software

Thank you for taking time to inform us about a bug or feature request.

By entering your data above and clicking ‘SUBMIT’ you are consenting to the collection and use of that data to respond to your comments and inquires, as described in our Privacy Policy. We may also transfer the data you submit in the ‘Email Us’ form to our VAR partners for the limited purpose of a sales follow-up. Please review our Privacy Policy for more details on how and when we collect data and what we use it for.