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.
