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.

X

Ideate Software is compliant with the General Data Protection Regulation (GDPR). We’ve updated our Privacy Policy and Terms of Use to reflect this. Please read these updated terms and take some time to understand them.

Note: We use cookies to improve your browsing experience and help us improve our website.

By continuing to use our website, you agree to the terms of use and to our use of cookies.

I ACCEPT