Summary: Does anybody know how to permanently turn off the “auto fill options” symbol that opens up on top of an Excel worksheet when dragging cells to perform...
Summary: Sorry for being so unclear about my timesheet. I have columns: cummulated hours (+ OR - using [h]:mm;;h:mm for + or [Red][h]:mm;;h:mm) for -), day, da...
Summary: Note: the above works good if only used in one of the sheets in file. Otherwise it changes the sheet names. An alternative is to use ASAP Utilites un...
Summary: I am networked to an older machine running W95 and Office 4.3 with Excel 5.0. This machine does basic administrative work and is more than adequate fo...
Summary: Hi, I am using excel 2002 as part of office 2002. I have a formula for adding columns(vertical) of rows(horizontal). Row 1 will be totalled at the las...
Summary: hi, how do i change Excel2000 default page margin? for eg, everytime i start a new excel file, the top margin is at 0.5. dat's annoying coz everytime ...
Summary: Hi Steve. If you open Excel without selecting a file, and your PERSONAL.XLS opens up, simply select "Window->Hide" from the menu bar, and close Excel,...
Summary: Hi everyone, I didnt install the full Office XP since I dont need some component. Now whenever I open a file, either word document, excel sheet or pow...
Summary: All of the sudden i cannot open any .xls files directly from My Documents. But if i open Excel some files either will open or not (a message may appea...
Summary: When I select a list value on an Excel form combobox that I created I want to go to another worksheet. For example, list box values are country names....
Summary: OK, I have a weird problem. A couple of weeks ago, at work, I was playing with some of the configuration settings in Excel. Nothing major, on a late F...
Summary: Thanks for replying. One of the 1st things I checked was task mgr's priority settings for everythng. Still no change even when re-setting Excel's prio...
Summary: Here’s a piece of weirdness I’ve been investigating with my spreadsheet database. As you doubtless know, you can put hyperlinks to a file on your...
Summary: How can I create a print button in excel so that the user by clicking it will get the whole document printed? BUT The page must not have any backgroun...
Summary: We are GOING CRAZY! We have a column of dates in a HUGE Excel file, and when we copy of paste, paste special, values, Excel is automatically changing...
Summary: I am downloading S&P500 data from google finance in my excel, using automatic refresh, with a frequency of 1 refresh per minute. Challenge is: I wa...
Summary: when i start excel 2003 it pop up a message "cannot find C:\program files\office 2003.....\analysis\funcres.xla" . earlier i had removed the funcres.x...
Summary: I need to Sort an entire row by date automatically (close of escrow). I would like to be able to hit a button and the sheet sorts all the rows by date...
Summary: Last week while entering data into Excel, I noticed that it started making me enter the date in opposite (example, instead of entering 07 10 for July ...
Summary: I am using Excel 2007 and would like to add a button that when clicked will add a numeric value of 1 in a seperate field. The idea is if my kids are g...
Summary: Hello! I'm using Microsoft Excel 2004 for Mac. I am using it to calculate my payroll. I have a cell that I need to calculate regular pay for the we...
Summary: I have two excel work books, one has two columns. First column contains a part number and the second contain the description for the part number to t...
Summary: Hi! Excel Gurus, let say A1=2 and B1=5 then i add B1 with A1 in B1 which is = 7 i.e. B=7 (i entered this formula in B1 cell: =sum(5+A1) Now the questi...