LyteByte

You are browsing the archives of Columns.

Print first column or header column on all and each and every printed excel pages. Print titles and use columns to repeat at the left corner. Print the same header column on all excel pages. Or how to print the row and column heading on all pages.

Protect only certain cells in excel, also applicable for protecting certain columns or rows in Excel 2007, Excel 2003.

Search for all hidden rows and columns and then Delete all hidden rows and columns easily with a command in Excel 2007 using Document Inspector.

Calculate Non-zero average in Excel 2003 and Excel 2007 excluding all cells with zeros. Use formulas with AVERAGE, AVERAGEIF, SUM, COUNTIF to get non-zero average. Take average of numbers greater than zero.

Change text direction or orientation in excel cells. Format cell alignment and the text orientation to Angle Counterclockwise (45 degrees), Angle Clockwise (45 degrees), Vertical Text, Rotate Text Up, and Rotate Text Down in Excel 2007 and Excel 2003

Convert or copy rows to columns and columns to rows in Excel 2007 and Excel 2003 with formulas. copy vertical cell contents horizontally in Excel. How to Transpose data using paste special in Excel? How to paste only values in Excel?