![]() |
how do i copy only a portion of a spreadsheet
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. |
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 |
how do i copy only a portion of a spreadsheet
Dave, the problem still persists. When highliting only a few cells of the
spreadsheet, the entire spreadsheet is copied. "Dave Peterson" wrote: 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 |
how do i copy only a portion of a spreadsheet
You're selecting a smaller range
then edit|copy then selecting a new location then edit|paste? tazsdad wrote: Dave, the problem still persists. When highliting only a few cells of the spreadsheet, the entire spreadsheet is copied. "Dave Peterson" wrote: 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 -- Dave Peterson |
All times are GMT +1. The time now is 09:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com