Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
CrippledKnight
CrippledKnight asked in Computers & InternetSoftware · 1 decade ago

How to Copy & Paste Cells in Excel... (Intermediate-Advanced)?

Hello, Well Im working on a project and I need to copy and paste the same cell on different tabs. The thing is that every time I copy it, even though all the columns are copied, it does not copy it's width. Is there a way copy the column along with the width on numerous tabs? Thanks.

Update:

I even went ahead and the copy form edit button does not even show up on the quick access tool bar customizable buttons. It's not on the whole list. Any idead?

Update 2:

All right it IS helpful but I'm working on Excell 2007, and I don't have that option on top. Know where exactly the copy form edit option is on 2007? Thanks in advance.

Update 3:

I even went ahead and the copy form edit button does not even show up on the quick access tool bar customizable buttons. It's not on the whole list. Any idead?

Update 4:

I did found a way to auto edit all column witdth. But even though I don't have to do it column by column, I still have to do it Tab by tab. Thanks in advance...

Update 5:

Thanks a lot Serena and Deep thought (Deep Thought) you really helped me out... You have no Idea how many hours of work a day you have saved me...

3 Answers

Relevance
  • Anonymous
    1 decade ago
    Favorite Answer

    Use Ctrl + V. Then press the paste options button on the right corner of the cell. Then press the W key.

    Source(s): Tried it out myself and it worked.
  • Anonymous
    1 decade ago

    Open an existing Excel file to edit or create a new one. When creating a new file, select "New" from the "File" menu. To edit an existing file, select "Open" from the "File" menu.

    Step

    2Enter data that you want to copy into a cell or identify a cell that you wish to copy that already has data in it. Select the text by highlighting the exact text you want to copy within the textbox at the top of the screen or by clicking the individual cell the text is in.

    Step

    3Copy the selected text or cell by selecting "Copy" from the "Edit" menu at the top of the screen. You can also use a shortcut key by holding the "Ctrl" and "C" keys on your keyboard to copy the data. A third option would be to right-click your mouse and select "Copy" from the short-cut menu that pops up.

    Step

    4Select the cell you wish to paste the copied text into by clicking on it. Paste the data into the selected cell by choosing "Paste" from the "Edit" menu. To use a shortcut key you can hold the "Ctrl" and "V" keys down to paste the data more quickly or right-click the mouse again and select "Paste" from the short-cut menu that pops up.

    Step

    5Continue editing, copying and pasting data until all the data is entered in your spreadsheet. Save your work by selecting "Save" or "Save As" from the "File" menu.

  • Anonymous
    4 years ago

    continually extra powerful to earnings as much as feasible, yet uncomplicated skills contain _ including time(as much as 24 hours), including time (extra desirable than 24 hours), conditional formatting (functional for spreadsheets), using arithmatical calculation fundamentals (+ - / *), and discover and replace. those ought to get you thru a lot of excel projects. The excel help prog is extremely stable besides.

Still have questions? Get your answers by asking now.