Excel template for a title block?

I am trying to recreate a title block from an Autocad drawing into excel. The title block doesn't need to be exactly the same but just a general title block. I was wondering if anyone has a template I could use. I want the Title Block to be fixed onto the spreadsheet (if that makes sense) so that the cells do not move around when I edit the info on the spreadsheet.

More like an image? Just an idea here, but do the titleblock in Autocad and export as JPG (JPGOUT) and then insert in Excel?

I am trying to recreate a title block from an Autocad drawing into excel. The title block doesn't need to be exactly the same but just a general title block. I was wondering if anyone has a template I could use. I want the Title Block to be fixed onto the spreadsheet (if that makes sense) so that the cells do not move around when I edit the info on the spreadsheet.

Open the title block in Acad and plot to jpeg using the publish to web-jpeg .pc3 plot file (if you haven't got one then create one using the add a plotter wizard in plotter manager).

When you have the jpeg go to excel and insert as a picture, if you want the background to be transparent then select the image and click the 'set tansparent colour' tool on the picture toolbar then click a white area of the image.

You can also right click on the image and pick format image, in there you have options to move the image with cells or keep it where it is when formatting cells.

Does that help?

Thanks for the replies.

I can't really do it as a jpeg because I will need to edit the dates/revisions etc.

I was hoping it would be something I could perhaps create in a header?

Make it GIF andset the desired areas transparent, so that you can see the data in the cell behind the image.

Or draw the relevant cell borders with thick lines and merge the cells until you get something like the title data block.

I didn't try these methods. Maybe they will work, maybe they wont.

Hi, I've decided just to put the title block in the header for now as an image, it will have to do. I hate excel but for some reason my client wants cable schedules in excel and not autocad, even though I have Autocad Electrical! The mind boggles!

Thanks for the replies!