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

• Excel 2007 VLOOKUP Function
• Excel VLOOKUP
• Excel HLOOKUP

There are a number of functions in Excel that will count cells for you rather than add or multiply the data in those cells. One of these COUNT functions that I use regularly is the COUNTA function. I use it to keep track of the number of students I have in each of my classes.

COUNTA tells you the number of non-blank cells that are present in a specified range. The cells can contain numbers, dates, or just plain text labels.

To find out the specifics of about this function read the article on Excel 2007 COUNTA Function.

Related Articles

• Excel 2003 COUNTA Function
• Excel 2007 COUNTIF
• Excel 2007 COUNTBLANK