Why 2016 version not allowing me to do it?

bhandari

Active Member
Joined
Oct 17, 2017
Messages
359
Mango=A1
I tried to do some modification in A1,but it wont allow me to select all
I used Ctrl+A,its not working to select the cell data
i am keep doing dragging for selecting the whole text.

Any solution for this?
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
i have 2016 ,it does allow ctlA, cell mods, etc.

You must be in a 'mode', that prevents it.
ex: you cannot use Ctl-A if you are editing a cell,because you are in edit mode.
same with other functions, if a pending edit , or function is not completed , other functions are disabled.
 
Upvote 0
if you use 2013 version yu will know it will alow to select the whole text by using CTRL+A

y it is not allowing in 2016?
 
Upvote 0

Forum statistics

Threads
1,214,918
Messages
6,122,252
Members
449,075
Latest member
staticfluids

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top