Ask Experts Questions for FREE Help !
Ask
    jtbackus50's Avatar
    jtbackus50 Posts: 2, Reputation: 1
    New Member
    		  
    #1

    Oct 16, 2013, 08:52 AM
    Copying excel worksheet format to new worksheet
    I am building a multi tenant report, separate sheet for each tenant that reports to a master sheet
    I want to copy a form from one sheet to another and keep the format (column width)

    Can this be done? How, Thanks
    Curlyben's Avatar
    Curlyben Posts: 18,514, Reputation: 1860
    BossMan
    		  
    #2

    Oct 16, 2013, 08:54 AM
    Right click Tab
    Select move or Copy
    Select the position
    CHECK create copy box
    Click OK
    jtbackus50's Avatar
    jtbackus50 Posts: 2, Reputation: 1
    New Member
    		  
    #3

    Oct 16, 2013, 09:03 AM
    Thanks but I must be missing something in the directions
    I am not finding these

    TAB ? What is TAB?
    CHECK create copy box
    Click OK
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Preparing an accounting worksheet using excel [ 1 Answers ]

Prepare work sheet showing trial balance, adjustments, adjusted trial balance, income and balance sheet.

Copying Cells form one worksheet to another [ 1 Answers ]

Hi, I have a worksheet that at the end of everyday a button is pushed and the data form a range of cells is copied into another worksheet.. The only thing is I can only get it to copy into cerntain cells on the other worksheet, meaning that the previous nights data is over-written. How...

Excel: Linking from one worksheet to another [ 8 Answers ]

I'd like to link from a cell in one worksheet to a LINE in another. If that doesn't make sense, I've got a member list of people with address, phone, etc. For folk that have not renewed this year, I want to have a separate worksheet that documents my contact efforts... so to link from the...

Gridlines for MS Excel Worksheet [ 1 Answers ]

Hi: I have installed MS Excel 2000 and MS Excel 2003 on my two emachines computers with Windows XP. Both versions of Excel are perfect on one computer, but they are not on the other one. On my second computer, Excel worksheets of both versions never have gridlines. The sheets or tables look...

View more questions Search