Unless someone else does have a sneaky method, I am afraid it is going to be model the holes.
Even if you could use a transparent material, it would still appear solid in elevation unless you turn on transparency in the elevation settings.
Then all of the glass in your windows will also become transparent and you will see everything inside the building.
With regards to modelling, would the new curtain wall tool be a valid solution for the repeating holes.
I rarely use the curtain wall tool so don't really know without experimenting.
Barry.
One of the forum moderators.
Versions 6.5 to 27
Dell XPS- i7-6700 @ 3.4Ghz, 16GB ram, GeForce GTX 960 (2GB), Windows 10
Lenovo Thinkpad - i7-1270P 2.20 GHz, 32GB RAM, Nvidia T550, Windows 11