excel tables import into layout view

Question

Hi all,
I am trying to mimic a mxd that was done a year ago with updated data. The layout view has monitoring sites that have updated 
data. The problem I have is I want to make the tables look EXACTLYthe same as the previous. The tables have been imported from 
excel done through cut-and-paste. I am trying to copy the font, borders, color, etc, but it's a little different. I'm curious if there was a "better" way
to get the tables to look alike. I can get it close, but it's not exact.

Thanks all and have a good weekend,

R~

nimitz · Answer

I would open a new excel spreadsheet, and copy and paste from the old file to the new file, then insert that new file into the layout.

PERFECT! This worked out great!

DonovanCameron · Answer

The second method you cite is keeping the size and font EXACTLY what I need, HOWEVER, when I insert the 
excel spreadsheet, it's adding on extra rows (blank ones). I'm wondering how to just insert the rows I need. I assume it has 
something to do with the excel formatting in the file I'm insert?

I've never had that happen. My only issues were the opposite with not all records being displayed because there were too many.

Sounds like there could be a suspect character (like a space) or some type of formatting (border lines applied, cell format -number or text is explicitly defined) in a cell somewhere down there.

I would open a new excel spreadsheet, and copy and paste from the old file to the new file, then insert that new file into the layout.

nimitz · Answer

Hey Don,
Thanks for the reply. The second method you cite is keeping the size and font EXACTLY what I need, HOWEVER, when I insert the 
excel spreadsheet, it's adding on extra rows (blank ones). I'm wondering how to just insert the rows I need. I assume it has 
something to do with the excel formatting in the file I'm insert?

Thanks