how do i unhide a column I never hid in the first place?

I have set the Print Area in my WorkSheet to cover the area i need, but the
1st page is in LANDSCAPE and the page following is PORTRAIT.
Is there a way i can have this set to print automatically setting the 1st
page and 2nd pages to the required style?

i want to trim the values in a excel sheet as a whole

If the data is organized as follows, how do I adjust the XIRR formula (or
format of the data) to produce a CAGR ?
        2008   2009    2010
NS       100     200    350  

I am looking for a function that will look at 2 criteria and then match the 2
on the other sheet to get the margin/ price.  In B and C, I have the market
and product type.  Following those is the pricing based on different pricing
groups (which have a different percent off list ...

Does anyone know how to develop a linear predictive equation for one set of
variables based on using a different independent variabe?

I have the following function that I am using to replace letter grades with
grade points.  Excel will not allow me to enter more than seven nested
functions.  Is there another way?
=IF(D3="a","4",IF(D3="b+","3.5",

I got a sample excel worksheet from KYd
http://www.exceluser.com/dash/gauges_no.htm
and in one workbook, they use the same range name on multiple tabs, and when
I

HOW CAN I CALCULATE WORKDAYS IN EXCEL BY SETTING SATURDAY ALSO AS A WORKING
DAY ??

I have a workbook with 9 worksheets that I need to pull together for a
report.  Can I use a pivot table for this? It would need to pull from all
those sheets and I don't know what the limits are.  
Thanks,

Is there a way to change the default "summarize by" for all fields in a pivot
table?  

I have to extract the first 3-digits of a postal code, currently using:
=LEFT(A1,3)
However, this will not pull correctly if the postal code begins with 0.
Example: 04587 will pull 458 instead of 045.

Is there a formula I can use to convert text to hash marks (or XXXXXX) as
it's entered?

hi members
how can I insert rows after every fiftth row I have data of more than
6000 rows that means I want to insert 2000 rows in that sequenc
--

In the formula below the AND function cannot recognise the named range
"KolomFFundering". I need the named range because when I insert a row
the range must also change.  Is there any way to rewrite this formula
without losing it's function? The range of "KolomFFundering" is