| Thread | Last Post | Replies |
|
| printing 2 views of an excel worksheet | 28 Feb 2008 23:02 GMT | 2 |
I have a workbook with 52 pages and would like to print 2 views of each page. Seems too many for custom views, and macro has errors when I record. Any help would be appreciated
|
| Printing looks like a postage stamp | 28 Feb 2008 23:00 GMT | 1 |
I print a worksheet and it looks really small like a stamp. I am using Excel 2003 with all the updates....I have put it on another PC with the same version of Excel 2003 and it prints fine. Has anyone seen this print out really small like this it is like it is
|
| Filter seems locked | 28 Feb 2008 22:42 GMT | 2 |
I was working on a spreadsheet and had only one filter utilized. I now cannot remove it, even with going to data, filter, show all. I removed the filters and now only the filtered rows appear. How can I now "unfilter" this worksheet to again see all of my data?
|
| How to print line/row numbers as well ? | 28 Feb 2008 22:29 GMT | 4 |
I want to print an Excel sheet where the line numbers (only them ! NOT the row chars !) as well. How can I display the row/line numbers on the paper as well? Jeff
|
| Return only 1 record w/ multiple records? | 28 Feb 2008 22:22 GMT | 2 |
Here is what I am trying to achieve. For order with multiple oper, it only returns one order with the lowest oper number. What can I do to achieve this. Thanks Table with the following data:
|
| Excel 2007 | 28 Feb 2008 22:19 GMT | 4 |
I have just upgraded from 2003 excel. I have a database of names, addresses etc. in excel. I create a lot of transmittals in excel that need to be "addressed". However i cannot create a link between my excel databse and the excel file that i use to create transmittals/letters etc ...
|
| Excel 2007 Range Selection | 28 Feb 2008 22:17 GMT | 2 |
How can I setup Excel 2007 to show my columns/rows selection shade? On Excel 2003, it would automatically shade any are selected to be copied, printed etc. Can that function be replicated in the Excel 2007?
|
| Showing and hiding series in charts | 28 Feb 2008 22:14 GMT | 2 |
I have 7 data series in a column style chart. I would like to know if there is a way to toggel each individual series on or off (hide or make visable) similar to a pivot chart. I'm trying to print each series individually and it's a pain to have to go and change the properties ...
|
| Excel Cover Page | 28 Feb 2008 22:07 GMT | 3 |
I'd like to create a cover page for fairly large (1MB or higher) Excel files with multiple (30+) worksheets. Any suggestions?
|
| World Clock in Excel | 28 Feb 2008 22:03 GMT | 7 |
I would like to display pictures of real-time digital clocks in an Excel spreadsheet to show different countries with their time zones. I've seen various websites with the types of clocks I want to show, but I have no idea how to import them into Excel.
|
| Custom Lists | 28 Feb 2008 21:54 GMT | 1 |
using xl07, where are the custom lists now? used to be so easy before the ribbon!
|
| Find and Copy | 28 Feb 2008 21:54 GMT | 2 |
I have downloaded data from another program into excel and I just need a total of the employee's hours worked. Here's how the data filled in the spreadsheet: Employee # Name Day Worked Hours Worked
|
| prob with TODAY() within a macro | 28 Feb 2008 21:52 GMT | 2 |
y this today() function is giving me an error when it is run within teh macro? what should i include Sub FTPmacro() Cells(1, 10).value = TODAY() - Weekday(TODAY() + 1, 1) + 7
|
| Pivot table problem | 28 Feb 2008 21:52 GMT | 1 |
This might be a bit tricky to explain, but let me try... I have some data whereby production is captured against operators... different quantities for different operators. Now, when I pivot this information, I would like to have a scenario where the pivot shows production
|
| Display all values as x.xxx+06? | 28 Feb 2008 21:49 GMT | 1 |
I have a worksheet that is used by our group and many values are filled in that are in that range of 10e4 or 10e5. For purposes of comparison, we would like all entries to display as 10e6 in the worsheet. Is there a way to format the cells so that when we enter a number like ...
|