View Single Post
 
Old 02-23-2010, 04:08 PM
StarWeaver StarWeaver is offline Windows 7 Office 2007
Novice
 
Join Date: Feb 2010
Posts: 1
StarWeaver is on a distinguished road
Question Cut and paste a range of cells and preserve formatting

In Excel 2007 I have a table with formatted cells (color filled and bordered). I need to move (cut and paste) the values, but not the formatting, to another part of the spreadsheet. When I select a range of cells, it takes the formatting with it and leaves blank white cells -- the color and borders are gone. If I cut and paste just one cell, however, I have the option under the Paste menu to paste only the value. How can I make this option available for a range of cells and not just one?
Reply With Quote