Today we’re revisiting one of our more popular guides, Creating rounded corners in Excel Tables, and have updated it for v7.1. When Igor Asselbergs was contemplating the value of round corners in design, he came to the conclusion that in many cases they added real value to the user experience.
The effect can be explained by the Gestalt Law of Continuity. Gestalt is a set of rules based on research into perception psychology, and a very powerful tool for Excel table design. In table design this effect can help us to see the table columns as a unit.
The previous process to create rounded corners in Excel tables required quite a bit of persistence and patience. In Version 7.1, we’ve introduced a feature to enable adding rounded corners in a few seconds rather than several minutes, so while the theory is identical the implementation is much improved. Take this report showing sales KPIs, where we would like to add rounded corners to the header row in the table.
To do this we first highlight the required area:
Then we go to Extras -> Add/Edit Round Corners:
The Colours and Border thickness will be picked up from the selected cells. Select the corners to be made round (in this case the Top Left and Top Right corners):
Click OK to apply the borders
To edit existing corners which were created by XLCubed then you can just highlight the cell or range and Go to Extras -> Add/Edit Round Corners. The changes will be applied to the existing corners (or the corners can be removed by unselecting them).
It’s a simple addition to the product which would have saved us quite a bit of time in customer implementations over the years, and hopefully now does the same for our users.
Have you ever tried copying parts of one workbook to another and been restricted by column widths? Or maybe you’re almost done with a report layout only to find that the last table you need to add has 4 columns, where there is only room for 3? Today we’re going to show you how to use Excel’s Camera tool to get around any Excel column width limitations to achieve your dashboard goals! Here we have an Excel heat Map on a separate sheet in our workbook.
It has been inserted into the dashboard below where the first thing to notice is the workbook’s variable column widths, in particular columns J and K. If we had just inserted our heat map as it was, the column widths in our dashboard would determine the width size of the heatmap. Instead we used Excel’s camera tool to insert our heatmap sized at exactly what we wanted, regardless of the destination sheet’s column widths.
We follow these simple steps:
- select the heat map in the source sheet
- click the Camera Tool icon
- navigate to the destination sheet
- click and insert exactly where you want
The Excel Camera Tool is also a great way creating dynamic screenshots of particular groups of data. The Camera Tool takes a picture of a selected area, and you can then paste that picture wherever you want it. It updates automatically, and because it is a picture rather than a set of links to the original cells, any formatting or data change in the source is automatically reflected in the picture.
The heat map chart source figures have been updated to show Europe’s higher sales – as you can see Europe now has the greater sales:
The dashboard heat map has updated automatically to reflect this value change.
If you can’t see the Camera Tool on your Excel menu you can easily attach it to your Quick Access Toolbar by performing the following steps:
- Click the File Tab
- Click Options
- Choose the Quick Access Toolbar Option
- In the ‘Choose Command From’ dropdown, select Commands not in Ribbon
- Find the Camera Tool from the alphabetical list of commands and add it to the Quick Access Toolbar.