PC Review


Reply
Thread Tools Rate Thread

Copy Spread Sheet

 
 
dcb1
Guest
Posts: n/a
 
      23rd Sep 2010
How can I copy my spreadsheet to sheet 2 without the rows, columns, or
anything else changing?
 
Reply With Quote
 
 
 
 
Dave Peterson
Guest
Posts: n/a
 
      23rd Sep 2010
I just ctrl-click and drag the worksheet tab.

Then rename the new worksheet to what I want.

You can also use:
Edit|Move or Copy sheet
(in xl2003 menus)

On 09/23/2010 13:12, dcb1 wrote:
> How can I copy my spreadsheet to sheet 2 without the rows, columns, or
> anything else changing?


--
Dave Peterson
 
Reply With Quote
 
dcb1
Guest
Posts: n/a
 
      24th Sep 2010
Thanks for responding. However, when I copy it to sheet 2, the rows
and columns are different.

On Sep 23, 2:09*pm, Dave Peterson <peter...@XSPAMverizon.net> wrote:
> I just ctrl-click and drag the worksheet tab.
> > Then rename the new worksheet to what I want.

>
> You can also use:
> Edit|Move or Copy sheet
> (in xl2003 menus)
>
> On 09/23/2010 13:12, dcb1 wrote:
>
> > How can I copy my spreadsheet to sheet 2 without the rows, columns, or
> > anything else changing?

>
> --
> Dave Peterson


 
Reply With Quote
 
Trekman
Guest
Posts: n/a
 
      24th Sep 2010
On Sep 24, 1:53*am, dcb1 <im4dalla...@gmail.com> wrote:
> Thanks for responding. However, when I copy it to sheet 2, the rows
> and columns are different.
>
> On Sep 23, 2:09*pm, Dave Peterson <peter...@XSPAMverizon.net> wrote:
>
>
>
> > I just ctrl-click and drag the worksheet tab.
> > > Then rename the new worksheet to what I want.

>
> > You can also use:
> > Edit|Move or Copy sheet
> > (in xl2003 menus)

>
> > On 09/23/2010 13:12, dcb1 wrote:

>
> > > How can I copy my spreadsheet to sheet 2 without the rows, columns, or
> > > anything else changing?

>
> > --
> > Dave Peterson- Hide quoted text -

>
> - Show quoted text -


You need to be copying the SHEET ... not copying to an already
existing sheet. If in Excel 2007, right click the tab of the sheet
you want duplicated and choose "Move or copy ..." then make a choice
of where to position the copied sheet. In Excel 2003, follow Dave's
option being sure to "Edit / Move or copy SHEET".
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Do a move copy of a spread sheet jln via AccessMonster.com Microsoft Access VBA Modules 4 4th May 2007 09:04 PM
Copy Excel Spread Sheet to Front Page =?Utf-8?B?cmFkZW8=?= Microsoft Frontpage 4 6th Mar 2006 01:28 PM
Copy and paste spread sheet broogle Microsoft Excel Programming 2 21st Mar 2005 02:22 AM
Can't copy comments between spread sheet Plan Schedule Microsoft Excel Misc 1 12th Aug 2004 11:03 AM
Can't edit copy paste into excel spread sheet =?Utf-8?B?S2Vu?= Windows XP Photos 2 10th Feb 2004 06:50 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:55 PM.