On occasion there is a need to transfer a row of data into a column. This might be done when re-vamping a spreadsheet or when creating a summary table of information.
Whatever the reason, Excel has a function, the TRANSPOSE function, that simplifies the task. This function will copy a row of data and place it in a column or copy data from a column into a row.
To find out the details of using this function read the article on the Excel 2007 TRANSPOSE Function.
Related Articles
Must Reads
Browse Topic
Excel's Format Painter
Copy formatting quickly
The Format Painter makes it easy to copy formatting options from one section of a spreadsheet to another.
Other Time Savers
Print Gridlines and Headings in Excel
This tip covers how to print gridlines and row and column headings in Excel 2007.
Some Excel Keyboard Shortcuts
Ted's Spreadsheets Blog
Excel 2007 TRANSPOSE Function
Monday November 9, 2009
Excel 2007 HLOOKUP Function
Friday November 6, 2009
After discussing Excel's VLOOKUP function, I thought I should follow that up with the HLOOKUP function.
Both LOOKUP functions can be used to help you find specific data located in a database or list of data. The difference between the two functions lies in how your data is organized in your spreadsheets.
If the data is organized in columns, you would use VLOOKUP, if the data is kept in rows, you would use HLOOKUP.
For details on how to use the HLOOKUP function in your spreadsheets, including an example, read the article on the Excel 2007 HLOOKUP Function.
Related Articles
Both LOOKUP functions can be used to help you find specific data located in a database or list of data. The difference between the two functions lies in how your data is organized in your spreadsheets.
If the data is organized in columns, you would use VLOOKUP, if the data is kept in rows, you would use HLOOKUP.
For details on how to use the HLOOKUP function in your spreadsheets, including an example, read the article on the Excel 2007 HLOOKUP Function.
Related Articles
Excel 2007 VLOOKUP Step by Step Tutorial
Wednesday November 4, 2009
If you store large amount in spreadsheets, Excel's VLOOKUP is a handy function to know. It allows you to easily locate specific data in a database or list.
For example, VLOOKUP can be used to find the price of an item located in a large inventory list. VLOOKUP will not only lookup the price but you can also get it to insert that price into an order form, so filling out online order forms becomes quite straightforward.
For details on how to setup and use the VLOOKUP function in your spreadsheets, read the article Excel 2007 VLOOKUP Step by Step Tutorial.
Related Articles
For example, VLOOKUP can be used to find the price of an item located in a large inventory list. VLOOKUP will not only lookup the price but you can also get it to insert that price into an order form, so filling out online order forms becomes quite straightforward.
For details on how to setup and use the VLOOKUP function in your spreadsheets, read the article Excel 2007 VLOOKUP Step by Step Tutorial.
Related Articles
Excel 2007 EDATE Function
Monday November 2, 2009
One Excel function that can be used to calculate the number of days between two dates is the EDATE function.
It is mainly used to calculate the maturity date for an investment that falls on the same day of the month as the issue date or due date for a project.
The function can also be used to find the start date rather than the due date by using negative numbers when writing the function.
To find out the details of using this function, read the article on Excel 2007 EDATE Function.
Related Articles
It is mainly used to calculate the maturity date for an investment that falls on the same day of the month as the issue date or due date for a project.
The function can also be used to find the start date rather than the due date by using negative numbers when writing the function.
To find out the details of using this function, read the article on Excel 2007 EDATE Function.
Related Articles
Discuss
Explore Spreadsheets
Must Reads
About.com Special Features
Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >
Easy ways to connect two computers for networking purposes. More >
©2009 About.com, a part of The New York Times Company.
All rights reserved.