ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how to label multi cells respectively in excel (https://www.excelbanter.com/excel-worksheet-functions/133501-how-label-multi-cells-respectively-excel.html)

alexasanford

how to label multi cells respectively in excel
 
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?

Martin Fishlock

how to label multi cells respectively in excel
 
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
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"alexasanford" wrote:

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?


alexasanford

how to label multi cells respectively in excel
 
thats all you have to do to label the cells respectfully?

"Martin Fishlock" wrote:

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
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"alexasanford" wrote:

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?


David Biddulph[_2_]

how to label multi cells respectively in excel
 
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 ...
--
David Biddulph

"alexasanford" wrote in message
...
thats all you have to do to label the cells respectfully?


"Martin Fishlock" wrote:

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


"alexasanford" wrote:

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?




JLatham

how to label multi cells respectively in excel
 
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.

"alexasanford" wrote:

thats all you have to do to label the cells respectfully?

"Martin Fishlock" wrote:

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
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"alexasanford" wrote:

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?



All times are GMT +1. The time now is 07:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com