Excel General

Using keyboard shortcuts

Submitted by Support on Mon, 06/16/2008 - 15:42
Image: 
image/gif icon12.gif

The Current Region/List is a range of cells containing data bounded by blank rows and columns.
To select the Current Region/List:

Selecting a Range of Non-Adjacent Cells

Submitted by Support on Mon, 06/16/2008 - 15:45
Image: 
image/gif icon11.gif

To select a range of non-adjacent cells:

1. Select cell A1, and press Ctrl+Shift+Down Arrow.
2. Continue holding down Ctrl, and select another range.

Move, delete or copy a toolbar button quickly

Submitted by Support on Sun, 06/29/2008 - 14:50

To customise our toolbars, we generally need to enter Customize mode. However, we can move or copy toolbar buttons without enabling Customize mode.

Create a drop-down list from a range of cells

Submitted by Support on Sun, 06/29/2008 - 16:23
Image: 
image/bmp iconuntitled.bmp

To make data entry easier, or to limit entries to certain items that you define, you can create a drop-down list of valid entries that is compiled from cells elsewhere on the worksheet.