Question:

how do I get the % change using the horizontal formula

by Guest3186  |  12 years, 9 month(s) ago

0 LIKES UnLike

how do I get the % change using the horizontal formula

 Tags: Change, formula, HORIZONTAL, Using

   Report

1 ANSWERS

  1. amomipais82
    Hi There,
    To change your data from vertical to horizontal and visa versa... you will have to use the "paste special" option.

    -Copy your data using Ctrl+C
    -Choose the cell where you want to paste your data
    -Go to the Edit Menu and choose "Paste Special"
    -In the paste special dialog box choose "All" and click the "Transpose" option...and then click ok.

    Your data has been transposed from vertical to horizontal.
    Hope it helps...

Sign In or Sign Up now to answser this question!

Question Stats

Latest activity: 14 years, 7 month(s) ago.
This question has 1 answers.

BECOME A GUIDE

Share your knowledge and help people by answering questions.
Unanswered Questions