How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Zabo04 Your Own Question
Zabo04, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 283
Experience:  Experienced in Word, Excel, Access, Powerpoint, and Outlook.
Type Your Microsoft Office Question Here...
Zabo04 is online now
A new question is answered every 9 seconds

I have 5,200 cells (all in same column) in a spreadsheet that

Customer Question

i have 5,200 cells (all in same column) in a spreadsheet that i would like to transfer to another spreadsheet without changing the size of the destination column. how do i do that.
Submitted: 1 year ago.
Category: Microsoft Office
Expert:  Zabo04 replied 1 year ago.
Select the column in the spreadsheet you want to copy. Copy the data (press Ctrl+c or on the home ribbon click copy). To paste, go to the spreadsheet where you want to paste the data and click the arrow below paste. Select "Paste Special". Select the radio button next to formulas. Click Ok. This pastes all values and formulas without changing the formatting of the destination cells. You could also select "Formulas and number formats" if you have decimals specified, etc.
Expert:  Zabo04 replied 1 year ago.
If you select "Values" it will paste any numbers or text, but for any formulas the formulas are replaced by the results when you paste, so the formulas do not transfer and therefore do not calculate.
Expert:  Zabo04 replied 1 year ago.
Here are two screenshots. Let me know if you cannot find the option or it does not copy everything you want.
Expert:  Zabo04 replied 1 year ago.
Please let me know if this solved your problem or if you have questions. If you are still looking at it, there is no hurry.