Right click , drag and drop and cut , copy paste facilities
Why can't we have drag and drop , cut and paste facilities in any of the
Pretty limiting eh? Just chalk it up as one of many CRM shortcomings.
Sometimes you can right click, sometimes you can't. Just get in the habit
of using Ctrl + C and Ctrl + V.
Presentations Direct - Specialized Office Equipment & Supplies
"Nitin" <Nitin@discussions.microsoft.com> wrote in message
> Why can't we have drag and drop , cut and past...Creating a group of cells. Need Help Please.
Havn't used excel in a while and I need to create a group of cell
corresponding to an input of a min and a max.
Here are the details. On one sheet I have a box where you enter th
min and a box where you enter the max. In another sheet I want
column starting at A2 to output (MIN,A2+1000,A3+1000,....MAX) ho
would I do this
Thundersixx's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3055
View this thread: http://www.excelforum.com/showthread.php?threadid=50207
Name the...Outlook2003 : keeping a copy of PST on server
I can't seem find the place to make the change on the
client's outlook to keep a copy of the pst file on
exchange server. When I configured outlook I got the
message to go into tools and select the option to keep a
copy on server. I couldn't find that option and all mail
was delivered to the client. When you go through owa all
you will see is the new mail not delivered to the client.
I'm going to hack at it and when I find something I will
post my findings. But if someone already knows where to
look I would appreciate that
found this article
http://www...Macros for worksheet copy & paste?
I have 6 different excel files. How can I combine all 6
of them in one single excel file under individual
worksheets (E.g. Worksheet1 for File1, worksheet2 for
File2 ....etc)? I do not wish to copy & paste it
manually. Can I use a macro to take care of it? If so,
where can I find further info on how to go about it?
Assuming (1) this is a one-time need, and (2) your workbooks have
only one sheet each, this would probably be faster done by hand:
1) With all the files open choose one of the files to be the
2) Select the sheet in the subsequent books, one at...Move/Copy A Row Based on Formulas to a New Worksheet
I want to move several rows of sub-totals (averages within sub-groups) to a
summary worksheet, but I get the Ref error. How can I copy sub-group averages
to another worksheet?
high light and copy.
select where you want it.
this will turn you formulas into hard numbers.
you are getting the #Ref error because on the other sheet
where you pasted the formulas, the formula no longer had
the same references that they had on the other sheet.
=sum(a1:a10) in cell a11
you copy and paste on another sheet at cell a1.
excell tries to compensat...chart label reference based on the column number
In a worksheet with an embedded chart, I have a cell, S4, where I enter the
number of the column I want to chart (these numbers are listed as labels in
I can't figure out how to translate the number in S4 into the corresponding
column letter. For example, if S4 contains "3", the chart title should be
I think working with absolute references, R1C1, might be easier here, but
somehow what I've tried, didn't work (the entire spreadsheet is based on
relative addresses (A1).
in a cell (Z100) put
Change G2 to whatev...Volume shadow copy -- OK to disable?
I was doing a defrag and it kept stopping because of a conflict with
the Volume Shadow Copy service. A quick Internet search turned up a
site that recommended disabling the Volume Shadow Copy while defrag is
I did and that fixed the problem.
The site said to leave it disabled if I don't need it. It didn't say
how I could tell if I need it.
I left it disabled and everything seems to be working OK.
How can I tell if I can leave it disabled or if I need to reenable it?
htt...can servers be moved between administrative groups?
Below is an extract from the 70-284 MS training kit. I am totaly confused i
have been told in this newsgroup by an MVP that you can not move a server
once installed to a different administrative group and have also read
elsewhere that you cannot but Microsoft below say you can in both modes.
Subsequent Exchange servers are added to routing groups during the
installation process,and if necessary, you can move servers between routing
groups using Exchange System Manager. The only caveat is that in mixed mode,
you cannot move servers between routing groups that belong to different
administrative...Keyboard shortcut for current date and time
Ctrl+ ; inserts current date and Ctrl+Shift+; inserts current ti me
Ctrl+Shift+; inserts the current time with the date serial as 0 and
not the current date's date serial.
Presently I am adding the two (ie current date and time) to get the
current date and time. Is there a keyboard shortcut that does this?
Thanks in advance.
CTRL+; then SPACE then CTRL+SHIFT+;
Portland, Oregon USA
wrote in message
Ctrl+ ; inserts current dat...How do I get text to copy from one cell to another ?
Type = in the target cell. MouseClick the cell containing text. Pres
BrianB's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=5
View this thread: http://www.excelforum.com/showthread.php?threadid=27034
...Supress col/row increment with copy
Question with (hopefully) an easy answer....
When you copy a cell that uses a formula referring to another cell,
for simple illustration say "=C4" it will increment based on where
you paste it. So, it will increment up to "=C5" if you paste it in
the next cell, or "=D4" if you paste below.
How can I suppress that, so that when I paste the new cell receives
"=C4" as well.
(I know I can simply copy the text and paste that in, but I want to
copy a whole row of formulas to be the same. I thought
Paste>Special>Formulas would work, but it seems to ...How can I parse or Loop a list based on single field to Googlemaps
This is some code that will parse each sequential field [Point_#) into a list
"http://maps.google.co.uk/maps?f=q&hl=en&q=" & "from: " & Me.Point_1 & (" to:
" + Me.Point_2) & (" to: " + Me.Point_3)
The table/form is laid outlike this:
[Route_No] [Point_1] [Point_2] [Point_2]
5 North St, N1 East St, N3 High Road, W6
And the code will give this style of parsed list:
from: North St, N1 to: East St, N3 to: High Road, W6
That works just ...Copy/Paste formulas
How do I keep certain cells (those I want to point to a specific 'constant')
from incrementing while the remaing cells in my formulas increment as
expected. Example: ((E65)*(COUNTIF(I7:I7,"V"))) where the cell "E65" contains
a set value that I want to be placed in the result as I step down the
incremental (I) rows when the character "V" is found in the particular (I)
row. When I do my copy and paste, the (E) row increments as the (I) rows
> How do I keep certain cells (those I want to point to a specific...Changing default Print copies
I have a workbook that has a worksheet with default printing copies of
3. Even when I go to page setup and change the number of copies to
print to 1 it will automatically revert to 3 the next time I bring up
the print dialog. I have also looked through the VBA editor at the
worksheet for any oddities and have found none. Does anyone know how
to change this permanently?
Thanks in advance.
>Even when I go to page setup and change the number of copies to
> print to 1 it will automatically revert to 3 the next time I bring up
> the print dialog.
Look at the defaults for you...HOW DO I COPY FORMULA WITHOUT CHANGING CELL REFERENCE
My cell c1 contains the formula b1-a1.when i copy this formula to cells d1
and e1 the cells d1 and e1 have the following formula :
but i want the following
d1 should be b2-a2 and
e2 should be b3-a3
how do i do this?
In C1 enter & copy across:
> My cell c1 contains the formula b1-a1.when i copy this formula to cells d1
> and e1 the cells d1 and e1 have the following formula :
> but i want the following
> d1 should be b2-...Prevent Hidden Column data from being copied/pasted?
A student came up with a question that I haven't been able
to figure out yet in a recent Excel class.
They are hiding a column and protecting the worksheet in
the correct manner. They want to allow some users to
access and enter information in some cells. They do not
want the users to be able to copy and paste the
information from the hidden column. The question is how
can this be prevented?
For example, Column B is hidden. When they copy a range
such as A1:C10 and paste it to another worksheet, they are
getting the "hidden" data in Column B in B1:B10.
Any suggestions wou...Rule to automatically mark header to download based on contact list?
Is there a way to do this, or an add-in?
On Tue, 26 Apr 2005 04:44:35 -1000, rmc <email@example.com> wrote:
> Is there a way to do this, or an add-in?
What version of Outlook are you using?
Ben M. Schorr, MVP
"Ben M. Schorr - MVP" <firstname.lastname@example.org> wrote in message
> On Tue, 26 Apr 2005 04:44:35 -1000, rmc <email@example.com> wrote:
> > Is there a way to do this, or an add-in?
> What version of Outlook are you using?
>...Copying Publisher from One computer to another
I want to copy Publisher from my old computer to my new one, but if I can't
seem to locate all the files I need to make it work on the new computer. What
should I do?
You can't, you have to install it from the CD.
Microsoft MVP Expression
"Jasmin" <Jasmin@discussions.microsoft.com> wrote in message
|I want to copy Publisher from my old computer to my new one, but if I can't
| seem to locate all the files I need to make it work on the new computer.
| shoul...Copy data from one record to a new record on a sub form
I have a form showing patient details with a sub form displaying all
associated referral details for the patient. One patient can have more than
one referral and I would like to be able to copy data from some of the fields
on the current referral when adding a new referral for the same patient. Is
Thank you for your help
I am fairly new to Access code and I am having some problem following your
suggestion could you please simplify. Also some of the fields on the referral
records are selected via a combo box will these fields still copy?
> ...copying rows from next sheet over
I'm trying to copy a range of rows from one sheet over from the activ
sheet, and paste them onto another sheet.
This is what I tried:
However, I'm getting the error "selection method of the range clas
What am I doing wrong, and is there an alternative way to do this?
Any help would be appreciated
ayl322's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=984
View this thread: http://www.excel...Dialog based problem in vc6
I am writing an mfc project in vs6 and I have a problem!
When I add radio button to my dialog based application and run the
application and press that button my application hang, even when I try to
run it in the test mode inside visual studio and press that radio button it
stack the all environment why??
It append only if I add a radio button for a regular button its all ok!
I install sp-6 but it didn't solve the problem.
"Dave" <firstname.lastname@example.org> wrote in message
> I am writing an mfc project in ...Change Copy to what?
In my Private sub I have Copy, What if I only want to copy data and not the
format what would I change it too?
Thanks in advance for your help....Bob Vance
Bob, don't know what you have in your code, but could you use something like
Range("A1:A200") = Range("B1:B200").Value
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
"Bob ...Utility to process rules based on message receive times?
Does anyone know of a utility that will check a mailbox and process Outlook
rules based on how long a message has been in an inbox, and/or remained
Yes, there is at least one - Auto-mate.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exch...copy & insert based on criterial
When Department changes I need to insert the ADDRESS below the
Account-Institution Business Office:. Another option I have is that if
address = get new address from page 2. HELP
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx ending 02/13/10
Account-Institution Business Office:
DEPT EMP.NBR EMPLOYEE NAME ADDRESS
883 27903 ROBERSON, JOE abc
883 119245 MUSIL, TODD E abc
Account-Institution Business Office:
DEPT EMP.NBR EMPLO...Stopping contacts being copied to Hotmail
It seems that Live Mail automatically copies my contacts list into my Hotmail
contacts. Is there any way of stopping this?
Someone is hacking in somewhere and sending spam to all my contacts. I'm not
sure whether they're doing this direct through Live Mail or through Hotmail.
Anyone know which?
Change your password immediately.
You may also want to review this post:
And also this blog entry from the Windows Live team: