Forum Discussion

abdullah.alduhaishi's avatar
abdullah.alduhaishi
Copper Contributor
Jan 29, 2018

Excel Challenge

Hi All, Your kind support appreciated with below Excel case... How to copy a raw [put in mind the row is formula and not a value] and paste it in another sheet as a column ? Since it's a formul...
Excel
Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Jan 29, 2018

Abdullah,

 

No matter if the content of the row is formulas or values!

 

Follow these steps:

  • Select the row and copy it.
  • Go to another location and press Ctrl+Alt+V to open the paste special dialog box.
  • Select Transpose and hit OK.

 

 

  • abdullah.alduhaishi's avatar
    abdullah.alduhaishi
    Copper Contributor
    Jan 30, 2018

    Thanks Haytham for your feedback

    I wish it's that easy, Please check below snapshots for more information.

     

     

    In column D all cells are a formula ='Abdullah'!B27

    When I copy them to paste in another sheet [with the same steps you shared] it won't work as they are a formula, Please check below.

     

    Hope it's clear now :)

     

    Thanks,

  • abdullah.alduhaishi's avatar
    abdullah.alduhaishi
    Copper Contributor
    Jan 30, 2018

     

    Thanks Haytham for your feedback :)

     

    I wish it's that simple, please check below snapshot's for better understanding.

     

    In column D, all cells are a formula [='GSM GAP'!G63], If I implement your shared steps the result won't appear, Please check below snapshot.

     

    Hope it's clear now.

     

    Thanks again for your help :)

     

    • Haytham Amairah's avatar
      Haytham Amairah
      Silver Contributor
      Jan 30, 2018

      I didn't know that the cells you have in column D are cell references!

       

      In this case, you have two choices to choose one of them:

       

      #1 Get rid of the formulas and paste them as values by just choosing Values option in addition to Transpose as the below screenshot:

       

       

       

      #2 Before you apply the steps in the previous answer, do change the cell references in column D as follows:

      Replace this: 

      ='GSM GAP'!G63

      With this:

      ='GSM GAP'!$G63

      Apply this change to all cells in column D, and then copy and paste into another location by following the steps in the previous answer.

      • abdullah.alduhaishi's avatar
        abdullah.alduhaishi
        Copper Contributor
        Jan 30, 2018
        Dear Haytham,
        BIG thanks from the hart,

        The first solution didn't work, so I used the second.

        2# didn't work but it gave me another way to do my task, so thanks a lot for your kind support.

        Best Regards,,,,

Resources