Add non-adjacent cells to selection
Windows shortcut
CtrlClick
Mac shortcut
⌘Click
Hold down the control key and click (or click and drag) elsewhere on the worksheet to add another range of calls to the current selection.
Related videos
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.
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.
In this video, we look how slicers filter data in a pivot table and how to easily add a slicer to a pivot table.