Quick, clean, and to the point

Snap to grid

Windows shortcut 
Mac shortcut 

Use this shortcut to snap objects to the Excel grid, including  including charts, shapes, smart art, and text boxes. This works both for dragging objects to a new location on the worksheet, as well as resizing objects so that their edges align to the grid. This is a very handy way to ensure objects are exactly the same size without enabling the snap to grid setting in Excel.

Related videos

Tip: How to build a simple dynamic chart
In this video, we look at how to build a chart that automatically includes new data, and dynamically highlights the top and bottom values. This is an easy way to create an interactive chart for dashboards and other reports.
Tip: How to chart sunrise and sunset times
In this video, we'll look at how to chart average daylight hours for each month of the year, using sunrise and sunset data. This is a good example of a floating bar technique using a stacked column chart and helper columns.
Tip: How to plot survey data in a bar chart
In this video, we demo how to plot results from a survey question in an Excel bar chart. Along the way, we use the COUNTIF function to build a summary table, and show a simple technique for creating an "other" bucket.