Make Professional Looking Rounded Buttons in Excel

Add to Favorites

How to make professional looking rounded buttons in Excel.

This allows you to avoid using basic buttons and also to style the buttons to your content so they better blend-in with everything.

Steps to Make Nice Buttons in Excel

  1. Go to the Insert tab and click the Shapes button:
  2. From the drop down menu that appears you will have many options.  To create buttons, look to the Rectangles section.  From there, choose a Rounded Rectangle:
  3. At this point, your cursor will look like a cross.  Left-click where you want the button to appear, hold the left mouse button and drag and you will see the button start to appear.  This allows you to choose the size of the button, but you can change it later if you mess-up.
  4. You will now have a button that looks like this:
  5. Make sure the button is selected and then click the Format tab that will have appeared.  From here, you can adjust almost any visual aspect of the button.  However, the easiest thing to do is to click the More button for the Shape Styles section and choose a style from there.

  6. Now you should have a nicer looking button.
  7. Add some text to the button simply by starting to type while the button is selected.
  8. To format the text, click a cell in the worksheet to deselect the button and then click the button again once.  Go to the Home tab and format the text like you would any other text.  I usually center the text, middle align it, bold it, and change its size.
  9. As a bonus tip, if you don't need gridlines on the worksheet, remove them by going to the View tab and uncheck the option next to Gridlines.
    There you go, a nice professional button!

Notes

You can attach a macro to this button if you like quite easily, here is our tutorial on that: attach a macro to a button in Excel

Download the sample worksheet attached to this tutorial to see this button in Excel and play around with it.


Downloadable Files: Excel File

Similar Content on TeachExcel
Show Fewer Decimal Places Without Losing Precision in Excel
Tutorial: How to show a smaller number that looks better without sacrificing decimal places or preci...
Input Form to Get Data and Store it in Another Tab in Excel
Tutorial: How to make a user input form in Excel and have the data stored on another worksheet at th...
Countdown Timer in Excel
Tutorial: How to create a countdown timer in Excel. This allows you to display a timer in whatever c...
NPER Function - Calculate Number of Periods Needed for a Set of Payments in Excel
Tutorial: How to calculate the number of periods required for an investment in order to get the desi...
Run a Macro When you Click a Button in Excel
Tutorial: Make a macro run when you click a button in the worksheet in Excel. This allows you to cre...
Remove Print Preview Lines in Excel
Tutorial: Here's how to remove the little dotted lines that sometimes appear on the spreadsheet. S...