how do i do adding and subtracting on excel
Angela, may need more information on what you want to do, but
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 2002 & 2003
"angela" <firstname.lastname@example.org> wrote in message
This is using a simple formula entered in cell A6
so now cell A6 will display the addition of A3 A4 and A5
similarly you could have a cell with the...Excel Not Responding #2
Windows 2000 Professional running Office XP. When opening
a file over the network from Windows 2000 Server, it takes
a long time and in the task manager it shows "not
responding" Then suddenly it opens. When copying the file
locally, it opens immediately. The environment is 10/100
Switched network. This is happening on machines with 100Mb
network cards and the server has a 100Mb card as well. Any
ideas would be appreciated.....
...Excel chart size
I am trying to create a standard Excel chart size so that I can copy the
charts into Powerpoint. I have tried to put each chart on its own chart
sheet. However, it seems that the size of the chart varies depending on
which computer is used. Is there a way to create a custom sized chart sheet?
Is there another way to create a standard sized graph in Excel that can be
copied into Powerpoint? I would prefer to use chart sheets since they seem
support linked Excel charts better.
Any suggestions would be appreciated.
I am not aware of this problem, and it may have to do with the zoomin...Can I project an Excel spreadsheet without the menu bar?
Is there any way to "auto-hide" the worksheet menu bar in Excel the way we
can "auto-hide" the taskbar? I want to project an Excel spreadsheet onto a
screen but do not want the worksheet menu bar to be visible.
Thank you to anyone who can help.
Go to the View menu, choose Toolbars, scroll down to Worksheet
Menu Bar, and uncheck it. Or, with VBA,
Application.CommandBars("Worksheet Menu Bar").Enabled = False
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"DEN-RIK" <DEN-RIK@discussions.micros...Importing excel contacts into Outlook
Getting ODBC Excel Driver Login Failed message saying 'Could not find
installable ISAM' when I try to import an excel worksheet with contact
details. I have run Microsoft Office Diagnostics and that hasn't helped.
In windows/system32 have file msexcl40.dll and C:\Program Files\Common
Files\Microsoft Shared\OFFICE12\ACEEXCL.DLL exists.
...How do I delete checkboxes from rows I deleted in a macro?
I programmatically delete a named range which contains checkboxes, but after
the rows have been deleted the checkboxes overlay each other and appear in a
blank line. Is there any way to delete the checkboxes as well as the content
of the cells/rows?
Maybe you could do something like:
Dim myShape As Shape
Dim myRng As Range
Dim wks As Worksheet
Set wks = Worksheets("Sheet1")
Set myRng = .Range("g8:k20") 'whatever
For Each myShape In .Shapes
If Intersect(myShape.TopLeft...Is it possible to automatically move data entered in columns into rows?
Is it possible to automatically move data entered in columns into rows?
It seems like a simple thing to do but I can't find a function anywhere.
If you enter something in ONE cell it is automatically in a row and a
column. So, perhaps a bit more explanation is in order.
"Richard Thorneycroft" <email@example.com> wrote in message
> Is it possible to automatically move data entered in columns into rows?
>...Transferring a two column excel file into outlook
Is there a simple way to transfer an excel file which has two
columns ,one for names the other for phone numbers, into my outlook
address book? I have a excel file with over a hundred such entries
and would rather not enter them individually, surly there is a simple
way to do this. Any suggestions?
Condo <theCONDOmanager@gmail.com> wrote:
> Is there a simple way to transfer an excel file which has two
> columns ,one for names the other for phone numbers, into my outlook
> address book? I have a excel file with over a hundred such entries
> and would rather not enter them in...'save as' Excel attachment
When I try to do a 'save as' an Excel file that I received as
attachment, the default save folder is an temporary internet folder.
How can I change the default 'save as' folder?
~~ Message posted from http://www.OutlookForum.com/
~~ View and post usenet messages directly from http://www.OutlookForum.com/
...Unable to close excel as a group from the task bar
I have noticed (ok actually a user logged it) that when you have multiple
worksheets open in excel (and they are grouped on the windows taskbar) you
cant close minimise the group, in fact all the options in the right click
menu are greyed out.
I've had a look on the web and kind fine a few instances of people asking
this question but no one seems to have an answer.
( i know i can untick windows in taskbar and just have one instance of excel
but im curious why close group doesnt work)
thanks in advance
>>but im curious why close group doesnt work
There are lots of que...sum to recognize new rows
I have a column that I average the sum (ignoring blank cells in the formula)
sum of column, divided by count of cells that are not blank.
here is the formula that is in B10...
When I insert a row above B10 the formula does not change to incorporate
that additional row. How can I get the formula to recognize new rows?
should now be
you could copy row 10 and paste to row 11, and then type your new values over
those in row 10
> I have a column that I average the sum (ig...Copy Rows if Lookup Criteria Match
I am trying to create sometype of template to pull data associated with a
specific office. I have a drop down list create on WorksheetB. I have
another WorksheetA that contains a list of equipment (Office, Equipment,
Lease End Date, Cost, etc..).
I would like to be able to select the Office from the drop down list on
WorksheetB and pull all of the rows that are associated with the Office in
WorksheetA back over to Worksheet B. I know that I can do this using Access
Queries, but is there a way to do this in Excel? If so, what are your
...selecting multiple objects in Excel 2007
I have been using Excel 2003 until recently and have recently had to try
I have a worksheet with a chart on it and some labels. These labels contain
text referring to the chart and are changed by macros.
I have to sent this chart in a report and I do this by holding down shift
and clicking the chart and the labels to select them all before copying it as
a metafile into Word.
This process works fine in Excel 2003, but I've found that I'm unable to
select both the chart and the labels in Excel 2007 - When I click on the
chart the labels are deselected and vi...Excel 2003 (XP), automatic save documents
With the previous excel versions document one could have the file saved
automatically every Minute if need be. Where is this function in Excel 2003??
If by error (and it happens too often) one closes a document without having
saved it manually first, the entire 2 - 3 hour job could be lost, and there
is no autorecovery file to be found either.
Can anyone indicate me, if possible with print screens how this precious
feature can be activated in Excel 2003?
Many thanks, and have a good day
That feature's not available in XL03. However, Jan Karel Pieterse has an
add-in a...routing slip in Excel 2007
is there any work around?
Thanks in advance
I noticed that you have posted this question at least twice. If you have
yet to receive a response, it's likely that newsgroup users are unclear as to
what you are looking to do. Can you be more explanatory in what you are
trying to accomplish? Simply asking "is there any work around to the routing
slip in Excel 2007" doesn't say much. I don't even know what you are
referring to when you say "routing slip in Excel 2007."
> is the...Downloaded files not opening in Mac Excel 2008 (MIME/XML)
I'm trying to open a downloaded file in Mac Excel 2008. The file is
being downloaded from a web-app using Firefox 3.5.6. When I do so I
get the following in the excel grid:
From: Financial Reporting Export
Date: Wed, 15 Sep 2004 14:21:07 -0400
X-MimeOLE: Produced By Financial Reporting
This is a multi-part message in MIME format.
charset="utf-8"...Can I increase the view of a drop down list beyond 8 in Excel?
I created a drop down list from a group of more than 8 items (12 items).
When the drop down list arrow is clicked, Excel shows the first eight than
has the block on the right hand side to scroll down the list. I would like
to see every item in the group at the same time. Is there a way to make my
view longer to include all 12 items?
Not if you used data|validation.
> I created a drop down list from a group of more than 8 items (12 items).
> When the drop down list arrow is clicked, Excel shows the first eight than
> has the block on the...Cannot insert any chart in Excel 2007
Currently, I cannot insert any chart in Excel 2007 at my home PC using
Windows XP. Even after I highlighted the data table and clicked Insert a line
chart, there was nothing on display. However, when I used my laptop with
Windows Vista to insert a line chart, it was successful.
Does any expert know what is the cause and how to resolve this problem? I
have uninstalled and reinstalled Microsoft Office Home package, but the
problem still remained. It seems that chart function cannot work.
...Series equivalent in Excel 2000
Using Series in a chart it's easy to use a dynamic range of data
within a chart. Unfortunately I'm using Excel 2000 so the series
function isn't available.
When I enter the range name Excel converts it to the real cell range.
The range name is defined as:
(translated from dutch excel version)
Is it possible to update the chart range automatically, maybe using
the named range?
Thanks for your effort.
Kind regards, Gert
In any version of Excel (97 through 2003) this is the behavior: you can
enter a range name into the data range bo...Automatically adding additional rows
I am need of help on this as I have no idea if this is even possible in Excel
I am currently designing a spreadhseet that will be used to order supplies
on a weekly basis. Sheet 1 is the order form while Sheet 2 has all the
product info. While Sheet 1 has no problem pulling the info from Sheet 2
(via VLOOKUP), the approval person is making this request
"Can you get it to automatically add another empty line at the bottom every
time a line has info entered on it? Will the new rows contain the formulas
from the previous rows?"
I know I can make a large she...Excel check mark box
Is there a way to create a check mark box or some other
way to select what records get printed from into a
mailmerge document from excel. I would like to select
them on the spreadsheet and not in the mailmerge wizard.
I believe this can be done in a works spreadsheet, but
can it be done in excel?
In MSWord2002, I can "filter" on a column (select records based on a field's
So maybe you could use a helper column with an indicator in it.
> Is there a way to create a check mark box or some other
> way to select what records get printed from int...Calculating Clock start time in Excel
I am trying to calculate when an inquiry comes in to our helpdesk
outside working hours and when it was answered based on the follwing
Working hours are 08:00 - 17:00 Monday to Friday.
If inquiry comes after 17:00, then the inquiry is attended the next
working day and an answer is guaranteed by the close of following
working day. If the inquiry comes during working hours, again the
garantee is for the answer by close of next working day.
I need to be able to measure how long an inquiry has missed the
promised deadline by.
Can anyone help please?
-...Excel copy + paste
When I open up a new Excel workbook and try to paste cells from another
workbook it is pasting the cells as a ( bmp ) It actually pastes the cells
a picture and the picture tool opens. I can paste cells fine within the same
workbook but once I open another workbook and try to paste into it this
You are opening the second workbook in its own instance of Excel so you have
two instances running.
They do not see each other so you get the behaviour you describe.
Close one instance and workbook then open workbook again in the other single
To p...Outlook 2003 blocking Word, Excel attachments
Have been thru all the help and online help which
specifically says it does NOT block MS products, but mine
does. When you try to open an attachment it says it is
blocked for security and only allows you to save it.
Everyone in my dept. has installed it from the same
install, and I am the only one. I have tried repair and
reinstalling from same with no change. Any ideas?
...easiest way to parse column and row info?
I'm trying to set up a macro to function on a user-selected range (rather
than hardcoding row/column references, or having a bunch of inputboxes to
collect the reference info)
Getting the range is easy;
Dim TempRange as Range
Set TempRange = Selection
debug.print TempRange.Address(False, False)
which gives me (in my test scenario): B6:AD1463
My macro will need to process each column independently, and for each
column, I will loop through each row and perform some actions.
I can use left/right/mid to pull apart B6:D14 into the component pieces
(B..AD and 6..1463) bu...