General

How can I save a sort order for re-use instead of having to type i
I am trying the 2007 Excel for a possible upgrade from my existing Excel 2000. I made my own "to do" list that I use every morning. Since priorities change since tasks get carried over each day, I sort and resort the list to get the right tasks in the right order for that day. Three columns represent the sort ... 21 Jan 2010 16:55

Excel Button
I created a macro and assigned it to a form button in excel 2007. I would like to see that button move up or down when I scroll. ... 21 Jan 2010 11:12

enormous formula bar and row height on opening excel
every time I open excel I get a huge formula bar and row height is set at 76.7 please advise regards, chris ... 21 Jan 2010 11:12

Pivot Table - Just show Value in Summery no Calculation
I am trying to use a Excel 2007 Piviot Table to translate this information Name | Subject | Grade Studentname 1 | Maths | D Studentname 1 | Science | E Studentname 1 | English | A Studentname 2| Maths | A Studentname 2 | Science | B Studentname 2 | English | C To a Pr... 21 Jan 2010 18:04

how to start with 0 in a cell in excel
whenever I try to enter 0 with some nos 0 is not coming in starting of number.I want to put a value in a cell with 0 starting number ... 21 Jan 2010 07:50

Can Excel 2007 open a numbers file?
Just wondering if there's an add-in that will let Excel open a numbers file, thanks. ... 20 Jan 2010 20:51

Data Connection between Excel 2007 and SharePoint 2007
I have established a data connection in an Excel 2007 document from a SharePoint 2007 list. I then format the data in the Excel document. When I refresh the data connection, I lose some, but not all of my formatting. Why is this, and how can I fix it? ... 20 Jan 2010 18:36

Assigning letter for numerical value
want to assign a letter or number based on calculated value (much like a grading scale.) If calc value is: ..0 to .25= I ..26 to .50= H .. .. .. final one >5.1 =A can you do as an array beside doing the If > and < formula thx ... 21 Jan 2010 04:33

Pivot Table- Column 2 sort
How can I sort a Pivot Table by the 2nd (or any other) column? I've selected a cell and hit the A-Z Z-A Sort button, but it only works on column 1. Thanks! ... 21 Jan 2010 15:47

Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding?
When I enter a 16 digit credit card number, excel rounds the last digit to 0; How do I format to reatin the exact number I entered (Have formatted cells to numbers, no decimal places now.) ... 20 Jan 2010 12:56