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: Excel-lent Start-Up Views in Revit

15@15: Excel-lent Start-Up Views in Revit

May 5, 2025
TRAINING - VIDEO | Integrate Excel data seamlessly into Revit with Ideate Sticky. Create and publish information sheets as startup views for instant access to key project details. Enhance communication and efficiency with Ideate Sticky.
15@15: Effortlessly Eliminate Imported Revit Clutter

15@15: Effortlessly Eliminate Imported Revit Clutter

April 21, 2025
TRAINING - VIDEO | Simplify Revit object style management with Ideate StyleManager. Easily analyze, rename, merge, and remove imported styles from CAD links and exploded files. Keep your projects clean and organized with Ideate StyleManager.
15@15 Training Series: Spruce Up Your Revit Material Management

15@15: Spruce Up Your Revit Material Management

April 7, 2025
TRAINING - VIDEO | Struggling with messy Revit materials? Clean up and optimize your material and appearance assets with Ideate StyleManager. Learn how to analyze, rename, merge, and remove unused elements to keep your projects running smoothly.
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.
Show More