13 answers
by going to tools, then options, then color, you cannot modify a color afterwards; reset to defaults to restore the original colors.
Good evening
With other colors than Excel...? aside from using a brush and tubes of paint, I don't see how
However, if you want to use colors other than those in the basic table, go to
Tool / Options / Color / modify and play around with the options in the box
BCRDLMNT
--
Science without conscience is but the ruin of the soul
With other colors than Excel...? aside from using a brush and tubes of paint, I don't see how
However, if you want to use colors other than those in the basic table, go to
Tool / Options / Color / modify and play around with the options in the box
BCRDLMNT
--
Science without conscience is but the ruin of the soul
Hello Eric
As our mutual friend Marin@ taught us, to fit a shape to a cell:
Take the process you described, but draw in the cell while holding down the alt key. In this option, no matter which shape you choose, it automatically fits the cell.
The transparency indeed allows for using the cell under good conditions; otherwise, it is hidden. However, moving and resizing it with the cells only serves to link the shape to the dimensions of the cell, but it does not calibrate it to the construction.
Let's also clarify for gham that part of the textures (hatchings, dots, snow) variable in color is also accessible from the Excel tools menu.
Have a nice day; come on, it's almost vacation time? Think of me, I don’t have any!
--
Science without conscience is but the ruin of the soul.
As our mutual friend Marin@ taught us, to fit a shape to a cell:
Take the process you described, but draw in the cell while holding down the alt key. In this option, no matter which shape you choose, it automatically fits the cell.
The transparency indeed allows for using the cell under good conditions; otherwise, it is hidden. However, moving and resizing it with the cells only serves to link the shape to the dimensions of the cell, but it does not calibrate it to the construction.
Let's also clarify for gham that part of the textures (hatchings, dots, snow) variable in color is also accessible from the Excel tools menu.
Have a nice day; come on, it's almost vacation time? Think of me, I don’t have any!
--
Science without conscience is but the ruin of the soul.
Problem
The user cannot find the feature that allows for hatching in shapes as they did in Excel 2003.
Solution
This feature does not exist in Excel 2007. However, we found a workaround at the office with our draftsmen by reproducing the formatting from the shapes taken in Excel 2003. Copy a shape template with hatching from 2003, paste it into Excel 2007, then reproduce the formatting in 2007 with the new shape you want in 2007; it works and is great and simpler to do than creating VBA macros or other methods.
The user cannot find the feature that allows for hatching in shapes as they did in Excel 2003.
Solution
This feature does not exist in Excel 2007. However, we found a workaround at the office with our draftsmen by reproducing the formatting from the shapes taken in Excel 2003. Copy a shape template with hatching from 2003, paste it into Excel 2007, then reproduce the formatting in 2007 with the new shape you want in 2007; it works and is great and simpler to do than creating VBA macros or other methods.
Hello,
And if you really want to get rid of Excel's colors and put a pattern instead, you can do this:
- Add a rectangle shape adjusted over your relevant cell(s)
- right-click on it and select 'Format Shape'
- in the 'Properties' tab, choose 'Move and size with cells'
- in the 'Colors and Lines' tab, set the fill transparency to 66%, for example
- and in color, you have access to 'More Colors' (which does not change Excel's base colors) and 'Patterns and Textures'. In the latter, you can use a gradient, predefined or custom textures, an image...
eric
And if you really want to get rid of Excel's colors and put a pattern instead, you can do this:
- Add a rectangle shape adjusted over your relevant cell(s)
- right-click on it and select 'Format Shape'
- in the 'Properties' tab, choose 'Move and size with cells'
- in the 'Colors and Lines' tab, set the fill transparency to 66%, for example
- and in color, you have access to 'More Colors' (which does not change Excel's base colors) and 'Patterns and Textures'. In the latter, you can use a gradient, predefined or custom textures, an image...
eric
Hello Vaucluse
Thank you for the reminder about the Alt key
"moving and resizing with the cells only serves to link the shape to the dimensions of the cell"
that's indeed the goal
"a part of the textures (hatching, dots, snow) varying in color is also accessible from the Excel tools menu"
I don't see that...
For a cell, I can only put a pattern (and not from the tools menu) and not a texture which is an image (fabric, grass, stones...)
If you could confirm
What a tough life it is being a retiree, no more vacations sniff
But I think you can still appreciate the passing time :-)
Have a good day
Eric
Thank you for the reminder about the Alt key
"moving and resizing with the cells only serves to link the shape to the dimensions of the cell"
that's indeed the goal
"a part of the textures (hatching, dots, snow) varying in color is also accessible from the Excel tools menu"
I don't see that...
For a cell, I can only put a pattern (and not from the tools menu) and not a texture which is an image (fabric, grass, stones...)
If you could confirm
What a tough life it is being a retiree, no more vacations sniff
But I think you can still appreciate the passing time :-)
Have a good day
Eric
Hello Eric
1) Note:
That's the point. ....
What I'm explaining is that in the option to resize with cells, the shape will grow and move with the cell formatting, but that's not enough for, for example, a rectangle to automatically and perfectly fit the cell's outline when drawn, which is what the alt option allows.
2) Note
We agree, I just wanted to clarify that in addition to colors, there are also available patterns (hatching, dots, bubbles, grid, etc... Nothing else. And indeed, it can be placed as an icon in the taskbar, but it's not in the tools menu.....my bad, I didn't explain myself well!
3) nah nah neeehhhhh!
BCRDLMNT ;-)
--
Science without conscience is but the ruin of the soul.
1) Note:
That's the point. ....
What I'm explaining is that in the option to resize with cells, the shape will grow and move with the cell formatting, but that's not enough for, for example, a rectangle to automatically and perfectly fit the cell's outline when drawn, which is what the alt option allows.
2) Note
We agree, I just wanted to clarify that in addition to colors, there are also available patterns (hatching, dots, bubbles, grid, etc... Nothing else. And indeed, it can be placed as an icon in the taskbar, but it's not in the tools menu.....my bad, I didn't explain myself well!
3) nah nah neeehhhhh!
BCRDLMNT ;-)
--
Science without conscience is but the ruin of the soul.
Hello
It’s been almost two years since we solved the problem... you’re lucky we found your question!!!
Right-click on the cell
Cell format
Pattern (at the bottom left of the window, dropdown menu, on the arrow)
choose the hatching you want, or dotted lines, or grid, etc... and even the color too...!
Best regards
--
Let’s ask ourselves if we’re not alone in understanding what is being explained?
It’s been almost two years since we solved the problem... you’re lucky we found your question!!!
Right-click on the cell
Cell format
Pattern (at the bottom left of the window, dropdown menu, on the arrow)
choose the hatching you want, or dotted lines, or grid, etc... and even the color too...!
Best regards
--
Let’s ask ourselves if we’re not alone in understanding what is being explained?
All I can say on the subject is that in Excel, with the drawing toolbar, you get the same possibilities as in Word... but of course, a shape has to be drawn; I don't think it adapts to Excel charts.
Best regards
--
Let's ask ourselves if we are not the only ones who understand what is being explained?
Best regards
--
Let's ask ourselves if we are not the only ones who understand what is being explained?
Hello,
Transfer them? No!! You have them in Excel, either by double-clicking on a series in your histogram or by using "format data series" from the chart toolbar.
Tab Patterns, in the Area box, at the bottom, click on patterns and textures. And there you have the texture tab with hatches, checkers, and also crosshatching....
But it's not very nice in a chart... better to play with colors. Well, that's just my opinion and you didn't ask me...
--
Argitxu
Transfer them? No!! You have them in Excel, either by double-clicking on a series in your histogram or by using "format data series" from the chart toolbar.
Tab Patterns, in the Area box, at the bottom, click on patterns and textures. And there you have the texture tab with hatches, checkers, and also crosshatching....
But it's not very nice in a chart... better to play with colors. Well, that's just my opinion and you didn't ask me...
--
Argitxu
Hello
This corresponds to a 2003 version, not 2007.
The hatch patterns serve me for black and white prints.
I found the patterns in Excel as Vaucluse indicated.
For the cells, OK
For the graphics and drawing areas, hello banana.
Creation in 2003 then saved in 2007, OK. => tinkering.
2007, starting from a cell, create an image, cropped screenshot, insertion. => tinkering.
As for the graphics, too bad.
More troublesome for the drawing areas. No more industrial design.
Thank you for your responses.
This corresponds to a 2003 version, not 2007.
The hatch patterns serve me for black and white prints.
I found the patterns in Excel as Vaucluse indicated.
For the cells, OK
For the graphics and drawing areas, hello banana.
Creation in 2003 then saved in 2007, OK. => tinkering.
2007, starting from a cell, create an image, cropped screenshot, insertion. => tinkering.
As for the graphics, too bad.
More troublesome for the drawing areas. No more industrial design.
Thank you for your responses.
Hello,
Yes, you're right, for black and white, the patterned hatching from 2003 is useful.
As you saw, in Excel 2007, they are only carried over for cells. Not for charts, drawing areas, and text boxes.
However, the hatching from a chart created in 2003 is retrieved in 2007. By adding a series, the same format is taken over. Unfortunately, that's where it stops.
--
Argitxu
Yes, you're right, for black and white, the patterned hatching from 2003 is useful.
As you saw, in Excel 2007, they are only carried over for cells. Not for charts, drawing areas, and text boxes.
However, the hatching from a chart created in 2003 is retrieved in 2007. By adding a series, the same format is taken over. Unfortunately, that's where it stops.
--
Argitxu