×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Excel 365 - like a cut out figure

Excel 365 - like a cut out figure

Excel 365 - like a cut out figure

(OP)
How do I make a shape look like a cut out, ie with the center transparent, the edge line visible but external to that all white.
I've tried using a text box and shape with transparency set to 0, but I now realize I need corresponding ?zones? of that text box to be transparent too
Literally to appear like holes cut into a white sheet? revealing content behind, I'm stumped and not even sure what to google.
Is the only option to creat a "blank gif overlay"?
Thanks all

RE: Excel 365 - like a cut out figure

Just use a border around a regular cell (or group of cells).
You can set a thickness and a color to it from the dropdown menus in Excel.

Best Regards,
Scott
MSc ISM, MIET, MASHRAE, CDCAP, CDCP, CDCS, CDCE, CTDC, CTIA, ATS, ATD

"I try to be nice, but sometimes my mouth doesn't cooperate."

RE: Excel 365 - like a cut out figure

"transparency set to 0".

Transparency = 0 means opaque. If you want to see content behind a shape, set transparency to a high value.

Shapes are homogeneous - they don't have "zones". You could make a composite of shapes, with differing transparency as you need.

Why don't you explain what you are trying to achieve, rather than constraining the possible solutions by explaining how you think it should be done.

RE: Excel 365 - like a cut out figure

If I need a rectangular range only visible, I hide other rows and columns.
To select all columns on the right of the range, I select first column to hide, press CTRL+SHIFT+RIGHT ARROW, right-click selected area and hide from the popup menu. Similar action with DOWN ARROW to select all rows below selected row.

combo

RE: Excel 365 - like a cut out figure

Quote (mintjulep)

Why don't you explain what you are trying to achieve, rather than constraining the possible solutions by explaining how you think it should be done.

The WHAT is so important for you to clearly, concisely and completely explain, in order that the experts here in the HOW, have enough information to offer a cogent solution.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

You Matter...
unless you multiply yourself by the speed of light squared, then...
You Energy!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close