Current Region..Cntrl Asterick

M

ManhattanRebel

When I click in a block of data and hit control asterick, instead of Excel
highlighting that specific block of cells, I get the following message
"cannot create outline". What is causing this problem?
 
J

Jacob Skaria

You must be using XL2007. The short cut to select the current region around
the active cell has changed from Ctrl+ * in 2003 to Shift+Ctrl+*

If this post helps click Yes
 
B

Bernard Liengme

I have to disagree with Jacob. I can select the current region in Excel 2003
and in Excel 2007 with any of these
a) CTRL+* using the number pad's *
b) CTRL+SHIFT+* using the top row * (on the 8 key, so Shift is needed)
c) CTRL + A
best wishes
 
J

Jacob Skaria

Sorry, I am wrong as Bernard mentioned..

For the "problem" mentioned in your query....may be you dont have data in
any of the adjacent cells .
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top