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

excel consulting - how create lists excel

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel consulting - How to create lists in excel from data

excel consulting - How to create lists in excel from data

ResolvedVersion Standard

Manase has attended:
Excel Advanced course

How to create lists in excel from data

Do you have to use macros

RE: How to create lists in excel from data

Manase,

Macros can be used for many things.
First find a process that you do repetitively.
Make sure you can do each step clearly. You can only automate or record something that you can already do.
Once you have the steps, then go to TOOLS > MACROS > RECORD NEW MACRO on the menu bar.
Complete the information in the window (name of macro, shortcut, description). Once you click OK, the macro starts recording. It records EVERYTHING you do, do be very specific about what you do. There is no time limit when recording a macro, so take your time.

Once you have completed the recording, click STOP and then you can replay your macro through the TOOLS > MACROS > MACROS menu.

Excel tip:

Selecting your working range

In excel if you have an area you want to highlight, press Ctrl + * or Ctrl+Shift+8 (to get the *). This will select your working range.

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