Results 1 to 5 of 5

Copy formatted horizontal cells to empty vertical cells

Threaded View

  1. #1
    Registered User
    Join Date
    06-06-2013
    Location
    Manila
    MS-Off Ver
    Excel Mac 2011
    Posts
    8

    Talking Copy formatted horizontal cells to empty vertical cells

    If I have formatted data inputted from the most top-left cell to the right (A1, A2, A3, A4, A5), how do I copy it to SHEET 2 but in a different direction, this time from top to bottom (A1, B1, C1, D1, E1). What I need is the formula itself.

    When I try to copy-paste, it always ends up pasting on the copied direction.

    Thanks for the help!
    Last edited by mishxco; 06-07-2013 at 02:46 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1