Re: [JAWS-Users] Excel pasteing all cell features
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]
Re: [JAWS-Users] Excel pasteing all cell features
Annette, Remember, one thing that will not be adjusted when copying and pasting data from one worksheet to another is the column width. All other attributes, such as alignment, number formatting, font, etc. should transfer okay. This is actually the default, so you really don't need to use the paste special function. You can simply use control-v. The only way to get the column width to transfer is to select the entire column using the control-space bar function, copy it and paste it. This will copy the entire column, including all of its formatting. Remember, though, that you must be focused on the top row of the spreadsheet you are pasting to before pressing control-v. Otherwise you will get an error message. Darrin 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]
Re: [JAWS-Users] Excel pasteing all cell features
Thank you very much for that info. I can now stop knocking my head against this brick wall of a computer. I'll have to re-think what I had planned to do. Again, Thanks! Annette -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Darrin Porter Sent: Wednesday, September 12, 2007 8:20 AM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Excel pasteing all cell features Annette, Remember, one thing that will not be adjusted when copying and pasting data from one worksheet to another is the column width. All other attributes, such as alignment, number formatting, font, etc. should transfer okay. This is actually the default, so you really don't need to use the paste special function. You can simply use control-v. The only way to get the column width to transfer is to select the entire column using the control-space bar function, copy it and paste it. This will copy the entire column, including all of its formatting. Remember, though, that you must be focused on the top row of the spreadsheet you are pasting to before pressing control-v. Otherwise you will get an error message. Darrin 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]
[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]
Re: [JAWS-Users] Excel pasteing all cell features
Hi, Try using link worksheets and see how it works. Select your desired cells to copy, go to the worksheet where you want to copy, activate Edit menu and press S, then L to paste link. - Original Message - From: Annette Carr [EMAIL PROTECTED] To: jaws-users-list@jaws-users.com Sent: Wednesday, September 12, 2007 12:58 AM 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] ___ The all-new Yahoo! Mail goes wherever you go - free your email address from your Internet provider. http://uk.docs.yahoo.com/nowyoucan.html 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]