Hi!
I´m looking for a way to make my dokument display automatically generated
page numbers on screen, aswell as on the printed version. The header and
footer are great tools, as long as you print the document. I haven´t found
software 發表在 痞客邦 留言(0) 人氣(0)
Using Excel XP -
I have some cells formatted as text. The shading is white, text black.
I also have these set with conditional formatting (3). If I enter
certain text, it is set to shade a certain cell color and text color.
software 發表在 痞客邦 留言(0) 人氣(0)
I want to change the source data path of a Pivot Chart that's pulling data
from an Access table. I tried following the KB at
office.microsoft.com/en-us/as...991761033.aspx but when I
click on quot;Get Dataquot; it just shows the other tables in that database, where I
want to change the file it's reading from (same database name just different
software 發表在 痞客邦 留言(0) 人氣(0)
I'm trying to automatically enter data into multiple cells based on one cells
data.
For instance if a cell in column A = 1 then the adjacent cells in columns B,
C and D will all have specific values which will be true for a value of 1 in
software 發表在 痞客邦 留言(0) 人氣(0)
In posting this, I found the answer from Rowan Drummond from the 10/18/2005
posting.
Turning off quot;High Contrastquot; on my Display option did the trick.....so the
monitor settings was the real problem.
software 發表在 痞客邦 留言(0) 人氣(0)
Hi Experts,
I am hoping that you can help me with the following :
I am preparing a report for 3 sales teams team leaders (TL1, TL2, TL3) who
software 發表在 痞客邦 留言(0) 人氣(0)
I am trying to find the number of shirts by size for individuals in a fund
raiser. In a Pivot Table, Shirt size is in col. b starting on row 10, and
total contributed is in col. e. I want to put each shirt size in row 2 and
post the total for each in row 3 based on col e. being greater than 99. Can
someone tell me the formula? I keep getting value or error. Thanks
software 發表在 痞客邦 留言(0) 人氣(4)
I'm still having difficulty with Conditionl Format....
I like to apply the following...
In Column G
If cell equals number between 1 to 29 Colour Yellow on same row from
software 發表在 痞客邦 留言(0) 人氣(4)
I have review a proceedure written by Ashish Mathur but I can not get it to
work. It continues to return a blank cell. Even when I copy the exact
information the the example he gives. I have written the equation but I am
having difficulty in determining where to mark the arrays
software 發表在 痞客邦 留言(0) 人氣(0)
I earlier asked if there was a way of quot;Colour Coding Tabs, on Excel 2000quot;. I
received two replies, which I'm grateful for.
Now my other question is. Is it possible to download 'Excel 2002' for
free???, so that I can use the Colour Tabbing. I say for free, because I'm a
software 發表在 痞客邦 留言(0) 人氣(0)