| Thread | Last Post | Replies |
|
| Combo box - input Range | 17 May 2007 01:09 GMT | 12 |
I have a combobox on a work sheet. I want to set the input range depending upon an if statement... Input range =if(Width=0.7,Range1,Range2) typing this statement into the input range does not work.
|
| macro or function help needed for adding columns for values missin | 17 May 2007 00:46 GMT | 10 |
I have a sheet where the C1 has value 101 and goes to AF till 142. Its missing values in between like 112 and 117. I want to add the column for the missing value in that sheet. can someone please help. thanks.
|
| Links in Comments? | 17 May 2007 00:08 GMT | 1 |
Is it possible to insert a link in an Excel comment? End user wants and word in a comment to link to a picture on another sheet in the same workbook. Thank you for your time and assistance.
|
| Data Validation - List formatting | 17 May 2007 00:00 GMT | 3 |
The source for my list has a simple format (text alignment -> right justified). How can I keep that format active when using the data validation dropdown? Thanks,
|
| How-To fill down blank spaces in outlined table? | 16 May 2007 23:55 GMT | 2 |
I'd like to convert an outlined pivot table into a flat table. I know that once the table is copied onto a fresh spreadsheet (effectively removing the active pivot) the blank cells can be filled down preserving the hierarchical order. For example, let’s assume I have the ...
|
| Wrapped text stops wrapping after 8 lines in MS Exel. How to fix? | 16 May 2007 23:14 GMT | 3 |
How can I fix this problem?
|
| Legacy Headers and Footers | 16 May 2007 22:45 GMT | 1 |
Please make headers and footers eraseable, much like smart tags and previously used e-mail addresses are. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the
|
| how do i change author on excel spreadsheet? | 16 May 2007 22:42 GMT | 2 |
When I run my mouse over my Excel document that was initially given to me by someone, the author's name comes up and now I want to change it to mine. Thank you
|
| GRID LINES WONT PRINT | 16 May 2007 22:31 GMT | 1 |
what if my draft quality box is unclicked and my grid lines box IS checked..and it wont print...in fact it prints some and not others...i recently converted from an older excel version to 2007 and all my documents seem to be screwed up...wont print gridlines..after i had to made ...
|
| Referencing Cell Next To Today's Date Cell | 16 May 2007 22:25 GMT | 5 |
Please bear with the question: Using Excel 2002 w/SP/3 and Windows XP w/SP2. I have two columns: 1) A2...A137 are daily dates. 2) B2...B137 are cells that are filled in (one cell) each day and contain my weight. In Cell J37 I want to have the data in the cell to the right of ...
|
| "FILE" command on the tool bar is missing - how do I recover it | 16 May 2007 22:24 GMT | 3 |
The file command on the task bar of Excel 2000 is missing - how do I recover it? Thanks TW
|
| Move data to new sheet - rename sheet based on criteria ? | 16 May 2007 22:22 GMT | 7 |
Hey guys, any help is appreciated. Here is my situation: I have a spreadsheet with over 4000 rows of data. The data has the month end date in column A, but there is an arbitrary number of rows for each month end. Is there a way to move the rows of data that all have the
|
| automatic date when printing | 16 May 2007 22:18 GMT | 3 |
Is there a way to have the date appear in ANY excel or word document when printing? I don't want to add it in the header or footer of every document I print. I want this to happen automactically
|
| Making Windows XP Start 60% Faster | 16 May 2007 22:06 GMT | 1 |
Whenever you start your computer, you are faced with a few moments of thumb twiddling while Windows XP boots and prompts you to log on. Although you should expect to wait for a few moments, sometimes Windows XP seems to boot rather slowly. In fact, you may notice that
|
| excel file won't open in IE/XML page can't be opened | 16 May 2007 21:39 GMT | 1 |
I have an excel file in a restricted directory on our web and use an ASP password verification page to grant access to it (designed by a third party long gone, of course!). I try to open it using Internet Explorer 7 and get the following error message -
|