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 Solver
Solver tool allows you to specify multiple adjustable cells and constraints on the values that the adjustable cells can have, generate a solution that maximizes or minimizes a particular worksheet cell, generate multiple solutions to a problem.