Microsoft Excel... How do you keep rows always visible at the top?

Favorite Answer

Freeze panes....Show more

Select the row just below the top most row. Select freeze panes option from the menu list. If you are using Microsoft 2010/2007 then the option will be in "view" tab. If 2003 or lesser versions, please check the last tab. This will be there - Freeze panes.

Once you select freeze panes, the top most row will always be visible, no matter how far u scroll down!!!...Show more

Option 1: If you want to copy the entire rows (not only selected cells): I will consider that you want to copy rows from sheet to sheet for simplification: 1- Select all the rows that you want to copy including the hidden rows. 2- (Ctrl + C) 3- Go to the other sheet, and select a row. 4- Right click on the selected row, and then choose "Insert Copied Cells" 5- Go again to the original data, then copy the columns and apply "Paste Special" to the destination columns by choosing "Column widths" only. Note: Remember that when you hide the destination columns, their existing data will be hidden also. Option 2: If you want to copy only selected cells including hidden cells in columns and rows: 1- Select the cells that you want to copy including the hidden cells. 2- (Ctrl + C) 3- Go to the destination and paste them (Ctrl + V) 4- Go to the original data, select the rows that containing the original selection, then apply match format from the original rows to the new rows (using "Format Painter" button in the Standard toolbar) 5- Go again to the original data, then copy the columns and apply "Paste Special" to the destination columns by choosing "Column widths" only. Note: In this case the destination rows may contain existing cells with data, and when you copy format from the original rows, the existing cells will be affected by the new format. Also, when you hide the destination columns, their existing data will be hidden....Show more