First | Prev | Next | Last
Pages: 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329
General number formats changing to Dates or Euros
Thanks Paul and Gary's Student. I used a combination of your ways, but found another as well. Below changes the default "Normal" Style back to General Number Format. So far this seems to work. Sub FixDefaultNumFormat() ActiveWorkbook.Styles("Normal").NumberFormat = "General" End Sub Thanks again ... 2 Feb 2010 17:28
Pivot table bottom ten filter with conditions
Hi is it possible to have the bottom ten item of a pivot table but excluding specific value(s) eg I have a pivot table with the bottom 10 of cost item 1 -200 $ item 2 -300$ item 3 -0$ .... I would like to exclude item that have a cost = 0$ and have only items greater than 0. thanks ... 5 Feb 2010 09:25
Saving as webpage, uploading via FTP
I cannot upload my spreadsheet (saved as webpage), via ftp, through Excel. I can successfully save the file on my computer, access the ftp server via Internet Explorer, and then drag the file. For some reason, when I try to use the feature in Excel, and upload the file to the same location, I get error messag... 2 Feb 2010 17:28
How to correct cannot access directory 'J:\\'.
I no longer have a flash drive that I had previously used. How can I get past this error? ... 2 Feb 2010 17:28
automatically insert autoshapes when cells are updated?
Excel 2003 Hello, I am wondering if anyone can help me with a macro (or other technique) that will automatically insert an autoshape only once a cell is populated. Also, whether the attributes of that autoshape can be determined by what is entered in other cells. I am trying to develop a visual represent... 2 Feb 2010 17:28
How do I copy formula but only increment certain ranges?
I'm having a similar problem to martc's. I'm working in Excel '07, trying to drag down an Hlookup formula. The formula I'm using is: HLOOKUP("ABCD",A$1:AB$2881,2,FALSE) Originally I had no "$", once I put them in, it locks the return row at 2 instead on icreasing 1 with each additional row. Changing manuall... 4 Feb 2010 19:08
Excel 2007 - Formatting text in cell (character by character)
In Excel 2003, one could select a cell, highlight a part of the contained text string and then right-clidk and format text. I could get underlining, bold, font, color, etc. For some reason, with Excel 2007, I can do the same, but when I hit the enter button, the formatting disappears. It reappears if I select ... 2 Feb 2010 17:28
Macro to Copy Sheets to new workbook
Found this macro by Dave Peterson and want to modify it so that I can do the following: Select the ActiveSheets and Copy them to a new workbook - BUT I do not want to copy the formulas. Only want to copy the values, formatting (row height and column width), sheet names, hyperlinks. But NOT the formulas. The ... 2 Feb 2010 17:28
Why does sheet formatting change when pasting into a new book?
When I select Move/Copy... for a sheet in Excel 2007 and select a new workbook, sometimes the formatting changes. Usually the charts will have a new color scheme, and cell colors will change to strange color schemes as well (bright red and green, anyone?). I am copying from one XLSX file to another, both file... 2 Feb 2010 17:28
In my ACCESS program, the Home, Create, External Data,.....etc tabs are all expanded. In EXCEL the tabs must be clicked each time to use the columns underneath. Is there a way to make them stay there. I can't figure it out from the help column ... 2 Feb 2010 17:28