Pro Tips for Renumbering Sheets

Ideate BIMLink can be utilized to batch rename and renumber sheets in your Revit project.


The Revit interface has limitations in terms of editing large amount of data. Ideate BIMLink allows you to edit model data by exporting it to Excel and pushing it back into Revit. The basic steps for this process are covered in our Help topic: How to Batch Rename or Renumber Sheets.


If you need to tackle some more complex challenges, in this blog post I’ll highlight the power of Excel functions and formulas when utilizing Ideate BIMLink for sheet renumbering.


Here is an example: 

Pro Tips for Renumbering Sheets
  1. Utilize the adjacent column to enter the following formula, then drag down to autofill the values.

    =LEFT(A1,1)&"."&TEXT((RIGHT(A1,3)+10),"000")

    List of Excel functions utilized in this function:
Pro Tips for Renumbering Sheets

2. Copy the resulting information from column B and use the Paste Special>Values function to move the data back into Sheet Number column, save Excel, and import it back into Revit via Ideate BIMLink.

Pro tips for renumbering sheets

This is the result:

Renumbering Sheets

Explore recent posts

Create 3D Views with Ideate ViewCreator
June 26, 2025
TRAINING - VIDEO | Boost your Revit productivity with the new Create from Scratch feature in Ideate ViewCreator! Easily generate 3D views by level and scope box, customize names with find & replace, and streamline sheet creation—all in just a few clicks.
Batch Create Area Plan Views with Ideate ViewCreator
June 26, 2025
TRAINING - VIDEO | Batch create Revit views in a snap with Ideate ViewCreator! From selecting element types to placing views on sheets, this tool makes it quick and painless to generate multiple area plans—all with smart naming and sheet placement options built in.
Keep Ideate SmartDelete Dialog Open While Working in Revit
June 26, 2025
TRAINING - VIDEO | Say hello to a smoother, smarter Ideate SmartDelete! Now modeless, you can keep the tool open while exploring your Revit model—no more back-and-forth. Instantly see which elements have dependencies, navigate effortlessly, and take control of your working set like never before.
Align Viewports with Ideate Align
June 26, 2025
TRAINING - VIDEO | Align views like a pro with the latest update to Ideate Align! Now you can position views and titles on sheets using data from linked Revit files—no more guesswork. Perfect for consultants, core & shell teams, and anyone working with site files.
Show More