Look Who it Was Random video

How to Convert Microsoft Excel sheet vertical cells to horizontal

304 views · Published 10 June 2015 · 1:07 · Indexed 12 November 2026

Channel: Tech Help Bangla · 2015 · Science & Technology

Watch on YouTube

This tutorial will show you how to link to workbooks together using Microsoft Excel

If you have entered data into an Excel sheet only to realize it would be better as a row rather than a column, or vice versa, then knowing how to flip the data is a valuable skill.
 
Step # 1 -- Copying the Data

First off, load the sheet that has the data you want to flip. Here we have a small table about the price of some items. We want flip this so the price data is in a row, not a column. First highlight the table, right click on it and choose "Copy".
 
Step # 2 -- Using the Paste Special Window

Now that the data is in the clip board, click where you want the new table to appear. Here we are placing it just right of the original table. Right click and navigate to "Paste Special...", in the menu that appears click on "Paste Special...". This will open a new window, check the "Transpose" check box at the bottom and click "OK".
 
Step # 3 -- Viewing the Transposed Data
The data will be inserted into the spreadsheet in the new location and as you can see all of the data has been flipped so that the prices are now in rows, rather than columns. This process will also work the other way round.

#word_vertial #Word_horizontal

For more interesting updates Please subscribe My Channel
https://goo.gl/LxvJqw

🌐 Facebook : https://goo.gl/YcHTeu

🌐 Twitter : https://goo.gl/q8mxDd

🌐 Google+ : https://goo.gl/uzfDg4

🌐 Instagram : https://goo.gl/RB02Qx

🔊 LIKE ➡ SHARE ➡ SUBSCRIBE

Watch More...
YouTube Tips And Tricks Playlist :   https://goo.gl/hPCs7W 

How to Make Money Online Playlist : https://goo.gl/myvPRH

Windows 10 Tips And Tricks Playlist : https://goo.gl/9ZbhXe

Common Tutorials Playlist :  https://goo.gl/L4W68f

Mobile Tips And Tricks Playlist :  https://goo.gl/cUnFML 

Photoshop Tutorial Playlist :  https://goo.gl/wtP45V

Facebook Tips And Tricks Playlist :  https://goo.gl/HALw6W

My Channel is The best & ultimate technology platform for Bangladeshi tech peoples in Bangla language. You can get lots of technology news, android tips, review, photo editing, unboxing, computer tricks & tips, mobile tricks and more.

#Tech_Help_Bangla

note: all the image picture shown in the video belongs to the respected owner and not me. i am not the owner of any pictures showed in the video.

DISCLAIMER: This Channel Does Not Promoted Any Illegal Content, All Content Provided By This Channel Is Meant For EDUCATIONAL purposes Only.

More from this channel