Quick way to select all cells
Excel
2010
This tip will help you to select all cells in the worksheet in one click.
A quick way to do so is to click the triangle at the intersection of the row headers and column headers:
If you have any questions or suggestions, please feel free to ask OfficeToolTips team.
See Also
Unmerging all merged cells
Here's a quick way to unmerge all merged cells in a worksheet:
Workaround for sorting and filtering of merged cells
In some situation you can't work with workbook that consists of merged cells. To use Filter, Sort or other functions, you need to unmerge cells and put to all of them the data from merged cells. This tip shows how to do it efficiently.
Using advanced filtering
In addition to manual data filtering Excel enables fully automated filtering based on data from the specified range of cells. Before you can use the advanced filtering feature, you must set up a criteria range. A criteria range is a designated range on a worksheet that conforms to certain requirements.