Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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" wrote in message ... 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? |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Current region emulation | Excel Worksheet Functions | |||
Paste values all cells in a region which refers to out of region | Excel Worksheet Functions | |||
Sort doesn't recognize current region | Excel Worksheet Functions | |||
how do I get rid of blue asterick in create list? | Excel Worksheet Functions | |||
Cntrl + End (xlLastCell) | Excel Discussion (Misc queries) |