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

The UK's most regular instructor-led training courses.
Training information: excel training courses · Excel-courses-london · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Selecting a range of cells on a worksheet

Beenish has attended:
Excel Introduction course

by - delegate Beenish [1 post] (2007 Jul 26 Thu, 12:44) Reply

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

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue	Bloomsbury	0	FULL
2003	2008 Nov 27 Thu	Southwark	3	book now	£210	£215
2007	2008 Nov 28 Fri	Bloomsbury	0	FULL
2003	2008 Dec 2 Tue	Bloomsbury	4	book now	£207	£215
2003	2008 Dec 4 Thu	Bayswater	6	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	5	book now	£212	£224
Full Schedule: See all 113 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: selecting a range of cells on a worksheet

by - trainer Amanda diamond contributer [1199 posts] (2007 Jul 26 Thu, 15:51) Reply

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

· How to Create Better Excel Spreadsheets: Part Three
· Microsoft Excel Training: Not Just for Newbies Anymore
· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· Features of Microsoft Excel that assist in Analysis of Financial Data
· Why Excel Training (Sometimes) Doesn't Work and What You Can Do About It

Excel tip:

Calculate difference between two times

For presenting the result in the standard time format (hours : minutes : seconds . Use the subtraction operator (-) to find the difference between times, and the TEXT function to format the returned value to text in a specific number format.

Hours never exceed 24, minutes never exceed 60, and seconds never exceed 60.

=TEXT(B2-A2,"h")
Hours between two times (4)

=TEXT(B2-A2,"h:mm")
Hours and minutes between two times (4:55)

=TEXT(B2-A2,"h:mm:ss")
Hours and seconds between two times (4:55:00)

Where B2 and A2 must hold the end time and start time respectively formatted as a time format

View all Excel hints and tips