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

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.

主站蜘蛛池模板: 麻阳| 三原县| 江陵县| 双桥区| 西盟| 洛川县| 西乡县| 西安市| 西安市| 麻栗坡县| 巴塘县| 望城县| 永泰县| 股票| 英德市| 玉环县| 盱眙县| 华坪县| 保山市| 铁岭县| 赫章县| 肥西县| 斗六市| 开平市| 崇文区| 临沭县| 葵青区| 岳阳县| 喀喇| 海门市| 荥经县| 新源县| 陵水| 青州市| 白玉县| 马龙县| 昭觉县| 华宁县| 丁青县| 嵩明县| 普定县|