Shortcut keys in Excel

  Publisher 20:26 08 Mar 2005
Locked

Here is another problem. If Vog answers this one I will feel obliged to offer him a permanent job!!!

I am producing a chart in Excel which I want people to complete on screen by putting a response in a choice of boxes with a 'tick'.

There is a 'tick' in the symbols, and I have used this in 'WORD' by programming a shortcut keystroke (ctrl + y) to produce a tick. I can't find it in 'help'.

Is there a way of doing that in Excel?

DRiM

  VoG II 20:30 08 Mar 2005

I'll have a go but I don't quite understand the question.

Are these tick boxes on the chart or on a sheet? Are they Text Boxes or what?

The more information the better really.

  Publisher 20:39 08 Mar 2005

Thanks VoG.

I am offering three boxes (cells) which are headed 'yes', 'no' and 'don't know'in a Excel document. They are cells. So the 'tick' is instead of data.

I want the participant to be able to choose a box (cell) and put a tick in it.

I have done it in 'WORD' in the past by creating a shortcut to the symbol, but I don't know how to create the shortcut in Excel.

DRiM

  VoG II 20:45 08 Mar 2005

The easiest way is to record a macro.

Tools, Macro, Record New Macro.

In the dialog box you are given the option to assign a keyboard shortcut.

Place the tick in a cell, press the Enter key then stop the macro recorder.

Thereafter clicking in a cell and pressing the key combination should put a tick in the cell.

  Publisher 21:04 08 Mar 2005

That's fantastic,

thanks a lot.

DRiM

  Simsy 22:27 08 Mar 2005

but might it be easier to have the 3 options, "Yes", "No" and "Don't know" as 3 possible entries for a single cell, with the entries being from a drop down box?

This may be easier for the user(s) as they wouldn't have to know any shortcuts for the macro.



If this would be of use the method is as follows;

1)Select the cell to be used.

2)On the menu bar choose Data>Validation

3)Choose "List" in the "Allow" box

4)In the "Source" box have the values seperated by commas, i.e. Yes,No,Don't know

5)Make sure the box "In cell drop down" is ticked.


I hope this helps. Apologies if it muddies the waters!

Regards,

Simsy

  Publisher 13:52 09 Mar 2005

That is a really interesting idea, thanks, I shall have a look at it.

DRiM

  Dirty Dick 13:50 10 Mar 2005

Simsy
... but I can't seem to follow the instructions.
I open a workbook, select a cell, then ckick on DATA>VAIDATION..., but all I get then is a dailoogue box with 3 tabs. (Settings, Input Message and Error Alert) Where am I going wrong? I'm running Windows XP and Excel 2003.
Thanks
DD

  Simsy 17:05 10 Mar 2005

"Settings" tab, choose "List" from the drop down box called "Allow". (The default entry here is "Any value")

Then, a box will appear below, called "Source". Enter into this box whatever you want your choices to be, seperated by a comma; in this instance, Yes,No,Don't know

Make sure the box, "In cell drop-down" is ticked.

I hop this helps,

Regards,

Simsy

  Simsy 18:11 10 Mar 2005

crude animation, (an animated .gif file), showing the process click here

Regards,

Simsy

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

See the work of famous artists playing with toys

iPad Pro 10.5in (2017) review

Comment faire une capture d’écran sur un Mac ?