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