Using Shapes in Excel 2007

Updated on April 17, 2017

Introduction

Using shapes such as arrows and rounded rectangles in Excel 2007 can really help you emphasise important data in your spreadsheets. It can allow you to lead users of your spreadsheets to specific part of your spreadsheet quickly, or it can simply give your spreadsheet (or specific parts of your spreadsheet) more visual impact.

I use shapes heavily in my Excel 2007 documents. In particular, I use the rounded rectangle, the line arrow and boxed arrows a great deal. The rounded rectangle I use to create buttons with hyperlinks and the arrows I use to draw the readers attention to specific parts of the worksheet. I will illustrate firstly how to create a button with a hyperlink and then I will show how to get the best out of my old friend the red arrow. Examples of shapes are shown below

Examples of Shapes in Excel 2007.
Examples of Shapes in Excel 2007. | Source

Shapes

Both the rounded rectangle and the red arrow are created using the Shapes button on the Insert tab within the Illustrations group.

The rounded rectangle is used when I have something I want people to click (for example a hyperlink). In my example, a hyperlink will be embedded in the rectangle and activated when the user clicks on the rectangle. It can easily be sized to look like a button, so people will naturally click on it to return to the top of a document.

The red arrow to emphasise text. The line arrow I use to highlight a specific part of a chart for example and the box arrow is used to highlight something in its entirety (for example my button, or something I really want someone to fill in).

Using a rounded rectangle as a button containing a hyperlink

In the first example, we are going to create a button using the round rectangle shape that when clicked will take the user of our spreadsheet back to the top of the worksheet.

First we have to create the rounded rectangle.

  • To create it, select the Shapes button.
  • Select the rounded rectangle from the Rectangles section.
  • The cursor will change to a + inviting you to size and place the rectangle as you desire.
  • You will now have a blue rounded rectangle.
  • Next can add text to it by simply clicking on it and typing, or right clicking on it and selecting Edit Text.

Now we create the hyperlink at the top of the document for use in our button.

  • First, right click on a cell at the top of the worksheet and select Hyperlink from the Insert tab in the Links group.
  • Select Link to: Place in This Document.
  • Change the Text to Display to something meaningful (in the screen shot below you can see I chose Top imaginatively).

Creating a hyperlink to another section in an Excel 2007 workbook.
Creating a hyperlink to another section in an Excel 2007 workbook. | Source

Now that we have a hyperlink set up for the top of the document you now need to add the hyperlink to the button.

This is achieved by right clicking the rounded rectangle and selecting Hyperlink.

Select Place in This Document on the left hand side and your newly created hyperlink at the top of this worksheet should be selectable

Finally, to make our rectangle look a bit more like a button, I gave it a bevel.

To do this, right click on your rectangle and select Format Shape

Click on 3-D Format and then the Top Button / Bevel as shown below

Add a 3-D effect (Bevel) to a rounded rectangle shape in Excel 2007.
Add a 3-D effect (Bevel) to a rounded rectangle shape in Excel 2007. | Source

Your button now has a nice 3D effect and is ready for use.

The red arrow shape

I love using the red arrow in Excel 2007 (and Word 2007 for that matter). Whenever I want to draw someone’s attention to something important on a worksheet, I use a red arrow to point to it. It is admittedly not very subtle, but it is very effective.

The Shapes button has two groups of arrows available. The first is under Lines and the second is under Block Arrows.

I use both arrow styles, but for slightly different uses.

The arrow from the Lines group of shapes

I typically use this arrow when I want to point out something within a chart or other object. As you can see from the picture below, I am trying to draw attention to one particular value on a graph that I feel is important.

Using a red arrow shape for emphasis in Excel 2007.
Using a red arrow shape for emphasis in Excel 2007. | Source

To create such a red arrow, select the Shapes button and then the arrow from the Lines group.

  • To turn it around, grab one end of the arrow and rotate it to the angle you like.
  • Click on the arrow in the middle to move it in its current form.
  • To change the colour or make the arrow bigger, right click on it and select Format Shape. My arrows are normally 6pts in width (feel free to use whatever width you feel looks best).
  • You can also change the colour using the Line Colour tab as well as an array of other formatting changes

Using the arrow from the Block Arrows group of shapes

I use the block arrows when I want to point out something in its entirety. For example, if I wish to draw attention to the button I created above, I would use a block arrow. To create a block arrow

  • Click on the Shapes button and select your chosen arrow from the Block Arrow group
  • As before, use the cursor to position and size the arrow
  • Also right click and use the Format Shape option to colour and otherwise format your arrow.
  • To rotate you arrow, click on it and select the green dot at the tip of the arrow as shown below. The cursor will change to a circle and you can rotate your arrow until it is in the desired position.

How to move a block arrow shape into position in Excel 2007.
How to move a block arrow shape into position in Excel 2007. | Source

The below picture shows how I would use a block arrow to draw attention to my button. It is very hard to miss I think you will agree!

Using a block arrow shape to emphasize a button in Excel 2007.
Using a block arrow shape to emphasize a button in Excel 2007. | Source

Conclusion

I hope that by following through my two examples of how I utilise shapes you have been encouraged to use shapes in your own Excel 2007 workbooks. I am sure there are literally thousands of uses for shapes; their usefulness is bound only by your imagination. I have shown how to incorporate buttons and links into worksheets using rounded rectangles as well as the very useful red arrow in both of its manifestations. I hope that you have found this article useful and that you have enjoyed reading it as much as I enjoyed writing it.


Questions & Answers

    Comments

      0 of 8192 characters used
      Post Comment

      No comments yet.

      working

      This website uses cookies

      As a user in the EEA, your approval is needed on a few things. To provide a better website experience, hubpages.com uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

      For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at: "https://turbofuture.com/privacy-policy#gdpr"

      Show Details
      Necessary
      HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
      LoginThis is necessary to sign in to the HubPages Service.
      Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
      AkismetThis is used to detect comment spam. (Privacy Policy)
      HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
      HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
      Amazon Web ServicesThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized. (Privacy Policy)
      CloudflareThis is used to quickly and efficiently deliver files such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
      Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the googleapis.com or gstatic.com domains, for performance and efficiency reasons. (Privacy Policy)
      Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
      PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
      Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
      Features
      Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
      Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
      Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
      Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
      VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
      MavenThis supports the Maven widget and search functionality. (Privacy Policy)
      Marketing
      Google AdSenseThis is an ad network. (Privacy Policy)
      Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
      Index ExchangeThis is an ad network. (Privacy Policy)
      SovrnThis is an ad network. (Privacy Policy)
      Facebook AdsThis is an ad network. (Privacy Policy)
      Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
      AppNexusThis is an ad network. (Privacy Policy)
      OpenxThis is an ad network. (Privacy Policy)
      Rubicon ProjectThis is an ad network. (Privacy Policy)
      TripleLiftThis is an ad network. (Privacy Policy)
      Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
      Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
      Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisements has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
      Statistics
      Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
      ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
      Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)