Clip art in Excel 2007
I have two clip arts in my Excel 2007 one is check mark and the another is
a "X" in a particular cell I would display the text "Balance", which I
like to have the check mark clip art appear. If the same cell has the text
"Not Balance" then I want to show the clip art with the "X" and the clip art
with the check mark disappear. Is this possible? I would appreciate any
tips. Thank you in advance.
If you want check to appear when text in cell a1=balance and x when text
reads no balance try this in B1
=IF(A1="balance...excel 2007 schemas
PLEASE HELP :( i am trying to link a pdf file to excel thru a schema i think
what i am missing to get the correct mapping is locking or labeling the
column headings anyone out there who can help will earn major karma points
...Assign Macro to button in Excel doesnt work Any ideas?
I have followed the instructions in help but when I get to step 3 "right
click to bring up shortcut menu & enter Assign Macro" the assign macro"
option does not appear!! Any Ideas
can you see assign macro - but it is greyed out? or is it not an option at
if it is greyed out you'll notice around the button little diagonal lines,
click on these and they should go furryish .. now try right mouse clicking.
if the option is not there at all, please post back letting us know how you
created the button.
"Mike@Becketts" <Mike@B...Arrow Keys in Excel #3
While typeing in Excel, my arrow keys suddenly changed from moving from "cell
to cell" to scrolling the screen. I cannot figure out how to change the keys
back so that they move from "cell to cell."
Hit the scroll lock key.
Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
"Claude" <Claude@discussions.microsoft.com> wrote in message
> While typeing in Excel, my arrow...Row heights Changed by Sorting
I have an excel spreadsheet of 279 rows: a 4-row header
and 25 sets of 11 rows each. Row heights within each set
have been set individually, though the pattern is common
to each set.
When the 275 non-header rows are sorted as a group, the
row heights of most, but not all, of the final 2 rows of
each set are changed. The heights of the first 9 rows of
each set are not changed.
The final row of each set is empty except for one cell.
The cell in the selected sort column is empty. The one
non-empty cell contains numeric data in another sort key
column. Row 11 formatting consi...Using a two-dimensional array in Excel 2002 or 2003
I am trying to improve my coding skills in Excel VBA and I just can't seem to
find a good, very basic, example of how to use a 2-dimensional array. I've
looked in several reference books & browsed VBA Forums but can't find an
example I can understand. What I was trying to do was define a 3 x 4 Array
that has a data type of Single. My sample data is located in Cells E1:H3.
E F G H
1 3.4 8.1 11.6 100.3
2 5.2 7.3 45.2 632.4
3 1.7 9.6 39.7 161.5
I've been trying to use the LBound and UBound functions too, thinkin...Excel Macros #4
I am running Excel 2003 and when I start one of my worksheets I get a
message about the worksheet having macros. When I go to Tools Macros
there are none listed.
I did attempt to create a macro years ago, under Excel 97 but I could
never find it or use it.
How can I get rid of any macro remnent when it does not show in the
list of macros. The security message is a pain in the neck when I know
that there is no macro in existance
Thanks of any help
When you record a macro, Excel creates a module in which the code is
stored. When you delete the macro, the module is not automatically
de...import fixed-length text file into excel
- 2 2299 Del Pietro M Wintervill NC 1:18:26 2:44:0
- 1 2045 Robert Marchinko M Salisbury NC 1:15:34 2:31:1
I have a text file where each field starts at same column and of th
same length in each record.
I tried cut&Paste,
I tried opening it in excel as a tab delimited file
I tried as a fixed-length file
None of these worked. Data came in scrambled or into scrunched columns
If the data were a table then cut&paste works great.
What's the secret in loading above 2 records into Excel? I couldn'
simulate the look ...Why with Excel Xp takes too much time to open and in 2003 fast?
I have 2 computers, in one I have Excel XP (2002) and in the other I have
Excel 2003, I've been receiving files wich I need to check with my Excel XP,
the problem is that it takes too much time to open, and when I try to open it
with Excel 2003 it open normaly (fast).
What can I do?
Urgent, please I will thank you to send answer : email@example.com
Tengo 2 computadoras, una con Excel Xp (2002) y la otra con 2003, he
recibido archivos pero con Excel XP tarda mucho tiempo en abrir los archivos,
mientras que en 2003 lo hace normal (rapido), a ...Excel 2003 #21
When doing “Local Save As”, under Tools on the Save As dialog, there should
be “Save Options” but this is not on menu?? Has this been disabled in office
There is no Local Save As for Excel--any version. You are likely using some
kind of Document Management Software. If you upgraded Excel, you may have to
upgrad the other program as well.
> When doing “Local Save As”, under Tools on the Save As dialog, there should
> be “Save Options” but this is not on menu?? Has this been disabled in office
File>Save As>Tools>Genera...Currency Issue in GP10
Whenever I set a currency id (Z-US$) into iv00105, it created a extra item
when I open item maintenance.
itemnmbr curncyid currnidx decplcur listprice dex_row_id
ItemA 0 6 .00000 29178
ItemA Z-US$ 1007 5 .00000 29177
The reason I have to set currency id. I always get error when PO import from
"Unit Cost Calculation does not match out to Extended Cost "
"CURNCYID does not match CURNCYID on the Purchase Order"
To Fix the "Unit Cost Calculation does not match out...2005 Upgrade from 2004 Issues
I am a long time user of Money. I was using 2004 and upgraded to 2005. I
have run into several issues. Some I could fix and some I am still trying to
deal with. I still have time to go back and reload 2004 and not lose too
Here were my issues.
-For some reason, several of the begining balances did not come over. This
caused my account balances to be off. (I fixed these)
-The bills and Deposits is 5 times longer with many repeats for some strange
reason. It will not even let me edit them. (Might have to delete all and
-My 401k account and another investment accou...How do I hide formulas in Excel cells?
I have a worksheet with lots of different formulas. I need to have the
complete sheet show the formulas and not the results. I did this before a
few years ago but don't remember how. I am working on Excel 2000. Any help
would be greatly appreciated.
TOOLS / OPTIONS / FORMULAS
> I have a worksheet with lots of different formulas. I need to have the
> complete sheet show the formulas and not the results. I did this before a
> few years ago but don't remember how. I am working on Excel 2000. Any help
> would be gr...Excel Window Menu
I am using Excel 2000 and I am working with over 20 excel files at the
same time. The window menu shows only the first 9 files and I want to
know if it is possible to see all open workbooks in the window menu
without clicking the "More Windows" button?
Any help will be greatly appreciated.
Hi Oguz. If you are using Windows XP as your operating
system, you could right click on your XP toolbar and
select properties, then check the 'Group similar taskbar
buttons'. I just opened 24 files and it showed them all
when clicking on the minimised toolbar button.
R...Excel and ebay lists
Has anyone found a way to put the contents of ebay files, including
pictures, into an excel database? I am trying to keep track of prices
for items sold.
...Excel Link to another Excel file and formulas
I have a formula that I want to "fill" down through my spreadsheet
When I fill the formula down it does not change the reference.
Everything remains as referencing $B$5
How can I get around this issue?
The problem is that your use of an absolute reference is holding the cell
reference constant. Try changing the $B$5 to:
$B5 if you want to keep the column set as B as you...Excel #158
I recently completed testing at a temp office and on the test I was asked to
perform a Pack and Go Wizard in Excel. What is a Pack and Go Wizard?
There is a Pack and Go Wizard in PowerPoint, which allows you to package the
PowerPoint presentation onto a disk or CD to be shown on another PC. That
other PC does not necessarily need PowerPoint installed.
Could that be what you tested on?
> I recently completed testing at a temp office and on the test I was asked to
> perform a Pack and Go Wizard in Excel. What is a Pack and Go Wizard?
...Excel spread sheet #2
Every time I open ANY excel document on this CP it displays each individual
cell as a page.......how do I change this setting? Moving each page break
takes too long abd does not alway work.
try this macro to remove them all at once:
"dlam25mmm" <firstname.lastname@example.org> schrieb im
> Every time I open ANY excel document on this CP it displays each
> cell as a page.......how d...Excel says: "links cannot be updated"
I have two linked files. One references cells from the other.
When opening the file with the references in it while the other file is
closed Excel gives the error message "This workbook contains one or more
links that cannot be updated". However, there's a button "Edit links..."
that shows no problems with the linked file. It's status is "OK". All of the
links are indeed updated, so the error message seems wrong. Anyone seen this
The two files are normal Excel-files (version 2003), the "update remote
references"-option is checked an...PDF Format for Excel
Can Excel spreadsheets be save in PDF format?
Excel can't save files directly to PDF files. You need a third
party product like Adobe's Acrobat (full version, not just the
free Reader), or something like PDF995 (www.pdf995.com) .
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Thom" <email@example.com> wrote in message
> Can Excel spreadsheets be save in PDF format?
Yes, but you need a program capable of doing so...
A popular one is Adobe Acrob...Chart disappears in Excel 2000 after scale is changed
When the scale of the chart is changed, the chart disappears. The chart
and its data are on the same worksheet.
...Why doesn't the tools/options work in Excel?
About a month ago I was not able to get to the "Options" screen under tools.
I still can't even after reloading and repairing Office. I can get to the
"options" under Word but not Excel. I am using Office 2003.
Help me get it so that I can get to Tools/Options.
Is it gone or what happens when you try to open options?
If it's gone, do view>toolbars>customize. select commands, scroll to toolbar
and select in the left pane, in the right pane scroll to options (at end)
then drag it to its place. You could try to rename *xlb to something like
res...Excel XP 2002 compatibility with older versions (macros)
I have developed a spreadsheet that has macros in it. I
have sent it out to be used by others, but an error
message pops up when those with older versions of Excel
try to use the macro. Is there something I can do to
make this macro work for those with older versions of
That depends entirely on exactly WHAT the error message is.
If you are using VBA functions that correspond to features not available in
the older version(s) of Excel, then you'll have to remove that code.
Potentially you can alter it to do it the "old" way so that it works, or you
can perform a tes...How do I format text as a bulleted item in Excel? Is it possible?
It's a manual effort.
You can use Insert|Symbol (if you're using xl2002+) or copy the bullet you want
from CharMap. (Windows start button|charmap).
You'll have to select that character in the formulabar and change the font to
what you want.
Chip Pearson has an addin that may help (if you're using xl2k or lower).
(look for Symbolizer and make sure you get the correct version)
Dave Peterson <petersod@verizonXSPAM.net> wrote in
http://...pivot table issue -- putting data of the same code on diff lines
i have an issue with excel that is very hurtfu
i'll put together a table with say the first column having a range of dates or perhaps keyword
second column would have product codes (often repeating product codes referring to a different column one date or keyword
third column would have numbers as in number of cases sol
then i'll make a pivot tabl
and items that have different column a values but like column b values appear on different row
THIS DRIVES ME INSANE PLEASE HELP ME