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

excel

ResolvedVersion Standard

Lukasz has attended:
Excel Advanced course

Excel

How do you customise an icon for macros.

RE: Excel

Dear Lukasz:

Thank you for attending Excel Advanced Course. I hope you enjoyed the training.

Once you have recorded the macro you can simply use the shortcut key that you may have assigned to it in the Record New Macro dialog box. Or you can assign the Macro to a button which can be placed on one of the toolbars.

Please follow these steps:

Step 1: Once you have created the macro Choose [b] Tools > Customize

Excel tip:

Copying Formulae Quickly

There is a quicker way of copying a formula down a column.

Just point and double click on the black autofill handle in the right hand corner of a cell.

This will work providing you have some data in the column to the left of the column.

Sandy

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.11 secs.