A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Unable to copy formula from one cell into 2 or more consecutive ce



 
 
Thread Tools Display Modes
  #1  
Old March 19th, 2010, 08:00 PM posted to microsoft.public.excel.misc
Mikie1
external usenet poster
 
Posts: 7
Default Unable to copy formula from one cell into 2 or more consecutive ce

I have a Gateway laptop NX 860 XL, with a 2ghz Intel Core 2 duo and 2
gigabytes of RAM running Windows 7. The system originally came with Windows
Vista and MS Office 2007 Standard. I did an upgrade install to Win 7 last
October. MS Office is currently at SP2. All updates are applied automatically
so everything should be current.

The problem is as follows: I have, for example, a formula in cell F1 I want
to copy to cells F2 through F10. I right click Cell F1, and select 'copy'. I
then select Cells F2 through F10 and choose 'paste'. Nothing is copied. I
have also tried this with all the options available in 'Paste Special' and
still get nothing.

Please note that if I only select only one cell and then paste, the
information is successfully copied. I can successfully copy to one cell
anywhere else in the spreadsheet. Only when I select 2 or more cells do I
have a problem.

This issue occurs whether I am copying simple text, simple numbers or
formulas. I have run Microsoft Office Diagnostics and had no issues reported.

Is there a setting somewhere that I have missed? Thanks in advance for any
help that can be provided.


  #2  
Old March 23rd, 2010, 04:39 AM posted to microsoft.public.excel.misc
Bruce Masteller
external usenet poster
 
Posts: 4
Default Unable to copy formula from one cell into 2 or more consecutive ce

Have you tried the fill handle? Select the cell with the formula. Move the
curser to the bottom right corner of the cell until you get a +. Click and
drag left/right or up/down the desired number of cells then release the mouse.

Another option is to use the keyboard shortcuts to copy and paste. Select
you cell with the formula and press Ctrl+C. Select the cell(s) you want to
paste to, then press Ctrl+V

"Mikie1" wrote:

I have a Gateway laptop NX 860 XL, with a 2ghz Intel Core 2 duo and 2
gigabytes of RAM running Windows 7. The system originally came with Windows
Vista and MS Office 2007 Standard. I did an upgrade install to Win 7 last
October. MS Office is currently at SP2. All updates are applied automatically
so everything should be current.

The problem is as follows: I have, for example, a formula in cell F1 I want
to copy to cells F2 through F10. I right click Cell F1, and select 'copy'. I
then select Cells F2 through F10 and choose 'paste'. Nothing is copied. I
have also tried this with all the options available in 'Paste Special' and
still get nothing.

Please note that if I only select only one cell and then paste, the
information is successfully copied. I can successfully copy to one cell
anywhere else in the spreadsheet. Only when I select 2 or more cells do I
have a problem.

This issue occurs whether I am copying simple text, simple numbers or
formulas. I have run Microsoft Office Diagnostics and had no issues reported.

Is there a setting somewhere that I have missed? Thanks in advance for any
help that can be provided.


  #3  
Old March 26th, 2010, 09:21 PM posted to microsoft.public.excel.misc
Mikie1
external usenet poster
 
Posts: 7
Default Unable to copy formula from one cell into 2 or more consecutiv

Sorry I have not posted a 'thank you' sooner. Your suggestion worked. I would
have never thought to do your suggestion because I am so used to doing things
one way. I don't understand, though, why right-clicking and selecting 'copy'
in a cell, then selecting a range of cells underneath and pasting the copied
formula doesn't work. It works if I copy to only one cell, just not more
than one cell. A puzzle which I will have to look into.

Thanks again for the help.

"Bruce Masteller" wrote:

Have you tried the fill handle? Select the cell with the formula. Move the
curser to the bottom right corner of the cell until you get a +. Click and
drag left/right or up/down the desired number of cells then release the mouse.

Another option is to use the keyboard shortcuts to copy and paste. Select
you cell with the formula and press Ctrl+C. Select the cell(s) you want to
paste to, then press Ctrl+V

"Mikie1" wrote:

I have a Gateway laptop NX 860 XL, with a 2ghz Intel Core 2 duo and 2
gigabytes of RAM running Windows 7. The system originally came with Windows
Vista and MS Office 2007 Standard. I did an upgrade install to Win 7 last
October. MS Office is currently at SP2. All updates are applied automatically
so everything should be current.

The problem is as follows: I have, for example, a formula in cell F1 I want
to copy to cells F2 through F10. I right click Cell F1, and select 'copy'. I
then select Cells F2 through F10 and choose 'paste'. Nothing is copied. I
have also tried this with all the options available in 'Paste Special' and
still get nothing.

Please note that if I only select only one cell and then paste, the
information is successfully copied. I can successfully copy to one cell
anywhere else in the spreadsheet. Only when I select 2 or more cells do I
have a problem.

This issue occurs whether I am copying simple text, simple numbers or
formulas. I have run Microsoft Office Diagnostics and had no issues reported.

Is there a setting somewhere that I have missed? Thanks in advance for any
help that can be provided.


 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:51 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.