microsoft excel courses tate

microsoft excel courses tate - Copied formulae

Resolved · Low Priority · Version Standard

Copied formulae

Nurubee has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course

by - delegate Nurubee [1 post] (2007 Oct 12 Fri, 10:26) Reply

how do i remove the green shading in a cell that I have a dragged down formulae in

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 3 Wed	Bloomsbury	0	FULL
2003	2008 Dec 5 Fri	Bayswater	1	book now	£195	£205
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
2007	2008 Dec 10 Wed	Bloomsbury	2	book now	£240	£245
2003	2008 Dec 12 Fri	Southwark	5	book now	£219	£235
Full Schedule: See all 96 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: copied formulae

by - trainer Sandy silver contributer [93 posts] (2007 Oct 16 Tue, 13:10) Reply

Hi Nurubee

It was great teaching you last week in Excel Intro and Intermediate.

If you wish to remove the green shading Nurubee, just highlight the cells and select the fill colour icon on your formatting toolbar and choose No Fill.

Hope all is going well with Excel.
Kind regards
Sandy

· Advanced level training: Microsoft Excel and the Web
· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· Why Should I Learn Visual Basic in Excel?
· Benefits of learning about Excel charts
· Microsoft Excel Training - Numerical excellence for all

Excel tip:

Edit and format multiple worksheets in one operation

To select two or more non-adjacent worksheets, click on the tab of each worksheet, while holding down the [CTRL] key.
To select two or more adjacent worksheets, click on the tab of the first worksheet and then on the tab of the last worksheet, while holding down the [SHIFT] key.
Enter or modify your data and apply the necessary formatting options to the sheet that's displayed

View all Excel hints and tips

Rate this page: