|
-
Nov 23rd, 2012, 07:07 AM
#1
Funny Excel keyboard shortcut
I had an Excel spreadsheet and meant to hit ctrl+tab but hit ctrl+\ instead. Thereafter a number of changes occurred (the appearance changed, columns became larger, cells didn't respond to some format commands, formulas were considered text, etc) but undo was disabled. Anyone knows what that key combination is intended for and how to go back without having to exit without saving and starting Excel back?
Lottery is a tax on people who are bad at maths
If only mosquitoes sucked fat instead of blood...
To do is to be (Descartes). To be is to do (Sartre). To be do be do (Sinatra)
-
Nov 23rd, 2012, 08:48 AM
#2
Re: Funny Excel keyboard shortcut
I cannot find Ctrl+\ in the default Excel shortcuts http://office.microsoft.com/en-us/ex...001111659.aspx
I think it is a shortcut for macro inside the spreadsheet as far as it do such many things!
-
Nov 23rd, 2012, 09:46 AM
#3
Re: Funny Excel keyboard shortcut
 Originally Posted by 4x2y
As a matter of fact, when you hit Alt \ again it reverts to the previous state so it works as a toggle switch, but I couldn't find any information either.
Lottery is a tax on people who are bad at maths
If only mosquitoes sucked fat instead of blood...
To do is to be (Descartes). To be is to do (Sartre). To be do be do (Sinatra)
-
Nov 23rd, 2012, 06:44 PM
#4
Re: Funny Excel keyboard shortcut
Originally Posted by krtxmrtz
As a matter of fact, when you hit Alt \ again it reverts to the previous state so it works as a toggle switch, but I couldn't find any information either.
Could you re-toggle the state afterwards so that the changes were back the the way they were back you hit the toggle switch?
when you quote a post could you please do it via the "Reply With Quote" button or if it multiple post click the "''+" button then "Reply With Quote" button.
If this thread is finished with please mark it "Resolved" by selecting "Mark thread resolved" from the "Thread tools" drop-down menu.
https://get.cryptobrowser.site/30/4111672
-
Nov 23rd, 2012, 11:08 PM
#5
Re: Funny Excel keyboard shortcut
there is one for the /. it's used for selecting array formula ranges. i don't know what \ does.
-
Nov 24th, 2012, 03:15 PM
#6
Re: Funny Excel keyboard shortcut
Originally Posted by Nightwalker83
Could you re-toggle the state afterwards so that the changes were back the the way they were back you hit the toggle switch?
Yes but, if you make some changes after ctrl \ -say you modify the width of a column- then when you toggle back this width has not the original value.
At any rate, try it out by yourself.
I should mention however that I'm using a Spanish keyboard in which the \ character is in the top leftmost key unlike a US keyboard
(see for instance: http://www.wesleyan.edu/CTWMellon/graphics/spankey.jpg)
Last edited by krtxmrtz; Nov 24th, 2012 at 03:20 PM.
Lottery is a tax on people who are bad at maths
If only mosquitoes sucked fat instead of blood...
To do is to be (Descartes). To be is to do (Sartre). To be do be do (Sinatra)
-
Nov 26th, 2012, 10:24 PM
#7
Re: Funny Excel keyboard shortcut
ah. i learned to program on that layout. took me forever to get used to the quotes placement when i got a pc.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote
