Changing xlsx file to zip and deleting a file
Tue, 25 May 2010 05:56:27 -0700 (PDT)
I have a user who has an Excel (.xlsx) file that took about 15 seconds
to do a simple calculation. But, there are a bunch of other formulas
and conditional formatting statements in the file.
The file size was "only" 351 KB. There are only 5 worksheets, two of
which didn't appear to be used. I went through the ...
|
Stuck on If Statement
Tue, 25 May 2010 12:20:23 +0100
I am trying to do do an if statement, or look up, where in my cell I want to
check whether a certain number exists within a range of columns. If it does,
I want to show the number, and if not, it will show nothing, ie "".
So the column A:A. I want to have a formula to say:
if any value in A:A = 100, show 1 ...
|
Exclude Range from Random Name Generator
Tue, 25 May 2010 02:00:59 -0700 (PDT)
This is not work-related. I've been using Excel to draw random names
for my family's annual Christmas gift exchange for several years.
There are four families and a family cannot end up with anyone from
their own family. The best I've been able to do is 'draw' one name at
a time and assign each to a family - thr ...
|
How to make font color oppose to cell interior color
Tue, 25 May 2010 07:40:06 GMT
Hi,
When I changed the cell color to, say, red, I usually have to change
it's font color to, say, white to make it readable, otherwise a black
font on red background is very hard to see. But, for too many cells
with too many different cell colors, it can be very tedious to set font
colors for each of them.
...
|
Text vs. Number
Mon, 24 May 2010 17:54:18 -0400
Why is is that if I have a tab-deliminated file or csv file that I open in
excel the following happens:
If the field has twelve digits (a UPC code) -- say 068888701648 -- that when
it gets into the Excel spreadsheet is drops the front zero and calls it a
number.
I don't want that to happen.
Also when ...
|
XML Maps and worksheet protection problem
Tue, 25 May 2010 15:23:39 -0400
I imported an XML map (xsd) file into exel. I want users to enter data into
the worksheet for import into a database.
When you set up the worksheet, you have the field headings, which are
default formatted in blue with alternating blue/lightblue rows underneath.
Only one blank row is shown at the beginning. ...
|
Creating parameters in excel for an access-linked query
Mon, 24 May 2010 12:12:01 -0700
Hi,
I have an excel sheet that's linked to a query in an access datadase. I'm
looking to make it possible that upon opening the excel file, user's can
choose to view data by one of two parameters (the column names are product
code which isn't a visible field, and ID). Once the parameter is chosen,
subtotals ...
|
|
|
Object behind text in cells?
Mon, 24 May 2010 10:45:01 -0700
Hi,
How do you make a picture show up BEHIND the text in cells in Excel 2007? I
see a "send to back" command that works with multiple objects, but it's
grayed out if there is only one picture. I want the picture to show up
behind the words (so you can still read the words). Any ideas?
--
Thanks,
PTweet ...
|
Footer box hidden
Mon, 24 May 2010 08:52:05 -0700
Hi,
When I'm on a new wookbook (Excel 2007) I can click on menu item "insert",
then "header & footer". In the spreadsheet a white box pops up in the center
top of the page. I scroll down to the bottom of the page and there is a gray
message that says "Click to add footer". Then I can click to the left of i ...
|
Resize Cells
Mon, 24 May 2010 05:49:01 -0700
Using Excel 2007 and someone sent me a worksheet with weird size cells. I
just want to change all the cell sizes back to a normal default. (I am not an
Excel user for the most part) How do I do this? ...
|
