Logo

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

15@15 Training Series

15@15 Training Series

March 31, 2025
TRAINING - NEWS | Leveling up your BIM game with Ideate Software doesn’t have to hard or time-consuming with our 15@15 Training Series. This series of 15-minute online sessions cuts right to the chase with essential information to enhance your skills, unlock new efficiencies and elevate your ability to automate tedious tasks —all while reducing errors in your Revit model.
15@15: Elevate Your Title Block With Style

15@15: Elevate Your Title Block With Style

March 26, 2025
TRAINING - VIDEO | Is your Revit title block a mess? Inconsistent styles can slow you down, but Ideate StyleManager can help. Discover how to clean up and streamline your title block for a more efficient workflow.
Ideate Software Boosts Quality, Transparency & Efficiency for pbr

Ideate Software Creates Decisive Increases in Quality, Transparency and Efficiency for Architecture Firm, Planungsbüro Rohling AG - pbr

March 18, 2025
CLIENT TESTIMONIAL - ARTICLE | When the Germany-based architecture firm pbr set out to reinvigorate its ongoing commitment to enhancing precision and efficiency, they turned to Ideate Software to help them automate repetitive, simple tasks and empower their entire team, from junior designers to senior architects, with tools that support productivity and reduce errors.
15@15: Rev Up Your Revit Project Health with the Model Check-Up

15@15: Rev Up Your Revit Project Health with the Ultimate Model Check-Up

March 11, 2025
TRAINING - VIDEO | Are you ready to transform the way you manage your Revit projects? Poorly managed models can lead to slow performance, sync issues, and even crashes—but you can avoid these headaches with the right approach.
Show More
Share by: