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

  • .NET 4.0 Generics
  • David Lai Xavier Hacking
  • 182字
  • 2021-04-02 19:30:08

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.

主站蜘蛛池模板: 民县| 亚东县| 城步| 鲁山县| 灵台县| 兴业县| 奉贤区| 丰县| 彰化市| 南靖县| 板桥市| 水城县| 自贡市| 淄博市| 桂阳县| 三原县| 东乡| 青浦区| 太仓市| 太和县| 美姑县| 乐都县| 丰镇市| 江西省| 黄冈市| 安仁县| 临颍县| 洪江市| 安徽省| 调兵山市| 永年县| 且末县| 花莲市| 江都市| 深州市| 伊宁县| 大新县| 松滋市| 南京市| 宁强县| 信丰县|