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
In Excel, I need a macro that will delete a column based on a cell
that will contain a name based on an input box.
See you OTHER post.
"Bernie" <firstname.lastname@example.org> wrote in message
> In Excel, I need a macro that will delete a column based on a cell
> that will contain a name based on an input box.
...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&...Hide Classifications in Money 2007?
I was wondering if it is possible to hide the classification line in the
advanced register of Money 2007. In earlier versions, if no classes were
defined, the line would not show.
In all versions I've used (that's every one since Mv2) classification shows
if classification1 is defined. Somehow I'm suspecting your classification1
got defined. Account List | Categories & Payees . Click on the first
classification. If it doesn't ask you to define it, there will be a choice
for Delete classification. That's where you'd want to go.
"...add result column to pivot table
I have 2 columns in a pivot table - decription and
amount. I need to calc a % of each value of the total.
I don't know how to do that.
Add another copy of the Amount field to the pivot table's data area.
To display, the fields horizontally, drag the Data button, onto the cell
that contains the word 'Total' -- there's a picture here:
Right-click on the heading for the second Amount column
Choose Field Settings
Click the Options button
Type a Name for the field, e.g. Percent
Choose to 'Show Data as' % of column
Cli...How keep chart-datapoints displayed when column-width is set to zero
my data basis for a chart has one column,
that I don't want to be shown in the spreadsheet.
However, when I set this column's width to zero,
the correspondig data dissapear from the chart.
How can I have both, a hidden column and its
values shown in the chart at the same time ?
Select the chart, then select Options from the Tools menu, click on the
Chart tab, and UNcheck the Plot Visible Cells Only checkbox.
Jon Peltier, Microsoft Excel MVP
&...increase column number limit?
Is there a way to increase the number of columns beyond ~260? Thanks
"bill northlich" <email@example.com> wrote in message news:eE3bpxpYDHA.212@TK2MSFTNGP12.phx.gbl...
> Is there a way to increase the number of columns beyond ~260? Thanks
256 is the max.
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP
Attitude - A little thing that makes a BIG difference
-----------...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...Each new window showing up in start bar--want to turn this off
I'm a new user to Outlook. Everytime I open a new email it puts a new item
on my Start bar. Now my Start bar is cluttered because I have more than one
message open at once. Where is the option to change this?
"pickytweety" <email@example.com> wrote in message
> I'm a new user to Outlook. Everytime I open a new email it puts a new item
> on my Start bar. Now my Start bar is cluttered because I have more than one
> message open at once. Where is the...Caption bar disappears suddenly
While working with windows application(Win XP, SP2) suddenly caption bar
disappears for all the windows. This
occurs only when the theme is Windows XP(modified). When we switch to
"Windows classic" theme this problem does not occur.
Have any one come across this problem? Is there any patch from Windows?
Thanks & Regards,
Dont know about the problem but MFC has nothing to do with this.
"VSP" <VSP@VSP.com> wrote in message
> While working with windows application(Win XP, SP2) su...How to group all data from 1 column into several columns (Redo)
I have 2 columns in my spreadsheet, Company Names and Event. The Event column
values are Event 1, Event 2, Event 3, Event 4 and the company names repeat
for each of the events that they attended. So sometimes I might have a
company listed 4 times with each Event corresponding to it in the next
column. How can I consolidate all of the company names so that there is 1 row
for each company and all events are on the same row but in different columns
marked with an x (the column labels will be Company name, Event 1, Event 2,
Event 3, Event 4).
This is what I have...
Company Name...Columns to Rows
I'm sure this is a simple problem but I'm trying to convert columns o
data into rows of data. What's the easiest way
Message posted from http://www.ExcelForum.com
try the following:
- copy your column (CTRL+C)
- goto 'Edit - Paste Special) and choose 'Transpose' as action
> I'm sure this is a simple problem but I'm trying to convert columns
> data into rows of data. What's the easiest way?
> Message posted from http://www.ExcelForum.com/
Just read Tom's post, paste special and then transpose
Messag...charting a single bar graph on one line showing continuous info
I must do a time graph showing total workhours with tick marks showing begin
and end of tours on a dialy basis. I cannot get the custom or standard chart
graph functions to do this without putting in all of the data. I just want
the begin tour and end tour of each person. can you help. thx
...Overlay 4 years of data as a line on 4 years of columns for several x category labels
Dear Charting aficianados,
The tutorial at
http://peltiertech.com/Excel/Charts/ClusterColAndLine.html is the
closest example I can find to a charting conundrum I am facing, though
what I am hoping to achieve is still a little different.
I've made a mock up of what I'm hoping to achieve - though I have had
to use drawing objects for the line series, to overlay on the columns -
I'm sure there is a way to get excel to do this - do you think there
is? (sheet named mock-up)
A workbook with mocuk-up and my other charting attmempts can be found:
I'd like to hide the service appointment and campaign response activities
options when I want to create a new activity.
I was change the dlg_create.aspx file and comment the render list item. I
don't like the idea to manipulate this file, and I want to know if is
possible to hide this options in other way.
yes you can hid
see your id's
document.all.navContacts.style.display = "none";
MS CRM Certified Professional
Chat with me on MSN / Gmail / Skype : ID Is :.. firstname.lastname@example.org
"...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)...Error bars not displaying properly
I have plotted my data in a column graph, and added error bars based on
custom values. I know how to edit and format the error bars, but nothing I
have changed fixes my problem:
The error bars "join up" to give diagonal lines between between my columns.
I have NEVER had this issue in previous versions of Excel. If I plot the
error bars in pre-2007 excel, they're fine, until I open them in excel-2007.
If I remove the error bars, and plot them afresh in excel-2007, I get the
It doesn't happen to every error bar, just some of them, for no apparent
...is there a way to make the bars on a bar chart narrower?
mcarrington's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=21641
View this thread: http://www.excelforum.com/showthread.php?threadid=498513
Have you tried right clicking a bar then Format Data Series then change
the Gap width?
sorry, I left out one step...
Right click a bar>Format Data Series>Options>change Gap Width.
...Drop down box with country list
I have an excel application where I need a drop down box with all the
country' names listed, ready to use (like the Microsoft Date and Time
Picker Control). Is there a way to get it and how? John
Enter the countries in a range (say column M) and then add a Data Validation
(Data>Validation) and select the List option with a formula of say =M1:M100
or however many countries
"john liem" <email@example.com> wrote in message
> I have an excel applic...Title Cut Off if Rows to Repeat & Columns to Repeat are Both Selec
I need a way to fix a print problem. When I go into File - Page Setup, and I
choose which rows to repeat at the top ($1:$5) and select which columns to
repeat at left ($A:$A), the rows at the top never print completely on pages 2
through the end. Only on the first page can I see the entire title and
subtitle. On the remaining pages they get cut off where Column B would
begin. Can I fix this?
Select only the rows to repeat at the top, and see if that solves your problem
firstname.lastname@example.org_2nd_at. Randburg, Gauteng, South Africa
> ...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 "&...sorting text in 2 columns by likeness
I have 2 columns of text with number values associated with them.
Amy 21 Amanda 12
Bill 12 Amy 18
Chris 32 Bill 23
Kathy 8 Chris 12
Kim 15 Curtis 32
Todd 23 Katrhy 21
I need to be able to sort these like this
Amy 21 Amy 18
Bill 12 Bill 23
Chris 32 Chris ...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 '...