Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
Excel
123quattro
charting
crashesgpfs
datamap
excel
interopoledde
links
misc
newusers
printing
programming
querydao
sdk
setup
templates
worksheet.functions
  
 
group : microsoft.public.excel      view archive
page nr.   1      2      3      4      5      6      7      8      9      10      11      12      13      14      15      16      17      18      19      20    next >>



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? ...


page nr.: page nr.   1      2      3      4      5      6      7      8      9      10      11      12      13      14      15      16      17      18      19      20    next >>
Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us