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 formula it won't work.


 Thanks in advance :)

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.

Resources