Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-27-2010, 12:17 PM
theacegary theacegary is offline Formula not getting copied to entire column Windows XP Formula not getting copied to entire column Office 2007
Novice
Formula not getting copied to entire column
 
Join Date: Nov 2010
Posts: 1
theacegary is on a distinguished road
Default Formula not getting copied to entire column

Hi,



Im working on XP SP3 and using MS Office 2007.Im Sorry for my silly issue but im new to excel .

I have a formula in a cell which i want to be copied to the entire column.I have tried clickng on the bottom right of the cell which contains the formula and also tried dragging it all the way till where i want the formula but it doesnt work .It copies the actual value in the cell to the entire column.

Not sure what Im doing wrong.

Thx in advance for your help!!
Reply With Quote
  #2  
Old 11-29-2010, 02:18 PM
KsT KsT is offline Formula not getting copied to entire column Windows XP Formula not getting copied to entire column Office 2007
Novice
 
Join Date: Nov 2010
Location: Northeast
Posts: 10
KsT is on a distinguished road
Default

Hi theacegary,

Click once on the cell (you do not want to be in edit mode, which is a doubleclick), right click your mouse, select copy, move to the first cell you want to copy to, left click and hold the button down while you drag the mouse down the column to wherever you intend to end the calculations, release the left mouse button, right click your mouse anywhere in the highlighted column and select paste. Hope this helps.

KsT
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula not getting copied to entire column How do I remove [enter]s in copied doc? technofleep Word 7 06-28-2016 04:39 PM
Formula not getting copied to entire column Word Doc Copied from HTML Pat801 Word 2 03-30-2010 01:37 PM
Moving Entire Text Sleeper Word 2 01-10-2010 04:40 PM
WORD taking up entire CPU!!! pureride Word 0 03-28-2008 09:46 AM
**FIND OUT WHO WAS BCC(BLIND CARBON COPIED) ON YOUR EMAILS?? sharpescalade Outlook 1 11-30-2006 08:07 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:23 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft