advanced excel seminar training

advanced excel seminar training - Excel

Resolved · Low Priority · Version Standard

Excel

Gary has attended:
Excel Introduction course
Excel Intermediate course

by - delegate Gary [2 posts] (2007 Mar 29 Thu, 16:38) Reply

How do I remove the auto fill smart tag from a worksheet

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: Excel

by - trainer Tracy platinum contributer [586 posts] (2007 Mar 30 Fri, 09:33) Reply

Hi Gary, thank you for the question.
To remove the smar tags from a worksheet you need to use the Tools menu, click AutoCorrect Options, and then click the Smart Tags tab. You can clear the check boxes for the smart tags you want to remove.

Hope that helps

Tracy

· Customized Financial Excel Courses in London
· Interesting Lifestyle Applications for Microsoft Excel
· Advanced Excel Training - takes you to the next level
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· Microsoft Excel Training: Essential for Today's Employees

Excel tip:

Change the default location for opening and saving spreadsheets

If you are always opening spreadsheets from and/or saving documents to a specific location that is not My Documents, save time by setting this folder as the default for opening files from and saving files to.

Here's how:
1. Go to Tools - Options.

2. Select the General tab.

3. Enter the pathname of the folder you wish to make the default in the Default File Location box (hint: it will be easier to use Windows Explorer to navigate to this folder, then copy and paste the pathname from the address bar at the top of the Windows Explorer screen).

4. Click OK.

You have now changed the default folder for opening and saving spreadsheets.

View all Excel hints and tips

Rate this page: