HOME  |    TRAINING  |   FREE TUTORIALS   |   JOBS
Find out more about our new RSS feed.
FREE Tutorial
EXCEL 2000 - SELECTING CELLS WITH THE MOUSE

CATEGORY
SEARCH OUR OTHER TUTORIALS

DESCRIPTION

Selecting cells (highlighting) is one of the most important actions in Excel. You need to select cells before you do something with them, for example enter data, copy, delete or apply enhancements.


TUTORIAL TAKEN FROM COURSE : MICROSOFT EXCEL 2000 INTRODUCTION

FULL COURSE DETAILS

MS Excel 2000 is the popular spreadsheet from Microsoft, designed for the networked office environment. This course is designed to let users get to grips with the main features of Excel and realise the advantages of using a powerful electronic spreadsheet. The course is entirely 'hands on', so those reading will get practice in creating and modifying actual spreadsheets. This Excel 2000 course also instructs users in year 2000 best practice.

TO ACCESS THE FULL COURSE AND HUNDREDS OF OTHERS, CLICK HERE.


Selecting can be done with the mouse or the keyboard. When using the mouse the normal sheet pointer must be used.

To select a single cell

  • Click on the cell to be selected

The cell appears white with a black border around it. The fill handle (cross) is in the bottom-right corner of the border.


Active cell

To select a group of adjacent cells

  • Click on the first cell to be selected, and holding the mouse button down, drag to the last cell to be selected

OR

  • Click on the first cell to be selected, and holding the Shift key, click on the last cell to be selected


Group of adjacent cells selected

The active cell is the first cell selected. A black border appears around all of the selected cells. The fill handle (cross) is in the bottom-right corner of the border.

Tip: To move the active cell from its start position to each successive corner of the selected range press Ctrl + . (full stop).

To select a group of non-adjacent cells

  • Select the first cell(s)
  • Hold the Ctrl key and select the next cell(s)
  • Repeat for all cells to be selected


Group of non- adjacent cells selected

The active cell is the first cell of the last group selected. A faint border appears around each group of cells. There is no fill handle on any of the selected cells.

To select whole columns or whole rows

  • Click on the column or row heading to select

OR

  • Click-and-drag across several headings to select adjacent columns or rows

OR

  • Click on the first heading, then hold the Ctrl key and click on other headings to select non-adjacent columns or rows

To select the entire sheet

  • Click the Select All button above row 1 (SpeedKey: Ctrl + A)

Every cell on the sheet is selected. The active cell is A1.

To clear the highlighted selection

  • Click on any cell with the mouse

OR

  • Press an arrow key on the keyboard




8 RELATED COURSES AVAILABLE
MICROSOFT EXCEL 2002 (XP) INTRODUCTION
MS Excel 2002 (XP) is the latest version of the popular spreadsheet from Microsoft, designed for the networked of....
MICROSOFT EXCEL 2002 (XP) INTERMEDIATE
MS Excel 2002 (XP) is the latest version of the popular spreadsheet from Microsoft. This course aims to show the ....
MICROSOFT EXCEL 2002 (XP) ADVANCED
This course will give readers the ability to create advanced spreadsheets using the full range of Microsoft Excel....
MICROSOFT EXCEL 2002 (XP) PROFESSIONAL
This course will give readers the ability to analyze and manipulate data and to share workbooks in a team workgro....
MICROSOFT EXCEL 2000 INTRODUCTION
MS Excel 2000 is the popular spreadsheet from Microsoft, designed for the networked office environment. This cour....
 
1 RELATED JOBS AVAILABLE
DATA ANALYST
Microsoft Office, MS Access and Excel skills essential and any SQL or Crystal reporting skills desirable but not ....
CONTACT US
Tuesday 22nd May 2012  © COPYRIGHT 2012 - website design by Website Design by Visualsoft