excel consulting - how create lists 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 consulting - How to create lists in excel from data

excel consulting - How to create lists in excel from data

resolvedResolved · Low Priority · Version 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:

Jumping Between Sheets in a Book

PgDn and PgUp keys scrolls up and down a screen page in most applications.

Ctrl+PgDn and Ctrl+PgUp keys jump from one sheet in your workbook to the next, up or down through the pages.

View all Excel hints and tips


Server loaded in 0.1 secs.