format columns to collapse and expand in excel

I already did this in an old excel worksheet but I CAN'T remember HOW I DID IT.

The result is a (plus) + and a (minus) - sign at the top of the worksheet in
row 1 at the location where you want your selected columns to either expand
or collapse.

I need to once again implement this handy formatting trick but for the life
of me remember how I did it....so frustrating!

Anyone out ther know how to do this?


How to prevent user resizing columns and rows in excel (2003) ?

Cheers

Ollie Riches

Want to get all colours in Excel 2003 and 2007?
In this format..
Sr.No. ------------- Colour Index No ------------- Actual Colour--------Colour Name

I have just two worksheets ,Excel 2003 and Excel 2007 and the above Column Headings in both the sheets..

I want to get atleast close to 60 Colours if possible.

Regards
e4excel

How to use dates and times in Excel

Describes how to use the built-in date and time functions in Excel to perform complex date ... If you want to use a custom format instead, you must enclose the hours parameter of ...

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.

http://www.microsoft.com/office/comm...ic.excel.setup

I cannot seem to be able to change the background colors of columns, rows and
cells in Excel. I had no problem when I was using Office 97.
How can I do this with Office 2003?

Hi

In one of the slide under one of the main point I have few sub-points. Now I wanted to collapse those sub-points, and when I click it I want it to be expand.

How do I do it? Please note that I want it on slide not anywhere else.

If you know please help. Thanks in advance :-)

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?

I cannot seem to be able to change the background colors of columns, rows and
cells in Excel. I had no problem when I was using Office 97.
How can I do this with Office 2003?

Hi!

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 TO: Create an Add-in Application Name and Description in Excel ...

In Microsoft Excel, you can create an add-in application that contains any of the following elements: functions, custom dialog boxes, custom...

How to use dates and times in Excel for Mac

To help you perform complex date and time calculations, Microsoft Excel includes many built-in date and time functions. Back to the top

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

How to use dates and times in Excel

Describes how to use the built-in date and time functions in Excel to perform complex date and time calculations. Provides some examples.

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.

http://www.microsoft.com/office/comm...lic.excel.misc

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?

how to copy a cell in excell and paste in a txt file with macro

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.

Thank you in advance.

What's the best way to toggle between true and false in Excel?

Hi all,

My excel work involves a lot of toggling between true and false
(boolean types) ... and it's very repetitive...

Is there a way to select a bunch of cells, and press a key short-cut
so that they toggle all at once?

Thanks!

How To Use Date And Times In Excel For Windows Microsoft Knowledgebase

Describes how to use the built-in date and time functions in Excel to perform complex date and time calculations. Provides some examples.

How To Use Dates And Time In Excel

Describes how to use the built-in date and time functions in Excel to perform complex date and time calculations. Provides some examples.

How To Use Date And Times In Excel For Mac Microsoft Knowledgebase

... 06 represents the date and time 7/8/1992 1:26:24 A.M. To help you perform complex date and time calculations, Microsoft Excel includes many built-in date and time functions.

How to use dates and times in Excel

Describes how to use the built-in date and time functions in Excel to perform complex date and time calculations. Provides some examples.

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. ?????

Looking for a code which would loop in a column to find and select what
is in my active cell.

Eg: Activecell : B5 = "Test"

B6 & B7 also contains "Test"

How can I loop in column B to find & select all 3 cells.

Thxs