excel training courses - selecting range cells worksheet
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training courses - Selecting a range of cells on a worksheet

excel training courses - Selecting a range of cells on a worksheet

resolvedResolved · Low Priority · Version Standard

replyReply Thu 26 Jul 2007, 12:44Delegate Beenish said...

Beenish has attended:
Excel Introduction course

Selecting a range of cells on a worksheet

how can you select a range of cells using the shift key without dragging!

For upcoming training course dates see: Pricing & availability

replyReply Thu 26 Jul 2007, 15:51Trainer Amanda said...

RE: selecting a range of cells on a worksheet

Hi Beenish

Thank you for your question.

You can do this by clicking on the first cell you wish to select, then holding down the Shift key, and clicking on the last cell you wish to select.

This should select all cells between the first and last cells in your selection.

Amanda

 

Excel tip:

Jumping Between Sheets in a Book

PgDn and PgUp keys scrolls up and down a screen page in most applications.

Ctrl+PgDn and Ctrl+PgUp keys jump from one sheet in your workbook to the next, up or down through the pages.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard