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 » Excel

	98.1 % recommend us
	More live stats...

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

Training information:

Excel

Resolved · Low Priority · Version 2003

Reply Thu 26 Jun 2008, 16:10Delegate Graeme said...

Graeme has attended:
Excel Intermediate course
Excel Advanced course

Excel

If a cell password protected and i need to enter a long name than allow. What's the best to get around it

For upcoming training course dates see: Pricing & availability

Reply Wed 2 Jul 2008, 09:37 Edited on Wed 2 Jul 2008, 09:38Trainer Pete said...

RE: Excel

Hi Graeme,
Thank you for the post, welcome to the forum, in the situation you are describing you will have to remove the password protection on the cell before you can enter any information. However what I think you are looking for an answer to, is the Validation option when a limit has been set to the number of characters that are allowed to be entered into a cell, in this case you would need to open Data>Validation and from the drop down arrow Allow, choose Text length and enter your new required length, I hope that helps, regards Pete

Excel articles

· Coping With Compatibility In Excel 2007
· Creating A Clearer Picture With Excel
· Getting To Grips With Gantt In Excel
· Take the Anxiety out of Domestic Finances with Microsoft Excel
· Make Things Easier In Excel With Lists

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

Excel tip:

Copying Values Without Formulas in Excel 2010

If you want to copy the contents of a cell but don't want to copy the formula with it then use the following simple method:

Press Ctrl+C to copy the values in the cell. On the Home tab, click Paste and then click Paste Values.

View all Excel hints and tips