Quick way to select all cells
Excel
2013
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.
Useful Excel features to work with a lot of data
If you have a lot of data, manual editing and formatting of cells isn’t an option any more. However, Excel provides you many group operations that make those manipulations quick and easy.