| Thread | Last Post | Replies |
|
| Excel Crashing with Outlook | 08 Feb 2007 04:50 GMT | 3 |
Can anyone advise me what the problem is and how to fix it with Excel. What happens is I might be working on a spreadsheet in Excel and then go to outlook to send an email and Excel then crashes causing me to lose all my work. I know one should regularly save one's work, but to ...
|
| Pivot Table - Copy All Data from a Specific Variable Data Field | 08 Feb 2007 04:36 GMT | 1 |
Hi all. I have a question that seems like it would have an easy solution, but several hours of searching through the message boards hasn't solved it yet - so here it is: I have a pivot table which is updated monthly from a database. I use
|
| Vlookup in 2 fields on another worksheet | 08 Feb 2007 04:00 GMT | 3 |
On Sheet1 I have a list of dates in column B and a list of numbers in column C. I have data in all columns up to M. In sheet2 I have todays date in A1: =today()
|
| Checkbox | 08 Feb 2007 00:19 GMT | 1 |
Is there a way to create a checkbox directly on my spreadsheet but not have the user have to use the mouse in order to check the box. I am looking for a key board shortcut or a way to assign a key so that when tabbing thru the checkboxes I can just hit a key and fill in the box
|
| Changing User Name Associated with Comments? | 08 Feb 2007 00:15 GMT | 3 |
When my comments appear, they always start with my name in bold, followed by a colon. How can I change this name to another name, or have no name at all appear in the comment balloon?
|
| Excel Banner! | 07 Feb 2007 22:29 GMT | 1 |
How can I make a banner in excel that possesses both words and a photo?
|
| Combine Cells and Retain Color Fomatting | 07 Feb 2007 21:42 GMT | 2 |
Here is the issue I am trying to figure out. *There are three cells, A2, A3, and A4 lets say. *A4 contains black text only. *A3 contains an arrow (special character) that, depending on the slope
|
| Remove unusual text/Keep text that has A-Z | 07 Feb 2007 21:39 GMT | 2 |
I download a file that contains text as you see below. I need to remove the ... The problem is that the "." is not really a "." its "..." as one. So if you replace or subsitute all "." it will not replace that. You can see what I mean if you backspace once it will delete all ...
|
| remove hyperlink from group of entries | 07 Feb 2007 20:12 GMT | 4 |
Is there a way to remove hyperlinks from a group of cells? I know you can reight click on a cell that has text that links to anotehr documents or website. But can you select an entire group of cells that are like that (that have links to other sites) and remove the the ...
|
| formulas | 07 Feb 2007 20:07 GMT | 2 |
Can someone please help me with these 2 formulas that I need to enter into my Spreadsheet?. I am trying to set up a Profit calculator for my Ebay listings. This would be appreciated thanks so much
|
| Sum at end of column question | 07 Feb 2007 19:56 GMT | 1 |
I have a delimted text file that I need to import into excel sort it by product number and total sales by product. I have to do this twice a month so I made a marco that imports the file and then using filter it filters by product number and copies the resuts to another sheet in ...
|
| Show Numeric Cell Value Instead of #### | 07 Feb 2007 19:34 GMT | 3 |
I'd like to have a narrow column of numeric data extend/flow into the adjacent right hand column, instead of showing ###. ie
|12|455| |
| Timesheet | 07 Feb 2007 19:07 GMT | 1 |
I want to make a timesheet which can calculate my income. Have found severals, but not what I'm looking for. I want to be able to input my starting, 11:55, and ending 12:00. Then I want the timesheet to calculate that I have been at work for 5 mins. Have
|
| Function to return a number of fixed length | 07 Feb 2007 18:37 GMT | 4 |
I seem to recall (or maybe dreamed of) a function that reterns a number to a fixed length. For example, if the number in question is 25 and the required length is 4, then the output of the function would be 0025.
|
| Creating random percentages totalling 100% | 07 Feb 2007 18:33 GMT | 5 |
I'm trying to simulate a variety of allocations to an investment portfolio; eg, 10% to stocks, 20% to corporate bonds, 70% to government bonds, etc. I'd like to randomly generate portfolio allocations, the problem being that they have to total 100%. Is there
|