excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

resolvedResolved · Urgent Priority · Version 2010

Harry has attended:
Project Intro Intermediate course

Excel

my question is can you attach files too excel as a hyperlink but the file ive attached stays with the program instead off being a shortcut .

RE: excel

Hi Harry,

Thank you for your question and welcome to the forum.

Do you mean sending an excel file from your machine by email to another person in another company by using hyperlink text?

If this is true, then you would need to attach the file in the traditional way.

I hope this helps.

Regards

Simon

RE: excel

no i mean if you have a spreadsheet and you wanted to attach for instance a word document to a piece of information on the spreadsheet so it would better an argument instead of just typing the info on excel i wanted to attach the original file to the task but dont worry i didnt bother in the end

Tue 4 Oct 2011: Automatically marked as resolved.


 

Excel tip:

Quickly copy a formula across sheets

Suppose you have a formula in cell Sheet1!B2, say =A1*5%, that you wish to copy to cell B2 on Sheet2, Sheet3 and Sheet4. Instead of using copy and paste, try this: (1) Select Sheet1!B2. (2) Group Sheet1 with the worksheets Sheet2, Sheet3 and Sheet4 by holding down Ctrl and clicking on the tabs of the sheets to group them. (3) Press the F2 key, then immediately press Enter to copy the formula in Sheet1!B2 across the grouped sheets.

Remember to ungroup the sheets afterwards! Right-click on any tab and choose Ungroup Sheets to do that.

View all Excel hints and tips


Server loaded in 0.1 secs.