excel training courses - Disabling the paste option in Excel

The UK's most regular instructor-led training courses.
Training information: excel training courses · Excel training course · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Disabling the paste option in Excel

Hina has attended:
Project Intro Intermediate course
Excel Advanced course

by - delegate Hina [3 posts] (2007 Jul 27 Fri, 14:22) Reply

Is there any way to disable the paste option in Excel?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue + 26 Wed	Bayswater	6	book now	£455	£515
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 1 Mon + 2 Tue	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	5	book now	£450	£485
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	5	book now	£475	£515
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	6	book now	£450	£475
Full Schedule: See all 37 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Disabling the paste option in Excel

by - trainer Tracy platinum contributer [586 posts] (2007 Jul 28 Sat, 11:59) Reply

Hi Hina,

Thanks for the question. I have done some research and the same answer comes out! Data Validation can be overridden with the paste option and there is no way round it! If I hear of anything I will be in touch!

Tracy

· Microsoft Excel Training: Essential for Today's Employees
· Why Excel Training (Sometimes) Doesn't Work and What You Can Do About It
· Microsoft Excel Training - Numerical excellence for all
· Prepare for your MOS Certification with MS Excel Courses
· How to Create Better Excel Spreadsheets: Part Three

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