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

excel

ResolvedVersion 2003

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

Edited on Wed 2 Jul 2008, 09:38

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 tip:

Wrapping Text in a Cell in an Excel 2010 Workbook

When you have a lot of text you want to put in a particular cell but you can't decrease the font size to fit because the text will then become ineligible, then manually wrap the text in a cell by simply pressing ALT+ENTER.

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.1 secs.