answersLogoWhite

0

You identify data ranges in Excel by locating the cells in the top left and bottom right corners of the range.

EXAMPLE:

You have a data range in columns E, F, G, H, I , and J, including rows 1-23. You would identify this range as E1:J23(the colon indicates to use every cell between the two end points).

User Avatar

Wiki User

15y ago

Still curious? Ask our experts.

Chat with our AI personalities

BeauBeau
You're doing better than you think!
Chat with Beau
ProfessorProfessor
I will give you the most educated answer.
Chat with Professor
JordanJordan
Looking for a career mentor? I've seen my fair share of shake-ups.
Chat with Jordan

Add your answer:

Earn +20 pts
Q: How do you write data range in Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp