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 can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
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,224,823
Messages
6,181,177
Members
453,021
Latest member
Justyna P

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