**Question description:**

*This user has given permission to use the problem statement for this blog.*

I have a group of cells with information and I want to highlight the cells on a mac and no matter what i try if I highlight one corner and try to drag it it just copies the info from the first cell and deletes the info it is soooooo not user friendly

Solved by G. J. in 20 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
17/08/2018 - 03:29

hi

Excelchat Expert
17/08/2018 - 03:29

how are you doing

Excelchat Expert
17/08/2018 - 03:29

you are not able to chat in this window?

User
17/08/2018 - 03:30

non

Excelchat Expert
17/08/2018 - 03:31

there you are

User
17/08/2018 - 03:31

yes

Excelchat Expert
17/08/2018 - 03:31

ok

User
17/08/2018 - 03:31

I can't see my responses though

User
17/08/2018 - 03:31

no i can

Excelchat Expert
17/08/2018 - 03:31

hmmm

Excelchat Expert
17/08/2018 - 03:31

:)

User
17/08/2018 - 03:31

now i can

Excelchat Expert
17/08/2018 - 03:31

ok.. so you want to highlight cells

User
17/08/2018 - 03:32

not without deleting everything in them and changing it to the first cell info it just copies it

Excelchat Expert
17/08/2018 - 03:32

when you drag the cell all it will do is copy the formulas or the actual values or in case of number increment them but formatting isnt passed on

User
17/08/2018 - 03:32

i am using a mac

Excelchat Expert
17/08/2018 - 03:32

yes

Excelchat Expert
17/08/2018 - 03:32

you would have to select all the cells you need to format

Excelchat Expert
17/08/2018 - 03:33

now assuming they are int he same row or column

User
17/08/2018 - 03:33

so how do you do that just to make a simple graph

Excelchat Expert
17/08/2018 - 03:33

meaning?

User
17/08/2018 - 03:33

can i type in here and you just show me

Excelchat Expert
17/08/2018 - 03:33

do you want to highlight cells or make graph

Excelchat Expert
17/08/2018 - 03:33

yes or you can share your file

Excelchat Expert
17/08/2018 - 03:34

ok i see

Excelchat Expert
17/08/2018 - 03:35

now?

User
17/08/2018 - 03:35

so what do you hold down to just highlight the cells without changing them...its ridculous

User
17/08/2018 - 03:35

yes

Excelchat Expert
17/08/2018 - 03:35

he he

Excelchat Expert
17/08/2018 - 03:35

ok select 1 cell

Excelchat Expert
17/08/2018 - 03:36

now if you want to highlight a series of rows select 1 cell in the row then the last

Excelchat Expert
17/08/2018 - 03:36

exampl row 1 : select a1 hold the shift key then select z1

Excelchat Expert
17/08/2018 - 03:36

the entire range would be selected then you have to select the highlight needed

User
17/08/2018 - 03:37

ok it was the shift key

Excelchat Expert
17/08/2018 - 03:37

yes

[Uploaded an Excel file]

User
17/08/2018 - 03:38

why are there instructions to show that

User
17/08/2018 - 03:38

thank you

Excelchat Expert
17/08/2018 - 03:38

:) welcome

User
17/08/2018 - 03:38

then how do you create graph after highlighted

Excelchat Expert
17/08/2018 - 03:39

hmm go to insert tab

User
17/08/2018 - 03:39

ok thank you so much

Excelchat Expert
17/08/2018 - 03:39

:)

[Uploaded an Excel file]

Excelchat Expert
17/08/2018 - 03:39

have a nice day

Excelchat Expert
17/08/2018 - 03:40

please do click on end session and leave a feedback

Excelchat Expert
17/08/2018 - 03:40

a perfect pie graph :)

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*