Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Woody13
 
Posts: n/a
Default Formatting Auto Shapes - Rectangle

I have created something but cannot recreate it and cannot remember what I
did differently. Clicked on Rectangle to form a perimeter around a few cells
and wanted it to look 3-D, which I have done in the past with the shadow
function, specifically shadow style 6. The rectangle I made transparent so
that I can see the numbers underneath. Now when I try this, the shadow does
not form correctly. Because its transparent I can see through it and see the
shadow line behind it instead of it looking like a white box with a grey
shadow. Hard to describe but can someone help? Thanks.
  #2   Report Post  
Duke Carey
 
Posts: n/a
Default

Dont draw the rectangle - just select the cells and then apply the shadow.
Excel will create the transparent rectangle and shadow it correctly.

"Woody13" wrote:

I have created something but cannot recreate it and cannot remember what I
did differently. Clicked on Rectangle to form a perimeter around a few cells
and wanted it to look 3-D, which I have done in the past with the shadow
function, specifically shadow style 6. The rectangle I made transparent so
that I can see the numbers underneath. Now when I try this, the shadow does
not form correctly. Because its transparent I can see through it and see the
shadow line behind it instead of it looking like a white box with a grey
shadow. Hard to describe but can someone help? Thanks.

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
How can i get more 3D shapes for Auto shapes in excel? Ajey Excel Discussion (Misc queries) 0 March 3rd 05 09:53 AM
How can i get more 3D shapes for Auto shapes in excel? Ajey Excel Discussion (Misc queries) 0 March 3rd 05 09:53 AM
Auto Formatting an Excel Spreadsheet Ray Excel Discussion (Misc queries) 0 January 19th 05 09:57 PM
Formatting cells Auto fill color using €œIf€ Masatami Excel Worksheet Functions 4 January 13th 05 01:39 AM
Response to Frank: AM-PM Auto formatting BulaMan Excel Discussion (Misc queries) 2 December 15th 04 10:26 AM


All times are GMT +1. The time now is 07:49 PM.

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

About Us

"It's about Microsoft Excel"