Description:
Microsoft Office Excel newsgroup.
|
|
|
How to make each column of data a new worksheet?
|
| |
Hello, I was hoping somebody could help me with an Excel problem - I am not a very advanced excel user but I am hoping someone can give me some simplified advice. Basically I have got an Excel 2007 worksheet with 250 odd columns and I need to split each column of existing data onto a new worksheet. Column A is... more »
|
|
|
Add To "Find & Replace" Drop Down List
|
| |
Greetings, I am running Excel 2003 on an XP box. I have a lot of replacing to do on 60 similar workbooks. There are about 20 different combinations that I have to worry about. I have been using the "Find & Replace" under the Edit menu choice Edit>Replace. The drop down list only keeps the last 5 choices.... more »
|
|
|
Drop Down List More
|
| |
One way is to sort your validation list and at the beginning of the A's enter a single A, do the same for the beginning of the B's and all the way through to the Z's. Click in the cell that has the drop down validation and type in the letter of the list you desire... say you type in an O. DO NOT hit enter... leave... more »
|
|
|
Performing a merge in Excel 2007
|
| |
I have a file box label which someone created in Excel (why, I don't know). I now want to insert the names from the first and last files in the box onto the label. Had the label been created in Word, thi would be an easy process. Is there an easy way, or will I have to recreate the wheel (aka label).... more »
|
|
|
Would Like Pivot Table Data on 1 Row instead of Stacked Column
|
| |
In the old Excel, when I created a Pivot table, I could select a report template where the data would line up in columns instead of being stacked in the same column. I have selected Modular, Table, Outline and looked at different formats but can not find a fix. I am trying to get the data output... more »
|
|
|
pivot table group by date question
|
| |
I love the group by date function...I rely on it! but i often find it is greyed-out and not avialable to use for a variable, despite it being date data. Any tips on ensuring how to get this work?. I understand it might be a problem with files that started life at 2003 files, even if saved as 2007 files? cheers Theo... more »
|
|
|
shape doesn't scale to fit when printed
|
| |
In Print Preview / Page Setup, I set to fit in 1 page wide by 1 page tall. The worksheet is scaled correctly but the shapes did not scale down. I have set the print area to include everything. I have also set the shapes to move and size with the cells. Anything else I should look at? Any help would be appreciated.... more »
|
|
|
keeping subtotals accurate to reflect sorting...
|
| |
Hi, not sure how to present my question briefly.... I've created an inventory sheet for our restaurants with the following columns: category, description, vendor, item #, price, etc etc etc. At the bottom of the 250 some odd line items I have everything subtotaled by category (all beverages, dairy, spices, produce, etc)... more »
|
|
|
|
