Shortcut keys in Excel

  Publisher 20:26 08 Mar 2005

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?


  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.


  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.


  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!



  Publisher 13:52 09 Mar 2005

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


  Dirty Dick 13:50 10 Mar 2005

... 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.

  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,



  Simsy 18:11 10 Mar 2005

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



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

Elsewhere on IDG sites

Honor 9 Lite review

18 Best Adult Colouring In Books 2018

HomePod review

Les meilleures séries Netflix (2018)