I have read past posts on Pivot Table formatting and have achieved some
success with the formatting problem.  
My current problem is that on one spreadsheet I have used AutoFormat to get
the look I want for the Pivot Table.  On this table I expanded the width of

I have a Pivot Table in Excel 2007 with data. I have a Date column. I need
to filter the data so it shows me the data from 01-01-2008 and today date
minus 1 day. I would like to have the data filtered automatically (without
having to go everyday manually and change the filter ...

I have been tasked with putting together a pivot table for my group that will
highlight if a persons vacation falls within blackout dates. Right now I have
a list of names and a start and end date for there vacations. I also have a
list of blackout dates set up with start and end ...

Sir,
How to delete filtered Blanks Cells
Thanks
Hardeep kanwar

I have a workbook with 50 worksheets. And i want to combine 50 sheets
into one sheet
Is it possible?
If yes then how

From http://www.socialsecurity.gov/OACT/COLA/piaformula.html
There is this paragraph;
For an individual who first becomes eligible for old-age insurance
benefits or disability insurance benefits in 2008, or who dies in 2008

I have a named list that has a bunch of blank cells at the bottom so
the user can grow the list as needed.  The ignore blank check box in
data validation looks tempting, but I still get all the blank cells at
the bottom of my drop down list.  Does anyone know how to get it so

I seem to have two XLStart Directories:
C:\Program Files\Microsoft Office\OFFICE11\XLSTART
C:\Documents and Settings\GB\Application Data\Microsoft\Excel\XLSTART
Do I need both? I remember having some problems when I added some xla files

I have a workbook, with multiple sheets, each with it's own name.  Each sheet
has a cell, ie N25, which represents a count function on that sheet.  Now, I
would like to place the sum of N25 of all the sheets on a summary sheet.  Is
it possible to do this with or without using a ...

I have a table that reports results from a lookup table.
The results are in column "L"
I am wanting specifics to be highlighted.
If a cell reports "sam" or "jim" to be blue etc.

I would like to know the most frequently occurring number in a range on my
spreadsheet, but =mode(c4:u4) is invalid.  It looks like it wants
=mode({1,3,1,5,... etc.).  How can I convert my range into a form the Mode
function likes?

I have downloaded a chart for my daughters diabetes. When i view the tab bar
it shows there is only 1 "sheet". However if I scroll down the side bar it
shows there are over 200 pages to this chart, but apparently 1 sheet. It is
fine except when I forget to print just pages 1-1. ...

how do i create amortization tables in Excel 2003

I have just started using MS-Excel. I was wondering what is the maximum
number of worksheets that can be inserted in 1 MS-Excel Workbook?

how do I configure Excel 2002 to create an automatic backup copy when I
create a new file or edit an existing file.
Thanking,
Ron Patterson