Right Click to Autofill cells in 2003
In 97 to 2002 it was possible to right click when using Autofill to copy the
cells down rather than continuing the sequence. in 2003 i just get a pretty
red line (what purpose does this serve?). Does anyone know if I can get
back the old functionality?
I have that functionality in Excel 2003 as well, maybe you have installed an
add-in? In any case if you hold down ctrl while using the left click copy
down it will also copy as opposed to fill a series
> Hello All,
> In 97 to 2002 it was possi...How do I randomly shuffle the cells in a column?
In Excel 2003, I have a column, say a1-a10, with certain entries. I need to
create another column, b1-b10, with the same entries assigned randomly
(shuffled) to the cells.
Just one way ..
Put in B1: =INDEX(A:A,RANK(C1,$C$1:$C$10))
Put in C1: =RAND()
Select B1:C1, copy down to C10
B1:B10 returns a random shuffle of what's in A1:A10
Press F9 to re-shuffle
"Jason D" <Jason D@discussions.microsoft.com> wrote in message
>...Change Contract Status
My CRM implementation does not change automatically the Contract Status from
Active to Expired or from Invoiced to Active when the Contract End Date or,
respectively, the Contract Start Date comes. This was happening also in the
1.2 version and now the same happens in 3.0 version. Any ideas?
...How to change cell shading/fill based on value in another cell?
I have a sheet with two columns of experimental data. Let's say the
data is in F10:F25 (column 1) & G10:G25 (column 2).
There is a value in another cell (A1) that contains a 1 or a 2.
If A1=1, I want to turn shading in column 1 agree and in column 2 off.
If A1=2, I want to reverse that.
If there a worksheet function that will do that? I was hoping for
I could then execute one of these two statements:
If A1=1 then
cellshading(G10:G25,"Green&...font color not displayed
When selecting text to display in another color, it still displays in black
on my monitor. I have looked at my emails on the recipient's monitor, and the
color DOES display - just never on mine.
...Outlook 2003 Font Changes When Replying Plain Text
Outlook 2003 is exhibiting a strange behavior when replying to plain
text messages. After clicking the "Reply" button, the message appears
in the Arial font. In about two to three minutes, the font suddenly
changes to Courier which is the correct font.
Why is it taking so long for the font to change?
...How to get SUMPRODUCT on filtered cells
I'm currently using the formula
This gives me the number of the full range of cells but I need this to
update whenever I use a variety of filters.
Any help is greatly appreciated
Say we have data in A1 thru B29 like:
and are appling autofilter to column a. We want to use sumpr...Sum Multiple Worksheets, same named cell
I have multiple worksheets containing the same named cell (e.g. Month_Total).
On a totals worksheet, I am not able to use =SUM('START,END'!Month_Total)
because of the local/global naming. Is there a way around this?
(Month_Total will not always be in the same cell on each worksheet).
It seems to me that you have two options.
1. Name each of your "Monthly Total"s slightly different.
2. Do not use the cell range naming.
"uncreative" <firstname.lastname@example.org> wrote in message
news:60A150C6-50BC-4876-A31F-1C...how can you change a "bitmap" to a jpeg??
After taking digital pictures in BITMAP, how can I change them to JPEGS?
"TRM" <TRM@discussions.microsoft.com> wrote in message
> After taking digital pictures in BITMAP, how can I change them to
Get XnView or IrfanView. Both are free. Then use Save As and select
******** Post replies to newsgroup - Share with others ********
Email: lh_811newsATyahooDOTcom and append "=NEWS=" to Subject.
_________________...powerpoint texbox issue
Sorry for posting this twice but I could not find my previous post, but I
really need some help here.
We have a ppt 2007 problem. The problem is on our CEO's computer too!
We have ppt 2007 with all updates/service packs. The user will create a
textbox in powerpoint and starts typing, then saves the ppt file. When the
user goes back into the ptt file and clicks in the textbox and starts typing,
"randomly" the font will increase and the user has to set the font back.
Why Microsoft, why? This person uses powerpoint probably more than anyone
at our company, sin...Algebra within a cell
How do you set-up a formula in a cell that multiplies a constant times the number you insert? Ex. the constant is .315 remains present at all times only the number you insert changes - =.315*(x)
You can't unless you use an event macro, if you need a formula
you have to use another cell as help
where A2 holds x
you can also put 0.315 in a cell, copy it, select the cel with x and then
paste special and select multiply. But to get this instantly you have to use
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Intersect(Range("A2"), Target)...sbs 2008 under Updates, "change the software update settings" crashes console
Running SBS 2008 SP2, fresh install with just a couple users, I noticed that
under Security, Updates, in the Tasks window there is a "Change the software
update settings". When I click this link, the "Software Update Settings"
window appears for a split second then the SBS Console crashes saying
"Windows SBS 2008 Console has stopped working" with these details:
Problem Event Name: CLR20r3
Problem Signature 01: console.exe
Problem Signature 02: 6.0.5601.8497
Problem Signature 03: 4a612b8b...Color for chart series auto-assigned after 56?
Using Excel 2000, I am having a color issue with charts that exceed 5
series. Below is some sample VBA to reproduce the issue. The cod
creates a bar chart with 60 series. The RGB color I have chosen i
white (255, 255, 255). You will notice that beginning with series 57
the color of the columns no longer gets assigned the color that I want
Excel starts auto-assigning colors at this point. I have reproduce
this faithfully 100% of the time. Has anyone seen this before? I
there a programatic workaround so that I don't have to manually chang
the colors after the fact?
Sub ...Displaying Multiple Cell Information in Single Cell
I'm trying to present (text) data from multiple cells in another
workbook in a single cell. I've tried the following formula but it
returns a #VALUE! in my destination cell:
Any ideas on if this is possible?
SamuelT's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27501
View this thread: http://www.excelforum.com/showthread.php?threadid=503954
Use the "&...Formatting cells
Operating System: Mac OS X 10.5 (Leopard)
All of a sudden when I try to format a column of or an individual cell (format as a number, no decimal places, comma for thousands) only 2 of the four numbers appear in the cell. When I double click to view what is actually in the cell I see the four numbers I entered, the first two separated by the last two with a decimal. <br>
I have tried this on new sheets and workbooks and the same thing happens.
I can't tell for sure, but try going to Excel>Preferences> Edit. If there's
a check on '...How do I add multiple comments to a cell?
I need to add more than one comment to data in a single cell, is this possible?
> I need to add more than one comment to data in a single cell, is this possible?
...Font problem in property Sheet
I am working on a project, in whihc i am using the propertysheet. I am using
bitmap(bilbilt) as backgrpound in each of dialog of property sheet. When i
am running the application in English US OS it is working fine but in case
of japanese OS the back groud image(bitmap)is not coming correctlty. I think
this is font problem, Because default font is change from US OS to
Japanese. Because of font change dialog width is increasing and height is
decreasing. How we can stop to increase in Width and Decrease in height.
Essentially, while you can, it is a Really Bad Idea. Using bitmaps as backgr...deleting fonts
My computer uses Vista Home Premium. I just had to reset it to its original
state. I'm trying to delete fonts, but don't have permission. I am the only
user of this computer and its administrator.
When I've gone into the Fonts folder Properties - Security tab, the option
for Special permissions is grayed out. When I click the Advanced option
("For special permissions or advanced settings, I don't know what to do next.
Can someone please walk me through how to get permission in the Fonts folder
so I can delete fonts?
On Wed, 6 Jan 2010 07:...how to prompt user to click on cell for starting import position
This is a multi-part message in MIME format.
How would this be changed so that when the macro is run, it prompts the =
user to click on the cell to start copying in the data?
Selection.TextToColumns Destination:=3DRange("A1"), =
FieldInfo:=3DArray(Array(0, 1), Array(41, 1), Array(82, 1), =
Array(90, 1), Array(131, 1), _
Array(143, 1), Array(169, 1), Array(191, 1), Array(203, 1), =
Array(216...repeating cells in footer in excel
I need prepare a form with many lines. In this form I need to provide a
footer (with a group of cells) for approvement. Even I can select cells to
repeat in every page header there is no such a feature for footers.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http:...Changing Quickbooks to Excel
Hey, I'm trying to get my QuickBooks Check Registry into a linear
format, then put it on a disk, go to another computer and open it in
Excel. Can anyone give me a link or a quick walkthrough on what I need
to do, any help would be appreciated. Thanks!
mattsides's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25015
View this thread: http://www.excelforum.com/showthread.php?threadid=385419
"mattsides" <email@example.com>...Cell ref of max value in array
Using XL2002. Other answers in these discussions have given me nearly what
I'm after; please would someone complete this?
A large array of numbers: which cell in each row has the max value?
=MATCH(MAX(range),range,0) gets me its position, e.g. 44th cell along, but
how can I translate that to Column AR or cell ref AR6?
Try this on for size - if it doesn't work, let me know and we can twea
it. Later, Chad
cvolkert's Profile: http://...Locking cell if sum of other cells is 0
I would like cells G5,H5,I5, J5, K5, L5, M5, and N5 to be locked until
the sum of E5+F5 is greater than 0. I would like to do this for all rows
in the worksheet.
In this case you could use conditional formatting:
Go to cell G5
From the menu choose Data => Validation
"Ignore blank" checkbox: Unchecked (!)
Choose the "Error alert" tab and into Title field put something like "Input
restricted", into Error message field something like "The total of column E
and F must be > 0 before you can input data h...erratic color printing iof Publisher in PDF
I have printed my color newsletter using Primo to convert it to a PDF file.
I have told Primo that I want it in Black and White, not color.
Some of the pages in the 12-page black and white newsletter retain some color.
Outlines around articles and tables retain the color I had used in the color
I have told Primo that the paper quality is black and white AND in
experimenting, to try to figure this outI have also tried color.
When the blue and orange Primo box comes up, no matter whether I click print
or screen, I continue to get colors in the black and white issue.
garne...Macro to move to specified cells, pause for input at each?
Thanks Much! Pete
Is there a question here or are you just saying thanks to a response you
received to an earlier post?
If a question, please provide more detail or check out VBE help on "inputbox".
Gord Dibben Excel MVP
On Fri, 4 Mar 2005 17:41:01 -0800, "Pete in Montrose"
Thanks Much! Pete