microsoft excel courses - How to highlight columns + rows in one go?

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

Resolved · Low Priority · Version Standard

How to highlight columns + rows in one go?

Donna has attended:
Excel Introduction course
Excel Intermediate course

by - delegate Donna [2 posts] (2007 Jul 5 Thu, 14:10) Reply

Thanks
Donna

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 8 Mon + 9 Tue	Bayswater	2	book now	£495	£495
2003	2008 Sep 18 Thu + 19 Fri	Bloomsbury	1	book now	£495	£495
2003	2008 Sep 25 Thu + 26 Fri	Southwark	3	book now	£475	£495
2003	2008 Oct 6 Mon + 7 Tue	Bayswater	4	book now	£475	£485
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	3	book now	£475	£495
2003	2008 Oct 23 Thu + 24 Fri	Southwark	4	book now	£475	£485
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: How to highlight columns + rows in one go?

by - trainer Anthony gold contributer [113 posts] (2007 Jul 10 Tue, 10:45) Reply

Two ways to do this. To select all rows and all columns in a spreadsheet just click on the grey square at the top left of the spreadsheet, at the intersection of the column and row titles. Secondly, if you name the range of cells you want to highlight, by entering a name (e.g. "addresses") in the range bar, you can use the drop down arrow to the right of the range bar to select those cells in the future.

Anthony

· Identifying Suitable Candidates For VBA For Excel Training
· A Beginners Guide To Formulas In Excel
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· Take the Anxiety out of Domestic Finances with Microsoft Excel
· Tools From Advanced Excel Courses: Goal Seek and Solver

Excel tip:

Adding date and time

Here are two quick ways to add the date and time to your spreadsheet:

1) Type =NOW(), which displays both date and time in the same cell
or
2) Hold Ctrl and type the colon (:) into one cell for the date and the semi-colon(;)into another for the time.

Note that =NOW() updates to the current date/time whenever the spreadsheet recalculates.

View all Excel hints and tips