Excel - IF Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc