BUY TELUGU TUTORIAL DVD'S:::: SEO::3500/-,DCA(DOS,WINDOWS,WORD,EXCEL,POWER POINT, MS ACCESS, INTERNET CONCEPTS)::499/-,DTP(PHOTOSHOP,PAGEMAKER, CORELDRAW,TELUGU TYPING)::999/-,C::700,C++::900,TALLY ERP 9:: 999,ORACLE:999/-,CORE JAVA::1000/-,SPOKEN HINDI:500,HTML::500/-,AUTOCAD::2500/-,DCA+DTP::1000/-,DCA+TALLY::1000,C,C++,JAVA::1500, ALL COURSES(DCA,DTP,C,C++,JAVA,ORACLE,TALLY,HTML,SPOKEN HINDI,AUTOCAD):: 3500/-..CONTACT : SYED HAFIZ, SHOPPING COMPLEX,8INCLINE COLONY,GODAVARI KHANI,KARIMNAGAR, TELANGANA,CELL:9395306603,EMAIL:COOLHAFI7@GMAIL.COM.
Home / Ms Office / Ms Excel 2007 / Microsoft excel in telugu convert columns to rows

Microsoft excel in telugu convert columns to rows

microsoft excel in telugu

Everyone looks at information in a slightly different way. Some people create Excel spreadsheets where the data is useful, but it doesn’t work with the way you view or interact with the data. One common example is where you want to transpose or switch Excel row or column data so Row A data becomes Column A data and so on.

I recently was given a large Microsoft Excel spreadsheet that contained vendor evaluation information. The information was useful, but because of the way the data was structured, I couldn’t use tools like Auto Filter. I would also have issues if I needed to import the information to a database. A simple example of such a spreadsheet is shown below.

nstead, I want to have the Company names display vertically in Column A and the attributes display horizontally in Row 1. This would make it easier for me to do comparisons. For example, I can’t easily filter the spreadsheet for vendors in CA. I also didn’t want to re-enter the data. The fix is rather easy using Excel’s transpose feature.

To switch Excel columns and rows,

  1. Open the spreadsheet you need to change.
  2. If needed, insert a blank worksheet.
  3. Click the first cell of your data range such as A1.
  4. Shift-click the last cell of the range. Your selection should highlight.
  5. From the Home tab menu, select Copy.
  6. At the bottom of the page, click the tab for the blank worksheet such as Sheet2.
  7. In the blank worksheet, click cell A1.
  8. From the Home tab menu, select Paste. The Paste dialog should appear.
  9. Click the box for Transpose.
  10. Once you transpose the data, your company names will show in Column A. I can now sort or filter the data in many ways.

Note: For older versions of Excel, the Copy & Paste commands are on the Edit menu.

 

About Hafiz

Check Also

Excel training in telugu Clean Formula

excel training in telugu When data files are imported or copied into Excel worksheet non-printable …

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload CAPTCHA.

STATE BANK OF HYDERABAD, ***NAME:Hafiz SD, BRANCH:JALLARAM, ACCOUNT.NO:62041435239, IFSC CODE:SBHY0020609,****, ANDRA BANK*** NAME:SYED HAFEEZ BABA, BRANCH:8INCLINE COLONY, ACCOUNT.NO:116710100037533****SBI****NAME:SYED HAFEEZ BABA,ACCOUNT NO:35321924009,IFSC CODE:SBIN0013338,BRANCH:GODAVARIKHANI.,...