Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formating Question Please
Excel 2003
I have several groups of cells forming squares these squares have a border line around them making them appear as though each of these groups is a larger square. I need to make a line from the left top to the right bottom. When I use the borders angle formatting even if all the cells are selected Excel wants to make the diagonal line through each individual cell rather than just the selected larger area. Does anyone know how to do this. -- Thanks in advance... Bob |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formating Question Please
Select all the cells that are on the diagonal line
click A1 hold down ctrl and click B2 hold down ctrl and click C3 etc Then click cell formatting borders and click a diagonal line. Hans |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formating Question Please
Unfortunately that didn't work because even tough the total area is square
some of the cells that make it up are of varying column widths. Bob "flummi" wrote in message ups.com... Select all the cells that are on the diagonal line click A1 hold down ctrl and click B2 hold down ctrl and click C3 etc Then click cell formatting borders and click a diagonal line. Hans |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Easy Conditional Formating Question | Excel Discussion (Misc queries) | |||
Pivot table question | Excel Discussion (Misc queries) | |||
Conditional Formating Question | Excel Discussion (Misc queries) | |||
How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
Conditional Formating Extreme Question | Excel Worksheet Functions |