Hello. I have created a custom theme in Excel 2007 so that I could have colors that appear more like the old Excel color theme. Two of my selected colors...

Is there a way to automatically sort a series of data? For instance, cells A1:A144 have a numeric value. In Column B1:B144, I'd like to sort those numeric...

I'm having difficulties saving a file to a certain location. My code is. Sub closeappandsave() Application.ScreenUpdating = False servpath = "c:\my...

I need to have symbols change colors as a result of a cell. Just like the conditional formating in 2007. I believe VBA may be the only way to go. Not very...

I am looking for a formula that gives me a figure when a total exceeds a certain figure. what formula for " If (cell) exceeds 37 then (this cell) = ?

I have created a .csv file by exporting only last name and email address from my OE6 address book. In more than half of the resultant spreadsheet rows,...

I created a spreadsheet, last year, and password protected certain cells. I cannot find the password to edit the locked cells. How do I find the password...

The cell format is set to Number, Date, 14-Mar-01. I enter the date, and when I press Enter, the date converts to 0-Jan-00. Any thoughts? Thank you.

I have an issue when I open excel sometimes the date moves from dd/mm/yyyy to mm/dd/yyyy but according to the cell format it's still in the format...

Got the dynamic chart titles and the dynamic auto shapes to work. NOW is there any easy way to make the comment box dynamic. User can click on that cell...

I have an Excel document with date formulas to keep it up-to-date. I wish to print its only worksheet automatically once a week. How can I specify the...

I was trying to open my spread sheet and the screen went blue. I have tried to open different spread sheets - the same thing - I tried to restart the...

I have a 3500+ row spreadsheet that contains trade show attendee data. One column represents the 'interests' of the attendee. They made selections from 21...

Currently I am running Excel 2002. I am aware of the 65535 row limit in this version. Excel 2007 is stated...

I have a ten-page report and do not want "page 1" to print at the bottom of page 1. I want the page numbering to begin on page two. How do you suppress page...

How can I conditional format for the whole row? In a list if column C shows "new" for a new client, how can I ensure that the whole row is automatically...

After following directions to search for excel addins: Office button Excel options Add ins Manage: excel add ins Available add ins Browse; I still...

Hi, I have a list of numbers example, In a2 1 2 1 3 3 4

I want to randomise the 157 entries in randomised complete block design using MS Excel

hi all I have a series of numbers in column A2-A4240 and I need every second cell to appear in another table but I need it linked so that when the originals...