Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
Neither of these solutions are very good, but you never know... In 2007, if you choose Word Art you can draw the strikeout through the middle of the text. The line will attach to the vertical midpoint of the text box. The line can be colored any color. In 2003 you can add a flowchart rectangle and attach a connector to its mid points, then color the connector and select the edge of the rectangle and choose Format AutoShape, select the Colors and Lines tab and choose No Line for Line Color and None for Fill Color. Hold down the Alt key and drag the rectangle over the cell where you want strikethrough. This will get it to snap to grid. Resize the shape using the Alt key to get it to fit exactly in the cell. Resize the column width to match the text length. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Lerner" wrote: Can I get the croos out line on different color than the text crossed out ? Tx. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007: Ctrl+PgUp or Ctrl+PgDn with Protected Sheets | Excel Discussion (Misc queries) | |||
CTRL X...CTRL V...Why does it NOT work? | Excel Discussion (Misc queries) | |||
use CTRL key inside a macro IE CTRL + ; | Excel Worksheet Functions | |||
Anyone having Ctrl+C / Ctrl+V problems in E2007? | Excel Discussion (Misc queries) | |||
How to forbid ctrl+c and ctrl+X in sheet? | Setting up and Configuration of Excel |