官术网_书友最值得收藏!

Selecting all worksheet cells with one click

With a click of the mouse button, we can select everything on a worksheet.

How to do it...

If you want to select an entire worksheet without having to drag your mouse to select everything, you can just click on the half triangle on the top left corner of the worksheet.

How it works...

Clicking on the half triangle button will allow you to select the entire worksheet with just one click. Here are some reasons why we would want to select an entire worksheet:

  • With an entire worksheet selected, you can easily apply formatting or change attributes to all cells.
  • You can copy the selection from one workbook and paste it onto a worksheet from another workbook. A common use would be copying data elements from an external spreadsheet and pasting it onto the internal Dashboard Design spreadsheet.
  • You can easily perform row height or column width formatting that will apply to all rows or columns in that spreadsheet.

There's more...

Another way of selecting everything on a worksheet is using the Ctrl+A shortcut.

主站蜘蛛池模板: 离岛区| 平远县| 榆树市| 登封市| 咸宁市| 鸡西市| 镇坪县| 长寿区| 砀山县| 涿鹿县| 蕲春县| 广河县| 湟源县| 通化县| 紫阳县| 图们市| 永善县| 鄂尔多斯市| 磐石市| 南昌市| 宝鸡市| 普兰店市| 无为县| 南平市| 垫江县| 丹江口市| 阳西县| 武隆县| 宁阳县| 涪陵区| 武陟县| 浠水县| 湖口县| 潼关县| 盈江县| 宁强县| 枝江市| 缙云县| 桐庐县| 宁河县| 临夏市|