http://help.wugnet.com/office/General-Discussions-forum-27.html Top 15 Messages on help.wugnet.com http://help.wugnet.com/office/excel-spreadsheet-2003-wont-show-content-moved-par-ftopict1180514.html#3731136 By: Paul C - I had a similar issue with some files. What happened was that somehow the windows for the files got minimized or dragged out of view somehow (not sure how this happened). Users would open a file and see nothing. This fixed it for me. Goto the Window item on toolbar, Select Arrange and then select tiled. If your file window somehow got moved to a non visible posit... http://help.wugnet.com/office/Password-Protect-columns-passwords-ftopict1112966.html#3731117 By: Gord Dibben - Thanks for jumping in MRT You beat me to it. Gord On Fri, 20 Nov 2009 22:10:40 +0800, "MRT" wrote: >Columns (C) -> Columns ("C") or Columns (3) >Columns (D) -> Columns ("D") or Columns (4) > >HTH http://help.wugnet.com/office/Automatic-update-data-excel-charts-ftopict1180444.html#3731099 By: shantz - I am still working for a living :) "Gord Dibben" wrote: > Good to hear. > > Thanks for the feedback and thanks to Stephen. > > He saved my butt with this many years ago when I was still working for a > living. > > > Gord > > On Tue, 17 Nov 2009 18:28:02 -0800, shantz > wrote: > > >Thanks Gord - the link clearly explains ho... http://help.wugnet.com/office/Comparison-popular-Blu-ray-rippers-ftopict1180499.html#3731080 By: flssm2008 - Blu-ray as a new disc format has greater storage capacity, faster reading and writing speed, and more safe data storage function. It becomes more and more popular in nowadays. However, there are so many Blu-ray products, then how to choose the right Blu-ray Ripper? In order to solve this problem, I chose three best-selling Blu-ray Rippers to make a comparative analysis on its pr... http://help.wugnet.com/office/Save-DBF-ftopict1103429.html#3731073 By: Gyula - Dear Fellow DBF Users, The latest upgrade of the SaveDBF Excel 2007 add-in (used to be called XLSX2DBF) can be tried at thexlwiz.blogspot.com. The changes include fixes related to minor bugs in Microsoft's OLEDB engine and some improved field type identification for users who start out with an Excel file. Future plans: I plan one more upgrade in Jan/Feb 2010. This ... http://help.wugnet.com/office/Analyzing-Bank-Statements-Pivot-Tables-ftopict1180487.html#3731061 By: Fred Smith - Change the function from Count to Sum. Right-Click on the column of numbers, and it will give you an option to change. The specific instructions will depend on what version of Excel you are using. Regards, Fred. "Sleuth" wrote in message news:D9698421-2217-4426-A54E-85D3D7F8F0AF@microsoft.com... >I would like to perform analysis ... http://help.wugnet.com/office/loop-ftopict1180471.html#3731052 By: april - Thank you for the answers. i am going to try your solutions. however, there must be something wrong with my email since i wasn't notified that someone had sent me a solution - i am almost positive that i checked the box "notify me of replies." anyway i was looking for my post to say that i had found a solution when i found all the replies. the great thing about Excel ... http://help.wugnet.com/office/Auto-sort-save-sort-ftopict924630.html#3731029 By: Ed from SC - So far, my impression of Office 2007 and it's "New" threads is that is really "sucks". The idea that we would have to write a MACRO to do something that an earlier version did automatically is ludacrous. I've been doing this for 25 years and early on programs gave you the option to set program preferences. Dave Peterson talks about not wanting things too automatic. ... http://help.wugnet.com/office/list-return-multiple-ftopict1180477.html#3731005 By: T. Valko - How about giving us some details? -- Biff Microsoft Excel MVP "123456789" wrote in message news:87EB96E3-434E-4616-8DB0-0C926AE5E4E8@microsoft.com... >I followed the instructions on the excel help page of how look up a value >in > a list and return multiple corresponding values but somethings not right. > I > have tried th... http://help.wugnet.com/office/Excel-2007-filename-Group-ftopict1180473.html#3730997 By: Peo Sjoblom - You had at least 2 sheets selected (grouped) when you saved the workbook, right click the sheet tab and select ungroup sheets and then save the workbook -- Regards, Peo Sjoblom "hkbarnett" wrote in message news:BA4D0705-6F6C-4589-B98E-5FD5695AF042@microsoft.com... > Many of the functions on the ribbon are inacce... http://help.wugnet.com/office/text-cut-printed-due-row-ht-ftopict1180470.html#3730982 By: Squeaky - You can set the cell properties to "shrink to fit" (right click on cell(s) select format cells>Alignment tab click Shrink to fit box), other wise you will need to manually adjust them to display correctly. What you see and how it prints is very often different. Squeaky "bkikoen" wrote: > In my spreadsheet the row heights are varied and look the right way, when I >... http://help.wugnet.com/office/format-time-ftopict1180463.html#3730979 By: Pete_UK - You're welcome, Victor - thanks for feeding back. Pete On Nov 18, 1:39pm, VICTOR wrote: > > Thanks to all of you, it has finally worked http://help.wugnet.com/office/E2007-Macro-splitting-text-replacing-ftopict1180394.html#3730952 By: Niniel - Thank you, that was helpful - in a bit of a round-about way: Since I could quite figure out how to apply your recommended fix, I re-recorded the macro with Relative References on, and now it's working. Strangely, however, I had to change the first offset from (0, 3) to (0, 0), funny that the recorder would get that wrong (bug?). Anyway, this is how it looks now: Ac... http://help.wugnet.com/office/free-download-iPod-Touch-Converter-Mac-ftopict1180454.html#3730941 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/Excel-2003-chart-plots-wierd-Excel-2007-time-axis-ftopict1180446.html#3730925 By: Tony Ozzello - Hey all, just upgraded. I have a chart with multiple time value series going out many years, some of the series have data going into the future a while and some only to the current date. I plot the data up to the current date to look at performance against target. With the recent upgrade to 2007, the entire series plots on the x-axis even if I select a subset for the ... http://help.wugnet.com/office/Hidding-rows-colums-ftopict1180439.html#3730900 By: Peo Sjoblom - If you mean that if your working area is let's say A1:H50 then yes you can hide I1:IV65535 and A50:H65535 (using Excel 97-2003 specs). Have you tried it? -- Regards, Peo Sjoblom "msao" wrote in message news:09AD3EB2-B969-4E80-847F-8898B622A540@microsoft.com... > Is it possable to hide all the cells out side of the part ...