|
|
Excel - decimals by
school girl
While using Excel, I find that the system isn't rounding appropriately to
whole numbers - i.e., 84.5 becomes 84 - when it should be 85.
Any help would be...
|
|
3 |
328 |
|
|
How do I set home to A1 instead of K1? by
Julie D[_2_]
If I press the home key on an existing spreadsheet, it goes to K1 instead of
to A1. Is there a way I can fix this? If not, do I have another possible...
|
|
2 |
362 |
|
|
|
|
1 |
373 |
|
|
Pasting a value as an hyperlink by
The Rook
I have imported a list from a database of file paths to documents on our
server, these data is currently formatted as 'General'
Is there anyway of converting...
|
April 20th, 2010 08:05 PM
by Pete_UK
|
1 |
230 |
|
|
|
April 20th, 2010 07:50 PM
by FSt1
|
2 |
186 |
|
|
worksheet change question by
Tonso
As I scroll across a particular spreadsheet, I would like to have the
following columns change width, and zoom, as shown in the code below.
However, the...
|
|
1 |
207 |
|
|
Cell colour in relation to IF results by
Rob
I want a cell to be coloured red if the result of a simple calculation is
negative, and coloured green if the result is positive. Can anyone tell me
how to...
|
April 20th, 2010 07:16 PM
by Eduardo
|
2 |
240 |
|
|
|
|
1 |
224 |
|
|
Format Date Filter Problem by
Stross002
I formatted a date from 4/20/2010 to April-10 I still have a hard time
filtering
my data.
Eventhough it says April-10 it is still reading the day because...
|
|
1 |
195 |
|
|
PROTECTING CELLS by
LOCKING CELLS
I am having trouble protecting some cells. I mark all the required cells to
be locked, then apply the Protect to the spreadsheet. Some cells are locked
and...
|
|
2 |
231 |
|
|
Excel 2003 Pivot Formatting by
Bob[_53_]
On my pivot table i have formatted the sub total rows as "bold" and
"aline right".
Each month fresh data is dropped into the base table, so long as the
number...
|
|
2 |
169 |
|
|
Options saved with the worksheet? by
Eric
Under tools/options, are the options saved with the worksheet, or do they
apply across-the-board for all files that the user is working on? If I set
an...
|
|
4 |
191 |
|
|
Excel - Run Macro on Cell Change by
Malaria Man
I am trying to have 1 of 8 different macro's run depending on the value of a
specific cell.
If I enter 1 in cell A3, I would like macro1 to run. If I change...
|
|
3 |
250 |
|
|
Left Function by
AJ[_10_]
I am trying to pull certain characters based on a criteria for the third
position character.
In Column A, I could have a code such as BB11 or a Code such...
|
April 20th, 2010 06:01 PM
by Mike H
|
1 |
208 |
|
|
Pivot Table Wizard in 2007 by
Jane N[_2_]
I've recently started using Office 2007. I have 3 pivot tables that I need
to update the data source each month. I was able to do this through the
options...
|
|
1 |
227 |
|
|
Excell 2007 will not open XLSX by
Burch
Has anyone run into this problem( excel will not open XLSX files on double
click) the icon has changed into blank page with the excel ion in the middle
of...
|
April 20th, 2010 05:41 PM
by Burch
|
0 |
184 |
|
|
Insert Object Problem by
Raj
Hi All,
I inserted a PDF as an Object into Excel sheet . Now I see the PDF page in
my Excel . But When I try insert a Text Box over the PDF image , the...
|
April 20th, 2010 05:18 PM
by John
|
1 |
201 |
|
|
calculation help by
Norm
I will try to explain this
I want to have a running total for C D F and G and use the numbers in A as a
filter
so if I filter the numbers = 33369 I want the...
|
|
5 |
203 |
|
|
Sorting PivotChart by
DogEatDog World[_2_]
Hi,
In excel 2007 I want to sort data in the chart I made from pivot. I want
them to be sort in descending order. The reason is, I need bar Pivotchart...
|
|
0 |
169 |
|
|
Sorting Pivotchart by
DogEatDog World[_2_]
Hi,
In excel 2007 I want to sort data in the chart I made from pivot. I want
them to be sort in descending order. The reason is, I need bar Pivotchart...
|
|
0 |
201 |