General

Close all
Is there a way in Excel 2007 to close all open files (lets say that I have 2 or more files open). In 2003, if you held down the SHIFT key while choosing FILE, you had a choice of CLOSE ALL. Maybe I am going crazy, but I don't see one Thanks Chris ... 7 Jul 2008 16:38

rename groups in Pivot table
is it possible to rename groups in a pivot table, rather than have the default group 1, group 2 ect. I am usning 2007. Thanks ... 8 Jul 2008 03:53

Close all
Is there a way in Excel 2007 to close all open files (lets say that I have 2 or more files open). In 2003, if you held down the SHIFT key while choosing FILE, you had a choice of CLOSE ALL. Maybe I am going crazy, but I don't see one Thanks Chris ... 7 Jul 2008 16:38

Convert Text To Number
I have about 15K id numbers I need to convert from text to number. All of the id numbers end with _, for example, 106102_. I need to import these id numbers into Access but I can't convert them in Access and I can't figure out how to convert them in Excel so that I may import them. Can someone help? Thanks! ... 8 Jul 2008 02:52

Print Drop Down List
How do you print the values in a drop down list? ... 7 Jul 2008 20:44

Disable conversion from text to number from .csv file
Unfortunately none of these meet my requirements: 1. I am trying to automate - naming the file to .txt means the user has to do this conversion manually. 2. Adding the single quote makes the quote visible in the spreadsheet - not acceptable. 3. Not automatic 4. Definitely not automatic. Let me restate th... 7 Jul 2008 15:36

'08-'11 Days of the Wk per Month
I have an array of date ranges from 2008-2011 and would like to calculate how many "Mondays" per month take place within this range. For example, range #1 6/29/09 - 8/16/09 consists of 7 weeks over 3 months. Is there a way I may seperate the # of weeks per month, June - 1 "Monday", July - 4 "Mondays", August - 2... 8 Jul 2008 02:52

Auto insert row while entering raw data
As I am typing data into Column A, I would like my spreadsheet to automatically add a row between the typed data and my summary two rows below (when I press Enter). As a result, I would like two blank rows always present between these pieces of information. If I cannot have this automatic, at least a maco wou... 7 Jul 2008 17:39

How do you lock formats?
I often paste data sent to me into a master spreadsheet. Many times the data I get contains cells that have formats that are different from the ones I want to use. (font, size, etc). It's not practical for me to have my users change them before they send them, and I'd like to avoid the hassle of converting th... 7 Jul 2008 16:38

Data entry problem
I am trying to enter "1 / 12" into a cell, but every time I do this the computer coverts the cell to a date and changes the values to 01-Dec. I looked through the automatic edit mode and can not find a way to change it. I need to find a way to change it so that I can put any number before or after the slash, ... 7 Jul 2008 17:39