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 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.
Download 200+ Excel Shortcuts
I work as a financial analyst and your page is a leading one I use to find so important info for daily tasks like formula explanation, how to construct different formulas and so on. This is brilliant! You helped me a lot. - Sarunas
