View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default how do i copy only a portion of a spreadsheet

Are you trying to avoid copy|pasting hidden rows/columns?

If yes, then select your range to copy
edit|goto|special|visible cells only

then edit|copy
followed by edit|paste



tazsdad wrote:

I'm having trouble copying only a portion of my spreadsheets to another
folder. Highlighting the cells and copying and pasting, copies the entire
spreadsheet. I only want to copy what i have highlited while maintaing the
values.


--

Dave Peterson