on my last sheet there should be an overview of the data selected by the user. If the user doesn’t select all the blocks with data “because he thus not...

Excel 2003 I am pretty good at pivot table but can't figure out how the have subtotals display for my 3rd row field in under my 2nd row field - they only...

Hi Group, I have a broken link in a file. I thought I could use Go To Special to find the cell that has the broken link but I was wrong. Does anyone know a...

Hi! Is there anyway that i can print every row in my worksheet in different pages? (one row one printout/page)? I got about 200 rows which i wanted to print...

I have a workbook I use to populate certain cells below a chosen item from a data validation dropdown. It works fine until I change one of the items in the...

I have a workbook with a column like this: NAME/CLASS LASTNAME, FIRSTNAME (student's actual name goes here, all caps and BOLD) Wellness WRAP Picking Up The...

Hello, We are trying to summarize a long list of products that is Out of Stock in day-by-day format. We are using the Pivot table function and hoping it...

We have a file that we are trying to open (we have access to several versions of OFFICE,n ie 2003, 2004 mac, 97...etc). The file was created in office 97, and...

i am trying to pass a basic I.T. exam and am having trouble with the design of spreadsheets. Are there any i can veiw online or could someone E-Mail me some...

In Word2K, I can shift table rows up or down with Alt+Shift+Up/Down Arrow Is there a similar keyboard shortcut for Excel2K? -- David

How can I make this go away?

I need to hide rows depending on whats in the cells (a1,a2,a3,...) can somewane give me a example of a macro for this. thank you

I have set up a salary schedule to calculate employee/employer percentage deductions, social security contributions etc. and when adding, say the employees' ...

Hi All, Word2K, single table. My needs are simple, and I've been searching groups for days to find something I can use. We all know that Word moves empty...

I already have a button with a macro to hide the empty rows. With this same button I want to save the file automatically after the rows are hidden. The name of...

How can i keep "for exemple"; 5 rows together whin i print so that the furst 2 are not on page 1 and the last 3 on page 2. But that the 5 rows are all on...

Using XL2000: I have a single page spreadsheet (needed for SubTotal() to work), separated into 65 sheets via Page Break Preview. The top cell of each page in...

I have a need to automatically save the current date to a cell in an excel spreadsheet every time the sheet is saved. Today() always returns the current date,...

I'm trying to save a file with two cells of data to create the filename. Here is the code: Dim fname With ActiveWorkbook fname =...

I AM INSERTING AN EXCEL SPREADSHEET INTO AN AUTOCAD DWG AND THE TABLE TEXT GETS REALLY SMALL WHEN I ZOOM IN. WHEN I PRINT THE DWG THE TEXT IS SO SMALL YOU...