After pasting all, repeat the paste special individually for FROMAT and CELL WIDTH etc.
----- Original Message ----- From: "Annette Carr" <[EMAIL PROTECTED]> To: <jaws-users-list@jaws-users.com> Sent: Tuesday, September 11, 2007 7:58 PM Subject: [JAWS-Users] Excel pasteing all cell features >I am trying to copy and paste information from one work sheet to another. > However, when I do this, the cell formatting is not being pasted along > with > the cell contents. I am using the paste special option, and selecting > "All". Any idea what I am doing wrong? > > Annette > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Darrin Porter > Sent: Tuesday, September 11, 2007 8:50 AM > To: jaws-users-list@jaws-users.com > Subject: Re: [JAWS-Users] Finding out column width in excel > > Annette, > > I am an engineer and use Excel daily (office 2003 /JFW 8). Excel measures > everything in points (printer's points). In JFW 8, pressing insert-f > twice > quickly will describe the atributes of the active cell to you in a > dialogue > box. One of the pieces of information provided is the height and width of > the cell in points, e.g., "cell dimentions are 54 points wide by 12 points > heigh." The number of characters you can fit in 54 points depends on the > font you have selected. > > All cells in a column must be the same width. That's why there is no way > to > individually adjust the width of a cell. > > It is a quirk of Excel that you can enter a column width in number of > characters instead of points I guess this makes it easier for some > people. > But, for the purposes of laying out a page, the only way you will be able > to > know if everything fits widthwise is to add up the active column widths in > points. For a typical portrait layout with 3/4-in. margins, you have a > total width of 432 points to work with. For a landscape layout with the > same margins, you have a total of 684 points to work with. > > Hope this clears things up for you. > > One final note, in earlier versions of JAWS, you only need to press > insert-f > once to hear the cell's attributes. > > > > > Darrin Porter > Senior Technical Engineer > TECO Ocean Shipping > 1300 East 8th Avenue, Suite S-300 > Tampa, Florida 33605 > (813) 209-4247 > (813) 242-4849 (fax) > [EMAIL PROTECTED] > > Visit the JAWS Users List home page at: > http://www.jaws-users.com > Address for the list archives: > http://www.mail-archive.com/jaws-users-list@jaws-users.com > To post to this group, send email to > jaws-users-list@jaws-users.com > To unsubscribe from this group, send an email to > [EMAIL PROTECTED] > For help from Mailman with your account Put the word help in the subject > or > body of a blank message to: > [EMAIL PROTECTED] > Use the following form in order to contact the management team > http://www.jaws-users.com/managers.php > If you wish to join the Blind Computing list send a blank email to the > following address: > [EMAIL PROTECTED] > > > Visit the JAWS Users List home page at: > http://www.jaws-users.com > Address for the list archives: > http://www.mail-archive.com/jaws-users-list@jaws-users.com > To post to this group, send email to > jaws-users-list@jaws-users.com > To unsubscribe from this group, send an email to > [EMAIL PROTECTED] > For help from Mailman with your account Put the word help in the subject > or body of a blank message to: > [EMAIL PROTECTED] > Use the following form in order to contact the management team > http://www.jaws-users.com/managers.php > If you wish to join the Blind Computing list send a blank email to the > following address: > [EMAIL PROTECTED] > Visit the JAWS Users List home page at: http://www.jaws-users.com Address for the list archives: http://www.mail-archive.com/jaws-users-list@jaws-users.com To post to this group, send email to jaws-users-list@jaws-users.com To unsubscribe from this group, send an email to [EMAIL PROTECTED] For help from Mailman with your account Put the word help in the subject or body of a blank message to: [EMAIL PROTECTED] Use the following form in order to contact the management team http://www.jaws-users.com/managers.php If you wish to join the Blind Computing list send a blank email to the following address: [EMAIL PROTECTED]