| Thread | Last Post | Replies |
|
| Worksheet won't display full screen | 24 Apr 2005 02:22 GMT | 1 |
Hello, I'm an obvious new user to Excel with a strange problem: When using Excel 2000 under Win 98 SE, I cannot get a certain Excel spreadsheet to display in full size on the screen. Excel itself is full size, but the sheet in question is smaller than full size, occupying about ...
|
| create a housekeeping check sheet on excel | 24 Apr 2005 00:55 GMT | 2 |
I want this to be like a grid on the page so it could be used as a daily checklist if need be
|
| Excel 2k | 23 Apr 2005 23:55 GMT | 3 |
My office has a 5 workstation LAN and we're sharing files in Excel 2000. I am occasionally getting this dialog when I open an Excel file: Microsoft excel cannot calculate a formula. Cell references in the formula refer to the formula's result, creating a circular reference. Try ...
|
| Function: Filename | 23 Apr 2005 22:28 GMT | 4 |
Using Excel XP: I went to INSERT>FUNCTION, clicked on CELL, click "ok" and typed the word filename in the Info_Type field. This gave me the path with the filename, but it also included the sheet name. I like to just have the Path and
|
| vbs to macro > Otto | 23 Apr 2005 22:26 GMT | 3 |
Thanks for your input. i had thought a fairly simple sub subRoutine could be crafted to increment from an excel spreadsheet (1 column list) and loop thru the process. that would NOT have completed the process but would have eliminated much of the tedium and bought me time to ...
|
| Day format in formula | 23 Apr 2005 18:50 GMT | 7 |
Can someone please tell me where I am going wrong with the formula in cell K46. I have the following in a spreadsheet :- J K L M
|
| formatting page breaks | 23 Apr 2005 16:49 GMT | 3 |
I would like to know how to format page breaks. I have an invoice template that sometime extends over multiple pages. What happens is that the table just gets cut of at the end of the page and lookslike crap. How could i make the end on one page and begin on the other?
|
| Code to Protect all Worksheets | 23 Apr 2005 16:12 GMT | 2 |
Is it possible to protect all visible and invisible worksheets with the same password with a piece of code. Thanks
|
| Automate Goal Seek? | 23 Apr 2005 14:08 GMT | 2 |
Is it possible to incorporate Goal Seek (or Solver) into a spreadsheet so it will function without manual intervention?
|
| This one worked. | 23 Apr 2005 12:40 GMT | 1 |
Or, choose Edit>Go To, click Special Select Objects, click OK Press the Delete key, to delete any objects that were selected. It was a "word art" object that was somehow stuck and squished in the
|
| Work Through a Database and Copy unique Values Q | 23 Apr 2005 11:44 GMT | 7 |
I've got the following database details in a sheet called Database3, that shows employee numbers and dates that they have clocked in Col A Col B 1 11/04/05
|
| How do i create callouts for a graph? | 23 Apr 2005 11:11 GMT | 2 |
I am new to excel and i don't know how to use callouts. I have to make some for a chart. I need help.
|
| Creating (What I Think is..) A Price List | 23 Apr 2005 10:07 GMT | 4 |
Just wondering if this is possible. I am trying to analyze a set of car data to find out the approx. retail price of a car (similar to a book value). For example, I have a list of roughly 50 cars with the year, and number of miles on each one. From this I would like to be
|
| format to see bottom of cell | 23 Apr 2005 05:10 GMT | 1 |
I want to find out if there is a way to format a cell so I can view the bottom half of the cell because there are more text then the height of the cell. I don't want to increase the height of the cell. Thanks in advance
|
| Pivot Table Calculations | 23 Apr 2005 02:44 GMT | 1 |
I have set up two pivot tables on separate tabs in a workbook. The data is monthly figures from one month to the next. Is there a way to to create a third table that would calculate the variances between items in the two separate tables?
|