Excel 2007
I have a count field in a pivot table column that I want to display as a
percentage.
If I  have no subtotals, the option "% of column" in Value Field settings  

Can the left - center - right sections be removed to make just one area
right across the page ?
sidcliffe

Last ? for today, I promise.
I have a picture in cell A1 and I want the focus to be on the picture, not
the cell it occupies when the workbook opens.  Is this possible?
-S

I have a pivot table and after some manipulation it is giving me what
I desire. One question: is it possible to get rid of all the titles
that start with "Sum of" and replace it with something else? Thank you.

Window XP Sp2 - MS Ofc 2000 / Excel
I created a list in Excel by doing a copy/past from a web site.
(List of name, address, phone, website)  I did a save when done
and then tried to disable all the hyperlinks on the page.  Followed

I've had several users encounter the same errors when having Excel 2007 open
for an hour or two.  They get errors such as 'not enough system resources to
display completely' or 'excel cannot complete this task with available
resources.  Choose less data or close other'.  Also, ...

I have joined in an organisation where there are lots of macros already
written and need to understand and create new ones.  can anybody tell me the
ways to get improve in this area.  
Any websites info please.

How can I password protect a hidden sheet so that you can only 'unhide' it
with a password? I'm using Excel 2003.

I am trying to figure out how to show how much longer someone will have to
send a product back if they only have 30 days to return it. I would like the
cell to count down from 30-1 and show colors at different stages. Is this
possible or am I asking too much?

My boss wants me to give him weekly statistics of project works coming in and
ones which works which has been completed for each week of the month. is
there a formula for this?  

Is there a way to force a worksheet to always open in cell A1 regardless of
what cell was active when the worksheet was saved.  Sometimes different
people save this worksheet with the cursor resting in different places, so
it's annoying when it opens in some odd blank area.  Any ...

If I have a macro that copies A1 and pastes it into b1, how can I change the
macro to paste it into any selected cell?

I'd like to combine the data in colum 1 with colum 2,  If I use =a1&" "a2 in
colum 3, I can't delete colums 1 and 2.  How can I create column 3 and be
able to delete columns 1 and 2?  Thanks

I need to change the Macro Security level on a computer that has Excel 2003
Viewer on it.
Can someone tell me how I can accomplish this?
Thanks!

I have used the web app at https://www.microsoft.com/office/community/... to
search for answers and post questions.
Of course I've experienced the usual frustrations of that app.
Recently, I've set up subscriptions through Outlook Express and have enjoyed