Excel and forced return

Excel and forced return

Postby Michel.A_Fr » Sat Feb 01, 2014 5:47 pm

I'm trying to make a shortcut that replaces some text (e.g. _1_) by a forced return. If I type this "forced return" in a Word doc and copy it, I can paste it in Excel, but I'm not able to write the QK shortcut that makes the search-replace and I have no idea how to make it.

Thanks for ideas.
Michel.A_Fr
 
Posts: 3
Joined: Sat Dec 14, 2013 5:21 am

Re: Excel and forced return

Postby gb2 » Mon Feb 03, 2014 9:12 am

you would have to have QuicKeys open the Replace dialog and fill in the fields to do the replace. Something like this for example:

1) Menu Selection - to open Replace
2) Type Text to enter the Find what field info
3) Type Keystroke of tab to go to next field
4) Type Text to enter the Replace with field info
5) Button to press one of the Replace buttons
User avatar
gb2
Site Admin
 
Posts: 2871
Joined: Mon Feb 06, 2006 5:22 pm


Return to QKM General Discussion

Who is online

Users browsing this forum: No registered users and 12 guests

cron