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



Help with Vlookup Function     Fri, 26 Feb 2010 21:19:09 -0800 (PST)
Hey there. I'm working with two sheets on a file. On the first sheet is a list of students and the schools that they attend, with the student in column A and the school in B. There are 200 rows. In sheet2, there is a list of the schools and a countif for the number of students at each. There are six student ...

summarize open issues     Fri, 26 Feb 2010 20:28:01 -0800
i have 3 different open issues lists on 3 tabs of a workbook that i want to summarize the priority items onto one list on another tab. i want to tick off items in priority order by a,b,c etc. and collect them in sorted priority order all on one tab. does anyone have any ideas how i can do this? i appreciate ...

sorting protected sheet not working     Fri, 26 Feb 2010 23:12:16 -0500
I'm getting the impression from my tests and reading various forums that this is not possible even though the protection dialog box has an option to allow sorting. I'm creating a spreadsheet on the fly from MS Access vba based on some SQL data. This is distributed to another company so they can fill in some ...

Excel page no. display OFF     Fri, 26 Feb 2010 19:00:47 -0800
>When I view my worksheet in the "Page Break Preview", I can see the Page Number shown on the worksheet as watermark. ...Is there any way I can get rid of it ...? >>In short...no That is a real, real pain. This splatch on my page consistently hides my texts & figures. It has been the single most infuriating, n ...

Excel Page display     Fri, 26 Feb 2010 18:46:34 -0800
> When I view my worksheet in the "Page Break Preview", I can see the Page Number shown on the worksheet as watermark. .. Is there any way I can get rid of it ...? >>In short...no That is a pain. A real, real pain. Why don't you just emblazon the page with a huge "Microsoft" logo? Sorry but for years of usi ...

Add and subract Time     Fri, 26 Feb 2010 15:12:02 -0500
I found a time card worksheet on-line and I don't understand the formula. It works but even when I evaluate the formula I don't understand why. D E F G Start Wrk Start Lun End Lun End Wrk 8:00 AM 11:00 AM 1:00 PM 5:00 PM The row with the times is 8. the form ...

Can't Run Macros; Blocked By Security     Fri, 26 Feb 2010 10:27:40 -0800 (PST)
My hard drive crashed, and I had to re-install Office 2007. I open Excel, and try to open .xlsm workbook I'd created previously. when it opens, I have under the ribbon: Security Warning Macros have been disabled. So I click the Options button, and I get: "Security Alert This file contains encrypted macros ...

How to make a 'comment' transparent     Fri, 26 Feb 2010 10:16:04 -0800
Any way to format 'comment' transparency (default = opaque) ? -- Thanks again for your help. akm (XPpro,SP-2,IE-7,Office2003) ...

Excel 2007 Macro shortcut key doesn't work but menu selection does     Fri, 26 Feb 2010 09:49:01 -0800
I have a very short set of Macro's one of my users has recorded. All of them worked at first but now one of them will not function via the shortcut key. It will function if you select and run it by using alt-f8, clicking on it then run. Out of curiosity I reinstalled office, same problem. Then I even gave hi ...

A single location for all my Macros     Fri, 26 Feb 2010 07:15:58 -0800 (PST)
Good morning, I'm wondering if there is a way to get all of the macros that I have scattered across a bunch of files in a single locations, like Personal.xls? Some macros are used very infrequently and if I had them all in one location, I wouldn't have to spend the day looking for them. Related to this, i ...


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