Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 -- Thanks, Shane Devenshire "mikejc1973" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
format all excel worksheets the same orientation, size | Excel Discussion (Misc queries) | |||
copying worksheets size mismatch | Excel Discussion (Misc queries) | |||
How to preserve cell size when pasting between worksheets? | Excel Discussion (Misc queries) | |||
Cell Size Between Worksheets when performing a copy and paste | Excel Discussion (Misc queries) | |||
Cell size? Or size limit for Text data type? | Excel Discussion (Misc queries) |