PC Review


Reply
Thread Tools Rate Thread

Current Region..Cntrl Asterick

 
 
ManhattanRebel
Guest
Posts: n/a
 
      27th Nov 2009
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?
 
Reply With Quote
 
 
 
 
Jacob Skaria
Guest
Posts: n/a
 
      27th Nov 2009
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
---------------
Jacob Skaria


"ManhattanRebel" wrote:

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

 
Reply With Quote
 
Bernard Liengme
Guest
Posts: n/a
 
      27th Nov 2009
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
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP

"ManhattanRebel" <(E-Mail Removed)> wrote in message
news:BAB4C10D-C507-4943-964B-(E-Mail Removed)...
> 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?


 
Reply With Quote
 
Jacob Skaria
Guest
Posts: n/a
 
      27th Nov 2009
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 .

"Jacob Skaria" wrote:

> 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
> ---------------
> Jacob Skaria
>
>
> "ManhattanRebel" wrote:
>
> > 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?

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Current Region in a formula Greg Lovern Microsoft Excel Worksheet Functions 0 2nd Feb 2011 04:58 PM
Cntrl Panel/Sound & Audio Devices/Volume/Play Cntrl John Gregory Windows XP Basics 1 5th Mar 2006 02:01 PM
looping through current region buffyslay Microsoft Excel Programming 2 1st Feb 2006 05:58 PM
Copy Current Region Rohit Thomas Microsoft Excel Programming 1 4th Dec 2003 01:55 AM
Current region problems John T Ingato Microsoft Excel Programming 3 2nd Nov 2003 06:04 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:49 AM.