Is it possible to add a base line in excel
I have a graph the tracks test scores. I want to establish in a bar chart a
base line for acceptable test scores. I can do this by drawing a line on the
chart but I want to be able to include this in the chart itself.
Tom King wrote:
> I have a graph the tracks test scores. I want to establish in a bar
> chart a base line for acceptable test scores. I can do th...Multiple hyperlinks in one cell
I'm stuck with an excel problem which I cannot solve. I want to pu
different messages in one cell and add a hyperlink to some of thes
For example I want to put this information all into one cell
"message1 - message2(with hyperlink) - message3(with hyperlink)
I really hope it is possible to create multiple hyperlinks within on
cell, but for now I can only add a hyperlink to a cell.
If you would know how I could fix this issue I would be reall
Thx in advance,
Message posted from http://www.ExcelForum.com
If it's really...how do I add times in Excel and result in hours & mins
I want to insert a time when I start work and a time when I take a break,
then a time when I leave work.
Following that I want to be able to add up the amount of hours that I have
This will enable me to plan my week ahead and ensure I only allocate a
specific amount of time to a project.
Microsoft MVP - Excel
"Rty Shaw" <Rty Shaw@discussions.microsoft.com> wrote in message
>I want to insert a time when I start work and...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...Comments in Cells disappear after time
A colleague has a spreadsheet with lots of comments in the cells and
apparently after a while the comments 'disappear'. Does anyone have any
ideas why this happens? Could it be there is a maximum number of comments,
or do they have a life expectancy? The sheet is opened in Excel 2000 & Excel
2003 depending on the user.
Thanks for your help.
Comments don't normally disappear on their own. Perhaps your colleague
is accidentally deleting the rows or columns in which the comments
occur. Or comments could disappear if another cell, with no comment, is
dragged onto a cell ...VBA from another app: Suppressing Excel confirmation dialog?
After creating/formatting several worksheets from MS Access, I'd like to delete
the "Sheetn" worksheets that got put there when I did a .WorkBooks.Add.
I avoided using them because I'm not sure how/why they are created - i.e. maybe
some user's defaults would only create 1 empty sheet or none.
So, form MS Access's VBA I'd like to do:
On Error Resume Next
On Erro...Opening a new instance of Excel
I am using multiple monitors for work and it is great! Is
there a setting that I can use so that it opens each new
excel file in a new excel window so I can drag different
ones to each monitor? Is there a similar setting for Word?
I am using Excel 2002 and Word 2002.
Yes, you can check the Windows in Taskbar checkbox in
Tools; Options. This is on the View tab for both Word
>I am using multiple monitors for work and it is great!
>there a setting that I can use so that it opens each new
>excel file in a new excel ...Importing Data into an Excel Pivot Table via Access
I have set up a query in Microsoft Access which is linked to our AS400
server. I have created pararmeters within Access which asks for certain
fields which works. I then go into Excel and create a pivot table with the
external data source that I have created in access. When I go to enter a
pararmeter within Microsof Query I get a reply saying that "Parameters can
not be used with this Query", what I want to do is setup a parameter on the
Excel spreadsheet which then goes and gets the data i require from this
parameter. I would be very grateful if someone could help me with thi...Illegal operation error while printing EXCEL or WORD Files
I am facing an illegal operation error when i try to print any file from
excel (any no. of pages), this happens in stand alone printer as well as a
When we press the print button, it flashes this message, but still prints,
but once the printing is completed, i will have to restart the PC. Due to
this error other applications PRINTING also will NOT HAPPEN and the only way
out is, restart the PC.
This happens not only in EXCEL, it happens in all the MS applications
(outlook, access, front page, powerpoint also).
When I check the print manager (before restart),...go to next cell and paste question
I am writing a macro that is supposed to take certain cells from a
"interface" page, remove them, and paste to a string of cells o
another. That is easy, but I cant figure out how to make them go t
another set of cells, if the ones I recorded are filled.
' Macro1 Macro
' Macro recorded 8/4/2004 by Lane Lacy
ActiveWindow.ScrollColumn = 239
Application.CutCopyMode = False
Sheets("productivity&qu...Emailing in excel 2003 02-26-10
If i type in the cell A34: neil.Holden@test.com and press a button is it
possible to email to the address of what ever is in A34 is?
The email body should say: this has been submitted for cell B34 and todays
Check out Ron De Bruins "Send-Mail" tips:
"Neil Holden" wrote:
> If i type in the cell A34: neil.Holden@test.com and press a button is it
> possible to email to the address of what ever is in A34 is?
> The email body should say: this has been submitted for cell B34 and...Linking a graph to a csv file
Hello, I'm sure this is exceedingly easy, but somehow,
I'm screwing this up. I ultimately need to have a self-
updating PowerPoint file (client mandates a ppt file).
According to ppt's help, that means I have to use linked
Excel graphs, not embedded ppt graphs. However, my
programmer will be supplying me with tons of csv files.
When I try to create an excel file with a data link to a
csv file, it tells me that it can't update it unless I
open the source file. I *can't* take the time to open
each csv - there will be hundreds. What am I missing
I use Excel and Word 2003 using Windows NT. I've kept some files on a jump
drive so I can work on them at home. I attempted to work on a Word documents
which had an Excel worksheet inserted in it. I tried double clicking on the
worksheet to edit it and Word and Excel shut down. Now when I attempt to
open Excel at home it asks for my Office XP Professional installation cd. (I
have Office XP at home with Windows XP). I'm having a hard time locating my
original discs. Does anyone have any suggestions or experience anything like
...Wrapping clipart around text
When i word i can wrap my text around my pictures is there any way of doing
the same in Publisher 2000.
Thank you for reading my post. Hopefully you can answer my querie
On the toolbar there is a hand holding a script. This is the wrap tool. Select
the object, select the tool.
Mary Sauer MSFT MVP
"Shazza" <email@example.com> wrote in message
> When i word i can wrap my text around my pictures is there any way of d...Does anyone have a dashboard gauge (speedometer style) for Excel?
I am trying to create dashboard charts from Excel data and would love other
templates not available in Excel today - speedometer charts, multi-dimension
comparitive charts, charts that build information overlays.
I regularly create these in a manual way for executive and customer
summaries but would appreciate the ability to automatically generate these
types of charts allowing for real time viewing of "what if" scenarios.
Steve, there are tons of these things out there to review, few better than
Andy Pope has put together...Merge Cells #5
I know how to merge two cells using formula =A1&B1, but can someone tell me
how to insert spacing between the two within the new cell. I'm merging a
part number and description, and need spacing between them.
the " " is showing that you want to insert text, and that the text is a
space character. It could be "-" or ".", etc.
"R. Stevens" <R. Stevens@discussions.microsoft.com> wrote in message
> I know how to merge two cells using formula =...Excel Edit F2 button changed for Mac???
Switched to Microsofts version of Excel for Mac. Can anyone tell me
what keystroke allows me to edit a cell? Before I switched to a Mac
it was the F2 button. Please help. Thank you.
See the answers in the m.p.mac.office.excel newsgroup.
In article <firstname.lastname@example.org>,
> Switched to Microsofts version of Excel for Mac. Can anyone tell me
> what keystroke allows me to edit a cell? Before I switched to a Mac
> it was the F2 button. Please help. Thank you.
...EXCEL TROUBLESHOOTING #2
I have an excel file (2000 format), that after I made a
number of changes is causing me problems when I re-open
the file. Windows task manager goes to 100% CPU
activity, and i cant do anything within the excel file.
However, if I set recalculation to manual before I open
the file, all seems fine.
Obvioulsy I have a problem. But how do i find that
Thanks in advance.
I have had some experience running large spreadsheets lately. Above a
certain size, the recalculation time seems to climb very fast. While Excel
is recalculating, you can't do anything anyway.
Best in my v...Excel Cells Contents to HTML Pages
I have an excel sheet which has two columns.
Column 1: PageName
Column 2: HTMLCode
PageName has information like: OurServices.htm which is the name of th
HTMLCode clumn has actual HTML Code like:
<meta http-equiv="Content-Language" content="en-us">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html
charset=windows-1252"> ...In Excel program shows a broken line and don't know how to get ri.
I am trying to put in entries in Excel program and when I go to Print
Preview, it only shows part of the entries I put in. When I go to the last
entry that it shows in Print Preview, there is a broken line between it and
the next entry. I don't know what I did. I could use some help
You probably have multiple areas selected for your print area.
you can check this by <view><page break preview>
One possibility to correct this would be
<file><print area><clear print area>
or specifically select the area you want printed and
<file ><Print area>...Multiple conditional formating for one cell
I have a workbook with several sheets. Sheet1 has several hundred rows of
text. Some of the same text will appear in multiple rows of Sheet1. On Sheet2
I have I have a cell that allows my users to free hand type in a keyword(s)
to search for in Sheet1. This cell is also has a reference name of
Now comes the question..... I like to for the user to type the keywork into
"Special_Char" and any or all the rows in Sheet1 that contain the keyword as
part of its text to turn yellow. Is there a way to do this? Please keep in
mind that the keywork i...connect a form to excel database
I have a database in excel which lists our stock and prices etc. I would like
to be able to enter a stock number on an invoice that will retrieve the
details and price from my excel database. Can this be done?
Excel has built in option--try data|form.
If that doesn't quite work, but it's close, John Walkenbach has an enhanced
And if you want to design your own, Debra Dalgleish has a get started with
> I have a database in excel which lists our stock and p...Keeping rows together after link
I have spreadsheet that has several columns that link to anothe
spreadsheet.This is G1:P100. My A,B,C,D columns is where I pu
information related to the information in G-P. For instance, G-P link
to a students information. It changes all the time. In A-D I hav
columns to input criteria for each student. The problem is that whe
the link updates the criteria and the student info end up on diffren
rows now. For instance If B1 is " Has Housing" and G1 is " Steve" afte
the update " Steve" might move to G3 and the "Has Housing" does no
move with it
Message...How do I add a value to a cell every 30 days?
I'm trying to create a calculator using Excel where in I add a given value to
a cell every month. This is not a financial equation.
assume you want to add 10 every month, starting one month from today:
=DATEDIF("2/11/2005",TODAY(),"m") * 10
or, every 30 days:
In article <BC7BB5B0-A994-4ABC-8200-8E198C51C3E1@microsoft.com>,
"ZZ430" <ZZ430@discussions.microsoft.com> wrote:
> I'm trying to create a calculator using Excel where in I add a given value to
> a cell every month. T...Does anyone know where I can download EXCEL.MSI?
I am missing my Excel 2002 CD, and can't install Office Update Service Pack 3
without this file.