Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » training courses in excel - Emailing a sheet

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

training courses in excel - Emailing a sheet

Resolved · Low Priority · Version Standard

Reply Thu 31 Jan 2008, 12:54Delegate Vicki said...

Vicki has attended:
Excel Intermediate course

Emailing a sheet

How can I just send one sheet / tab from an excel document where there are 20 sheets / tabs?

For upcoming training course dates see: Pricing & availability

Reply Sun 10 Feb 2008, 10:50Trainer Stephen said...

RE: Emailing a sheet

Hi Vicki

Thankyou for your question

I am assuming you want to email an individual worksheet

If you have outlook correctly configured then if you click on File-send to-email recipient, then outlook should give you the choice of sending the current sheet or the whole workbook.

If you are not using outlook then your best tactic would be to copy the one sheet into a new blank book and send that book as an attachement

Hope this is useful

Regards

Stephen

Excel articles

· Automatically Insert The Time, Date Or Both In Excel
· Radio Buttons And Check Boxes In Excel
· How To Create Formulas In Excel
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· Microsoft Excel can ensure you keep on top of your finances

Excel tip:

Converting an American date format to European using Formula

Excel depending on your local setting will only pick up date values of the dd mmm yyyy oders as date type. If you import data from various sources including America their date order is different with data value in mmm dd yyyy, excel can only treat it as text indicated by left aligning it. To overcome this you have to do the the following.

1. Extract the date components mmm dd yyyy, by using the the Text functions LEFT, MID or RIGHT

2. Reorder dd mmm component and concatenate using "&" in the right order this will create a text string with the date in the right order it then needss to be converted to a value so excel can recognise it.

3. To convert to value encase in TEXT function.

4. Format to desired date format.

View all Excel hints and tips