Select the Whole Worksheet in Excel

Select the entire worksheet by clicking on the gray square above the row numbers (and to the left of the column letters).

Why would you want to do this?

The most common use is if you want to apply common formatting to every cell.

For example, you may want the sheet to display currency with no decimals, and make all entries blue,
and change a font.

You also may wish to copy the whole sheet to another sheet or workbook without missing anything.

To find out more about Excel Training Perth