First of all, select cells in the B4:I9 range that you want to transpose.However, let’s see how this method works. This method is quick and easy, but it’s not suited for repeated processes. We can use the simple Paste Special command in two ways, as described below. Please leave a comment if any part of this article does not work in your version. Here, we have used the Microsoft Excel 365 version, you may use any other version according to your convenience. In the following sections, we will show 6 instrumental Excel methods to perform this task. Now, we want to transpose the rows of this data set to columns for the sake of better presentation. This dataset includes the Names and consecutive year-wise results under column B to column I. To change the 'viewing window', simply re-define or update the named range from within Excel, save, then select and F9 the object/image in Word and you should be good to go.6 Methods to Transpose Rows to Columns in ExcelĪssuming that we have a data set that presents the year-wise Results of Students. Select embedded XLS object/image and press F9 to update (or right click etc). Word: With the field code under cursor, hit Shift-F9 again to hide. Word: Select the newly inserted XLS object/image. Word: Insert | Object, 'From File', (choose XLS file), check 'Link to File' (to ensure it's kept 'fresh'), OK ![]() " WordView"), Confirm named range exists (this step can happen before/after) ![]() The question was specifically around a 'live link' (meaning the Excel file exists externally to the Word doc, and controlling the view is a complex problem not solved by any of these answers).Īnswer: Using the Word Field Code parameters of LINK you can specify a named range as a Viewing Area.Įxcel: Select the cells (contiguous range) to be seen in Word, 'Insert Named Range' or Alt-I,N,D, Type name for region (no spaces for simplicity, e.g.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |