
operations. Click refers to use of the primary mouse button. The term right-click refers to
use of the secondary mouse button.
● Select chooses the object that is under the cursor when you press and release the primary
mouse button.
Select a worksheet cell, for example, by moving the cursor to the cell and pressing and
releasing the primary mouse button.
● Click (that is, both click and right-click) describes a quick press-and-release action on a
command object.
Click a button, for example, to execute a command.
● Double-click describes two quick press-and-release actions that are executed in rapid
succession.
Double-click an application icon, for example, to start a Windows application.
● Drag describes a press, hold, and move action.
Place the cursor on an object, press a mouse button, hold the mouse button down as you
move the object, and release the mouse button when you reach your goal. For example, you
can highlight a range of cells in a worksheet by dragging the cursor over the cells.
Note:
Essbase uses a drag operation called a pivot. A pivot requires use of the secondary mouse
button. To execute a pivot, you must press and hold the secondary, rather than the primary,
mouse button while dragging the selection.
Essbase offers enhanced mouse actions in Excel. You can use the mouse to perform any of the
following tasks:
● Retrieve data
● Drill down and drill up on database members
● Pivot (move or transpose) data rows and columns
● Access linked reporting objects
● Access linked partitions
➤ To enable double-clicking to retrieve, drill down, and drill up on Essbase data:
1 Select Essbase > Options.
2 In Essbase Options, select the Global tab.
3 Select Enable Double-Clicking.
When Enable Double-Clicking is selected, as shown in Figure 6, you can retrieve and drill down
to more detailed data (primary mouse button) and drill up to less detailed data (secondary mouse
button). When double-clicking is enabled, the in-cell editing feature is overridden.
Getting Acquainted with Spreadsheet Add-in
27
Kommentare zu diesen Handbüchern