#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,346
Default Ctrl+5

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007: Ctrl+PgUp or Ctrl+PgDn with Protected Sheets DrDave Excel Discussion (Misc queries) 1 July 28th 08 04:12 AM
CTRL X...CTRL V...Why does it NOT work? F. Lawrence Kulchar Excel Discussion (Misc queries) 3 April 16th 08 07:11 AM
use CTRL key inside a macro IE CTRL + ; Date Less Excel Worksheet Functions 1 April 14th 08 11:58 PM
Anyone having Ctrl+C / Ctrl+V problems in E2007? Krzysztof Kruszynski Excel Discussion (Misc queries) 1 June 13th 07 01:41 PM
How to forbid ctrl+c and ctrl+X in sheet? GR Setting up and Configuration of Excel 2 December 24th 06 03:39 AM


All times are GMT +1. The time now is 06:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"