0

I'm pretty new to Excel, so please forgive me.

I'm watching a tutorial right now and when he types a structured reference into an empty cell, i.e.

=Tracking[Category]

it spits our the entire referenced array.

When I do it, only the respective row value appears and I have to drag down the autofill-handlebar to see the rest of the array. It is vital for the spreadsheet to work that this command gives me the whole array at once. Does anyone have an idea?

Improve this question
2
  • 1
    Does he do that in a Table? Commented May 28, 2023 at 14:03
  • 2
    You probably don't have Office 365. Commented May 28, 2023 at 16:16
Related questions
925
How do I print the full NumPy array, without truncation?
2
How do I increment a different sheet cell reference row as i autofill across columns?
113
Excel formula to reference 'CELL TO THE LEFT'
Load 5 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.