how to label multi cells respectively in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a question in my text book and i dont know how to do it..
exsample:
in cells D2:G2, enter labels "bob", "kat", "greg", "doug"respectively...


how do you do this?
 
Hi:

move the cursor to cell D2 and type bob
move the cursor to cell E2 and type kat
move the cursor to cell F2 and type greg
move the cursor to cell G2 and type doug
press enter
 
No, if you want to label them respectfully (sic), then it would be:
Robert
Catherine
Gregory
Douglas
:-)

As for your original question, you may want to look at Insert/ Name ...
 
That's pretty much it for respectively...

Now, to do it respectively, you should probably address them properly as Mr.
D2, Ms. E2, Doctor F2 and The Honorable G2.

But I think respectively will get the job done for you, and just simply type
in the words as labels.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HOW WILL MOVE TO 2ND WORKSHEET 2
function & column labels 2
IF Function 3
Conditional Formatting 4th Condition 3
how do I create a nonadjacent series for autofill to go by? 3
IF LEN formula 4
If statement when two cells are the same 2
Formula to Sort Numbers 9

Back
Top