Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Data validation

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Data validation

Resolved · Low Priority · Version 2010

Reply Fri 3 Jun 2011, 16:40Delegate Natalie said...

Natalie has attended:
Excel Advanced course

Data validation

Can you assign a macro to refresh the data?

For upcoming training course dates see: Pricing & availability

Reply Mon 6 Jun 2011, 11:37Trainer Mark said...

RE: data validation

Hello Natalie,

Thank you for your question regarding macros and refresh.

The key for refresh is F9, so you could record a macro and press the F9 key. Playing back the macro will refresh.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer

Mon 13 Jun 2011: Automatically marked as resolved.

Excel articles

· How to Create Better Excel Spreadsheets: Part Two
· Tips for Transitioning to Excel 2007
· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers
· VBA Excel 2007
· Using The Excel Forms Toolbar To Spruce Up A Workbook

Please browse our web site to find out more about
excel+vba+training and other Microsoft training courses.

Excel tip:

Use shortcut keys to select rows or columns

Most users use the mouse to select rows or columns. It may be more convenient to use keyboard shortcuts to do that.

The shortcut key combination to select an entire row is Shift+Spacebar.

The shortcut key combination to select an entire column is Ctrl+Spacebar.

These are pretty easy to remember as the spacebar looks like a long row (or column if you're looking at it sideways). Remember that Ctrl, beginning with C, selects columns and Shift, by a process of elimination, the rows.

View all Excel hints and tips