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

excel

ResolvedVersion 2007

Paul has attended:
Excel Intermediate course
Excel Advanced course

Excel

How do you save a Macro and use it on multiple Files any time you want?

RE: Excel

Hi Paul

How are you today, sorry i haven't got back to you earlier

You can save your macros for use in other files, when you do your new macros and the screen you are naming your macro, you choose to store you macro in the personal macro workbook

Help this helps you out

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn

Excel tip:

Importing Numbers in Excel 2010

Occasionally, when importing data into Excel you find that the some of the imported values are treated as text.

To convert these numbers to actual values, click on an empty cell and press Ctrl+C.

Next, select the range that contains the values you need to change and in the Clipboard Group on the Home tab, click the Paste drop-down arrow and choose Paste Special. In the Paste Special dialog box, select Add and then click OK.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.