Great question. Easy answer: Highlight the data in your column. C to copy it.
Then go to a blank section of your spreadsheet. pick Edit > Paste Special.
In the paste special dialog box, check the little box that says "Transpose". Then click OK. Your column data now turns into row data.
How can I enter the symbol for the new Euro currency in my spreadsheet?
I want to add 25 to all of the cells in column A. I do not want a new column, I want to add it right to the cells in column A?
I use a large spreadsheet on a daily basis with 31 worksheets (one for each day of the month). Each worksheet is huge.I would like to insert another sheet in the workbook and insert a button to copy another worksheet to the end of the workbook and then rename the sheet to the correspondingday of the month?
Somehow, my worksheet has external links to files that are no longer around. How can I delete the links?
Where can I find some really good information on how excel treats year 2000 dates? I need simple (and that is what u guys provide)?
Ihave been working with downloaded data and pasting a years worth at a time into a "template" that I want all the resulting spreadsheets to look like. Each years data has approximately the same amount of data in it. Seems each spreadsheet is taking more and more space as I work on them? Any ideas what I have done?
I created a worksheet in Excel 95. In Excel 97, Excel ignores my page breaks?
Well, then how do I fit something to one page wide?
How do I make a copy or a back up of a workbook that will not fit on a single 3.5 disk, so that I may transfer from home to office?
I have a spreadsheet where I want to sum cells from column E if the corresponding date in column A is within the last 60 days?
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
