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 to do it...

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 ...

Get SAP BusinessObjects Dashboards 4.0 Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.