how do i copy only a portion of a spreadsheet

T

tazsdad

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.
 
D

Dave Peterson

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
 
T

tazsdad

Dave, the problem still persists. When highliting only a few cells of the
spreadsheet, the entire spreadsheet is copied.
 
D

Dave Peterson

You're selecting a smaller range
then edit|copy
then selecting a new location
then edit|paste?
 
Top