How do I keep a excel worksheets dementions, and the cell size

[mikejc1973]

I have a worksheet, A personalized Address Book that I made with the
information I would like to have.
I have adjust the cell Sizes accordingly to fit the information I need and
to have the layout that I want to keep.

Problem.. How do I save it in such a way that I can Copy it to other
worksheets, Keeping the size as I wanted, and still allowing access to the
cells to add data.

 

[ShaneDevenshire]

Hi,

If you want to maintain row height and column width you should copy the
entire sheet. You can do that by clicking the top left corner or pressing
Ctr+A twice. And then choosing copy, move to an empty sheet in a new
workbook and choose paste.

Second way to copy the entire sheet is to open both workbooks and display
them side by side - Window, Arrange, Tile. Then hold down the Ctrl key and
drag the sheet tap to the second workbook.

If this helps, please click the Yes button