I need help with excel

Question

I need help with using the following instructions, select the cells containing the date, daily sales, and temperature values only, but not the Date, Sum of Sales, and Sum of Temperature header cells or the Grand Total footer cells:

• Click cell A4, which should contain the date value for January 1 2017.
• Then press SHIFT + CTRL + ⇨ (SHIFT + ⌘ + ⇩ on Mac OSX) to extend the selection to include the sales and temperature values.
• Then press SHIFT + CTRL + ⇩ (SHIFT + ⌘ + ⇩ on Mac OSX) to select the rows beneath the current selection.
• Finally press SHIFT + ⇧ to de-select the grand totals.

Answer 1

Hi @MVP TRAP Hunt

Thank you for reaching out to the Microsoft Q&A Forum.

Based on your description, it looks like you're trying to select only the data values (date, daily sales, and temperature) from a table, excluding the header row and the Grand Total row at the bottom. I’ve reviewed and tested the steps you provided, and they appear to work correctly for that purpose.

Could you please clarify what specific issue you're encountering or what kind of support you need further? If possible, kindly share a screenshot of your sample worksheet so I can better understand the situation.

I'm looking forward to your response!

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

The steps described will select a region starting in cell A4 and extending to the right and down until blank cells are found. You can Google "current region" for more details.

Step 1 selects cell A4

Step 2 extends the selection to the right up to but not including the first blank cell encountered in row 4.

Step 3 expands this extended selection down up to but not including the first balnk cell found in column A.

Step 4 shortens the expanded selection by removing the bottom row.

What part of this process do you need help with?

Whether the steps will do what your describe at the top of your post depends on how your data is organized in the spreadsheet. If you show us a small sample, we might be able to offer additional assistance.