Hello Bill,
1. Navigate to the cell that contains the formatting you want to use. Use CTRL+C, which will copy text, formatting, formulas, etc. 2. Use CTRL+G to bring up the "go to" dialog and type in the range a9:a1000000 if you want rows 9 through 1000000 to have a certain formatting in column A. Excel 2007 has well over 1000000 rows that can be used. Press enter key to complete the selecting of the range of cells. 3. Press the application key and use down arrow to the "paste special" choice. Press enter key on that choice. 4. In the resulting dialog box use down arrow in the group of radio buttons for selecting what is to be pasted until you get to the choice for formatting and press enter key. 5. Use an arrow key or another navigating command to remove selection. 6. Use insert+f in a few of the cells to confirm that the formatting you wanted was used. Take care. Brian Lee brianl...@charter.net -----Original Message----- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Bill Tipton Sent: Thursday, February 04, 2010 7:24 PM To: jaws-users-list@jaws-users.com Subject: [JAWS-Users] Copying Formatting In Excel 2007 Hi, How do you copy the complete formatting that is in one cell to another in Excel 2007? I already have data in the cells. Can I also paste the formatting starting in position A9 to the bottom of column A? I do not want to effect the formatting above row 8. How can I do the two above. Thank you, Bill For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/