Number columns and rows in Excel, instead of having column lettering.
Example: C027R36 instead of AA36

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

I would like to expand and collapse groups of columns just like the subtotal
function does with rows; with a minus sign to collapse and a plus sign to
expand in the gray area for rows. Could I do that with columns?

This has really stomped me. I am trying to figure out how to get rows to expand in excel (with the plus or
minus), next to the row. this will eliminate me from having to retype duplicate data. I know about the group and ungroup in
excel 2007, but it doesn't really do what I need it to do, or I may be doing something wrong. Any help is appreciated,
thanks!!!

How do you enter hours and minutes in an Excel chart so that the chart is tracking time in hours and minutes NOT an actual
time. For example, I want the chart to track time as 5 hours and 10 minutes but when I enter the number 5:10 and format it
to appear as "h:mm" Excel shows it as 5:10 AM.
Please help! Any advice/suggestions would be much appreciated!!!
Thanks,
Ann

I'd like to be able to add a button for superscript and subscript formatting
to the toolbar easily in Excel, like can be done in Word and Powerpoint.
Maybe there is a way built into Excel that I haven't found yet, and I assume
it can be done with Macros, but I am not familiar with them.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

Select the chart. Hold shift & click on edit select Paste picture. on the
picture toolbar the second icon from the left will alow you to change it to
black & white or grey scale. then copy it into word
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)

"SDK"
wrote:

> I created bar and pie charts (with color in excel). I need to change to b&w
> to copy and paste into a word document (can't afford color printing 1000's of
> reports). I found the print in b&w in excel, but that doesn't seem to help
> me. I know I can go in and change the pattern for each data series, but all
> have multiple data series and this seems clunky. Any suggestions of how to
> transform a whole graph from color to black and white?

I am trying to create a form in Excel. In my form I want to be able to Tab
from Cell to cell and input information. Not every cell will need this
function. For example
In A1 I need a gray space to indicate that you should type some
information...here is a visual...

Contact Phone: ___________(this is actually another cell, that I want grayed
out, and someone can click on that cell and automatically start typing.

Then I want them to be able to press tab
OR enter to be navigated to the
next cell that requires information.

I dont want anyone able to change the format of the cell that is asking for
the info...for example, the cell named "contact phone" should not be able to
be changed. But I want its corresponding cell to be able to be changed and
then once done filling in that infomration I want to be able to click enter
or tab and be directed to thenext cell which I have to enter something. I
tried all the protecting sheet steps and it did not do what I was wanting.

Excel 2003 is set to 256 columns, perhaps because my spreadsheet was
originally started in Excel 97. How can I increase the maximum number of
columns to what is possible in Excel 2003? Quattro Pro has far more columns
available. I can't believe that Microsoft would limit Excel 2003 to 256
columns. ?????