How do you select non adjacent cells in excel on a mac

Entering data or formulas in non-adjacent cells simultaneously

Position your cursor in the first row or column. You can also do this by hiding the rows or columns in your worksheet.

However, when you unhide the rows or columns, they will automatically show up in the chart. Select data from multiple worksheets Create a summary worksheet to pull the data from multiple worksheets together, and create the chart from the summary worksheet. To create the summary worksheet, copy data from each source worksheet, and then on the Paste menu, select Paste Link.

With Paste Link , when the data is updated on your source worksheets, the summary worksheet and chart will also be updated.

For example, if you have one worksheet for each month, you could make a 13th worksheet for the entire year—that includes data from each of the monthly worksheets that you want for your chart. Another way to create a chart is to select the type of chart you want, and then specify the data to include. You can also change the data range after you've created a chart. On the Chart Design tab, select Select Data.

Click in the Chart data range box, and then select the data in your worksheet. Excel for Mac keyboard shortcuts. To select Here's what to do Multiple adjacent columns Position the cursor in the column header of the first column, and click and hold while you drag to select adjacent columns.

How to Select Worksheet Cells in Excel for Mac - dummies

Multiple adjacent rows Position the cursor in the row header of the first row, and click and hold while you drag to select adjacent rows. Partial rows or columns Position the cursor in the top left cell, and click and hold while you drag to the bottom right cell. All content in a table Position the cursor anywhere in the table.


  • medal of honor para mac download.
  • About garysch?
  • painter essentials 4 mac keygen.
  • How to quickly select non-adjacent cells or ranges in Excel?!

All content in a named range Position the cursor anywhere in the named range. Create a summary worksheet to pull the data from multiple worksheets together, and create the chart from the summary worksheet. Expand your Office skills. Get instant Excel help.

Related videos

Error: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title.


  • Apple Footer!
  • microsoft excel - Select Cells in Column Up to End of Data in Adjacent Column on OSX - Super User.
  • Was this information helpful?!
  • Download 200+ Excel Shortcuts.
  • Office 2011 for Mac All-in-One For Dummies;
  • Related Posts;

You can not post a blank message. Please type your message and try again. Can anyone help me here? Thanks in advance! I have the same question Show 0 Likes 0. This content has been marked as final.

Question Info

Show 2 replies. This should allow you to press Control-Left Click to perform multiple selection. Good luck! Go to original post. Retrieving data Correct Answers - 10 points.