-
Paste SpecialYou are probably quite familiar with cutting and copying or pasting using either the "Edit" menu or keyboard shortcuts. However, Excel features other pasting options, as well. To use the "Paste Special" feature, click on a cell and select "Copy" from the toolbar or ribbon or use the keyboard shortcut "Ctrl+C." Click on the cell into which you want to paste some aspect of the cell that you copied.
In Excel 2003 or earlier, select "Paste Special" from the "Edit" menu or click the drop-down arrow next to the "Paste Button" on the toolbar. In Excel 2007, click the "Paste" drop-down arrow from the "Home" tab of the ribbon and select "Paste Special."
From the "Paste Special" dialog box, make the selection that best suits your need. For example, you can paste the formula from the original cell and not the value. You can paste formatting such as borders and shading or even the cell's column width. Click "OK" to paste the special feature of the cell you copied into the selected cell. -
Unfreeze PanesIf you have a long or extensive Excel worksheet, it can become confusing when you are scrolling through rows or columns. You may forget what the heading for column "G" was, for example. Excel offers a feature that solves this common problem. You can freeze the panes that you want to remain in the window even as you scroll, such as a heading row.
To freeze panes, click on a cell that is at least one row below the row you wish to freeze and at least one column to the right of the column you wish to freeze. In Excel 2003 or earlier, go to the "Window" menu on the toolbar and select "Freeze Panes." In Excel 2007, go to the "View" tab of the ribbon and select "Freeze Panes." Excel will freeze the panes above and to the right of the selected cell so that when you scroll they will still be displayed.
If you want to unfreeze the panes again, select the cell or the entire worksheet by clicking the box between "A" and "1," going to the "Windows" menu or the "View" tab and clicking "Unfreeze Panes."
