suggestion to add option to remove subtotals for particular fields in pivot tables. When you put more than one field in the in the "drop row fields here" in...

Hi I have a formula I use 5 times but I want to nest them into one formula but I cannot get anywhere. The formulas...

Hi I want to add page numbers to the selcted tabs and not all the tabs in a work book. Please help.

I can't figure out how to read a date in a formula. In my column I have the format set as mm/dd/yy, but the formula is looking at MMM and it is...

I have #'s in columns and need to add a prefix to each column, I have about 10k rows

I would like to add a print button/link right on my worksheet that will print some of my sheets but not all in the workbook. Any help would be appreciated.

I created 43 sets of workbooks that need to be locked and protected from end users. I have created a macro that will clear the previos days numbers and copies...

Does anyone know how to add radio buttons to a cell in excel? I am trying to add an option for a document to display the answers as either yes or no. Please...

trying to do simple total for in/out of inventory. would like to add total received vs total used, separate column for received, used. thx

I have a number of formulas used to pull data from another system into Excel. Three example formulas...

I add information every day to my spread sheet. I alway add rolls at the top to my excel spreadsheet. Is there any way to type in new rolls...

I have several worksheets dependent on each other. Can anyone help me out with a code (I'm a newbie) that will add a row with identical formats and formulas...

Dear Expert, In A1, it has a number 3. In A2, it has a number 5. In A3, it has a number 4. I want to run a marco that add 2 rows if A1 contains a number of...

Dear Expert, In A1, it has a number 3. In A2, it has a number 5. In A3, it has a number 4. I want to run a marco that add 2 rows if A1 contains a number of...

Hi guys, (Excel 2003) Problem I have is this; In a workbook called banking.xls, I have a worksheet called 2008. In the worksheet there are a number of columns...

Is there a default way to add rows to the top of the list instead of the bottom, also without the shading of cell height from the header row. Many thanks in...

HOW DO I ADD SAME CELL IN DIFFERNT TABS IN A WORKSHEET?

Hello! I have a list 9000 rows of data and am trying to figure out a way to analyze the data in a separate sheet tab by looking at the list of data at every...

I have an Excel spreadsheet that provides a date/time field in one column and a seconds field in another column. How can I combine the seconds to this...

Hello from Steved In Paradox-Kilometres worksheet I've got 2 Columns Column E I've the City ( Place ) Column D I've got the...