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

excel.training.course.london - series actions

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel.training.course.london - Series of actions

excel.training.course.london - Series of actions

ResolvedVersion Standard

Christof has attended:
Excel Advanced course

Series of actions

Can I program and save a series of actions?
Example: I get the same Excel list of data every day and need to manipulate it in the same way every day. Can I save a string of actions to automate the process? like change date format in column A D and F and sort ascending in column B then save in Folder XYZ as filename "current date" ...

Thanks in advance.

RE: Series of actions

you can carry out most of that by creating a simple macro and attaching it to a button.

The 'save as...' bit requires a bit of VB code...

Excel tip:

Quickly hide and unhide rows and columns

Use the keyboard shortcut Ctrl+9 to hide selected rows and Ctrl+0 to hide selected columns. The good thing about this shortcut is that you do not need to select entire rows or columns. For example, select B3:D3 then press Ctrl+0 to hide columns B to D.

Ctrl+Shift+9 unhides rows and Ctrl+Shift+0 unhides columns.

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.