http://help.wugnet.com/office/New-Users-forum-35.html Top 15 Messages on help.wugnet.com http://help.wugnet.com/office/Strange-Excel-problem-Jump-List-ftopict1180520.html#3731153 By: Jack Wiggins - I am running Windows 7 and Office 2007. When I open an Excel file from the Jump List, none of the commands on the ribbon are clickable. It is just as though the program is frozen. I can make changes to the worksheet but I cannot save them. I can close the program by clicking the "x" in the upper right-hand corner but changes are not saved. If I open Excel first, t... http://help.wugnet.com/office/Blank-Cells-Data-ftopict1180501.html#3731089 By: T. Valko - If the "empty" cells contain unseen space characters, this macro will remove them: http://www.mvps.org/dmcritchie/excel/join.htm#trimall The macro also removes other whitespace characters so you might want to try that first on a copy of your file. -- Biff Microsoft Excel MVP "John Calder" wrote in message news:46D14F8E... http://help.wugnet.com/office/se-columns-ftopict1180493.html#3731054 By: JLatham - Either columns B through BK are hidden (most likely), or the Window is frozen and you've scrolled way over to the right, bringing column BL next to A. Assuming they're just hidden, Click on the 2 that identifies row 2 so that the entire row is selected, then On the [HOME] tab, in the CELLS group, pull down the "Format" list and choose Hide and Unhide and click the UNH... http://help.wugnet.com/office/free-download-iPod-Touch-Converter-Mac-ftopict1180453.html#3730940 By: hqconverter - iPod Touch Converter for Mac Tags: mac converter ipod touch, mac ipod touch converter, convert video to ipod touch on mac, video converter for ipod touch Mac Video Converter for iPod Touch http://www.ipodtouchconverterformac.com/images/itouch-converter-for-mac.gif iPod Touch Converter for Macconvert video to iPod Touch on Mac OS X. If you are looking for a Mac video... http://help.wugnet.com/office/auto-comlete-row-data-ftopict1180358.html#3730645 By: JBeaucaire - This sounds like a job for VLOOKUP, LOOKUP or best of all...INDEX/MATCH. Here's a sample sheet showing what I think you're looking to do: https://sites.google.com/a/madrocketscientist.com/jerrybeaucaires-excelassistant/files/IndexMatch-Simple.xls?attredirects=0&d=1 It shows examples of each of the formulas above doing this task. Does that help? -- "Actually, I *am... http://help.wugnet.com/office/work-book-Excel-07-ftopict1180303.html#3730437 By: Peo Sjoblom - That would not exclude zero from the average -- Regards, Peo Sjoblom "JBeaucaire" wrote in message news:DD6BC629-CB5F-47A5-998C-068BD1E1F5D2@microsoft.com... > Try this: > > =SUM(F10,F13,F16,F19,F22,F26,F30) / COUNTA(F10,F13,F16,F19,F22,F26,F30) > -- > "Actually, I *am* a rocket scientist." -- JB > (www.MadRocke... http://help.wugnet.com/office/Compare-Merge-Workbooks-ftopict1180296.html#3730339 By: Marsh - Try Sharing the file, and check "Can be edited by more than one user". "PA" wrote: > The Compare and Merge feature in my installation of Excel 2007 is > deactivated, for some reason, and is likewise disabled on several other > machines at our company. > How can I reactivate it, as it is desireable to compare several files. > Thank you http://help.wugnet.com/office/Publishing-pdf-ftopict1180273.html#3730247 By: Bernard Liengme - I cannot reproduce this. Want to send me a file? Get my email addy from my website. What method are you using to make the PDF? best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Machinist60" wrote in message news:hcth93$jtr$1@news.eternal-september.org... > I hav... http://help.wugnet.com/office/explanation-codes-Visual-Basic-creating-User-form-ftopict1180217.html#3730216 By: Rachel - Thanks very much Sox, I think I will invest in a good book and get studying. Cheers "Sox" wrote: > Depends on how extensive an explanation you need. A sketchy explantion of > most of the terms is available in the help files within the Visual Basic > editor. For example, looking up "Dim" will give you the syntax of Dim with > its minimum and optional parts, and a few... http://help.wugnet.com/office/copy-formula-worksheet-ftopict986412.html#3730105 By: Gord Dibben - Have you tried an Edit>Replace>Lookin>Formulas What: D68 With: D69 Secondly...............to copy formulas that reference sheets as yours do, one method is to do an Edit>Replace in source workbook. What: = Wioth: ^^^ Replace all. Copy to new workbook then reverse the edit>replace. Another methos is to copy as is then Edit>Links>Change Links to the c... http://help.wugnet.com/office/change-format-cell-ftopict1180143.html#3729754 By: Ron Rosenfeld - On Tue, 27 Oct 2009 07:13:01 -0700, Exceller wrote: >I have uploaded an excell spreadsheet and seem that all cells are text >formatted. >I can`t change to fromat of cell to number. >"Format cell" dosen`t working or change anything. Changing the format will not do that. You need to coerce these values to numbers by performing... http://help.wugnet.com/office/macro-run-faster-ftopict1180116.html#3729692 By: Dave Peterson - I don't know which would be faster--but I bet the difference is too small to notice. But there comes a time when the speed of the execution isn't as important as being able to understand and update the code. Roger wrote: > > Ok, many thanks. I guess you have also answered my other question .... what > is faster, one giant macro with five little ones subsumed ... http://help.wugnet.com/office/Analysis-Group-Excel-ftopict990230.html#3729356 By: Bruce Maclaurin - Many thanks - Luddites with no hair Bruce Maclaurin "Dave Thomas" wrote: > You select Office Button/Excel options/add-ins The at the bottom you will > see a box labeled Manage: and in the box Excel add-ins. Select go. > Then select Conditional sum wizard, Lookup wizard, Solver add-ins. And if > your add-in appears here select it too. Then press OK. It will ta... http://help.wugnet.com/office/Enforce-format-ftopict1179923.html#3729099 By: trip_to_tokyo - In EXCEL 2007:- Data / Data Tools / Data Validation / Data Validation / Settings tab / Allow: field - in here you can do what you want plus a variety of other options. If my comments have helped please hit Yes. Thanks! "Elfey1001" wrote: > How can I "enforce" a format in a cell in excel so that it allows number > entry only, i.e. it does not all... http://help.wugnet.com/office/Remove-NUM-ISERROR-array-formulas-ftopict1179924.html#3729098 By: T. Valko - You're welcome. Thanks for the feedback! -- Biff Microsoft Excel MVP "Struggling in Sheffield" wrote in message news:61359718-2F22-424A-93D1-46AD09E8D258@microsoft.com... > Hi Biff, > Thanks very much for that, tried many variations on the theme but just > couldn't hit the bullseye. > All the best. > Steve. > >... http://help.wugnet.com/office/Average-numbers-10-ftopict1179906.html#3728900 By: Ron Rosenfeld - On Sat, 10 Oct 2009 21:09:40 -0400, "Linda RQ" wrote: >Ron, > >What do the $ do/mean? Your results were the same as Daves. > >Thanks, >Linda Check HELP for "Addressing" or Absolute Address. Excel has several modes of addressing cells: Absolute, Relative, and mixed. If you drag Dave's formula to another cell, the cell referen...