I too have had this happen with formatted templates. Without resizing the cell, I've never found a solution other than to do exactly what you've done, edit in Word (or Word Pad). I too would like to know if anyone has found a good work-around.
I guess you could ask for the password that's protecting the formatting, but I've tried that and never found the authors willing to do it. Most would consider this a reasonable accommodation. Or, you could crack the password to the spreadsheet formatting, but they would probably like that even less. I have few qualms about cracking passwords when accessibility is involved. Still, getting the spreadsheet back to the author's formatting would be challenging for most of us. Richard Petty ILRU - Independent Living Research Utilization [email protected] (E-Mail) ________________________________ From: [email protected] [mailto:[email protected]] Sent: Monday, May 02, 2011 5:24 PM To: [email protected] Subject: Excel question Hi Excel users, I'm an avid Excel user, but I'm stuck on this one. I'm editing a Excel file that has large amounts of narrative text in each cell. Because of this, when I hit F2 to edit the cell, WE has trouble reading the text at the top of the cell where I need to start editing because the cell editing window that drops from the toolbar covers over the top portion of the cell. Because the cell is so tall, I can't seem to jus scroll up so that the cell doesn't hide behind this editing window. My work around is to cut the cell text into a Word doc, edit there and paste it back into Excel, but that's just a band aid approach. I tried hiding the Standard & Formatting toolbars, but the drop down edit window isn't part of one of those. This is a corporate template, formatted for printing, so I can't just resize the cells. Using WE 7.2 and Excel 2003. Any experience in this situation and a recommendation? _________________________________ Robin Van Lant Sr. Strategic Services Program Manager Key Equipment Finance Tel: 720-304-1060 Email Classification: KeyCorp Public This communication may contain privileged and/or confidential information. It is intended solely for the use of the addressee. If you are not the intended recipient, you are strictly prohibited from disclosing, copying, distributing or using any of this information. If you received this communication in error, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. This communication may contain nonpublic personal information about consumers subject to the restrictions of the Gramm-Leach-Bliley Act. You may not directly or indirectly reuse or redisclose such information for any purpose other than to provide the services for which you are receiving the information. 127 Public Square, Cleveland, OH 44114 If you prefer not to receive future e-mail offers for products or services from Key send an e-mail to mailto:[email protected] with 'No Promotional E-mails' in the SUBJECT line. If you reply to this message it will be delivered to the original sender only. If your reply would benefit others on the list and your message is related to GW Micro, then please consider sending your message to [email protected] so the entire list will receive it. GW-Info messages are archived at http://www.gwmicro.com/gwinfo. You can manage your list subscription at http://www.gwmicro.com/listserv.
