ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do i copy only a portion of a spreadsheet (https://www.excelbanter.com/excel-discussion-misc-queries/58808-how-do-i-copy-only-portion-spreadsheet.html)

tazsdad

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.

Dave Peterson

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

tazsdad

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


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