Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default CTRL+SHIFT+) is not working in Excel 2007

Hi,

I am using Office 2007 on Vista machine.

When i am using CTRL+0, the excel columns are getting hide. But when i am
using CTRL+SHIFT+), my hided columns are not showing up.

If there is any workaround, please let em know
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,501
Default CTRL+SHIFT+) is not working in Excel 2007

Hi,

This hasn't changed in E2007. To Hide as you correctly say hold CTRL and tap 0
To unhide you have to select the columns either side of the hidden column(s)
then CTRL+Shift +0

Mike

"Nagender Rathi" wrote:

Hi,

I am using Office 2007 on Vista machine.

When i am using CTRL+0, the excel columns are getting hide. But when i am
using CTRL+SHIFT+), my hided columns are not showing up.

If there is any workaround, please let em know

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default CTRL+SHIFT+) is not working in Excel 2007

Hi Mike,

Thanks for replying

But my CTRL+Shift +0 is not working to unhide the hidden column(s).

Any workaround?


"Mike H" wrote:

Hi,

This hasn't changed in E2007. To Hide as you correctly say hold CTRL and tap 0
To unhide you have to select the columns either side of the hidden column(s)
then CTRL+Shift +0

Mike

"Nagender Rathi" wrote:

Hi,

I am using Office 2007 on Vista machine.

When i am using CTRL+0, the excel columns are getting hide. But when i am
using CTRL+SHIFT+), my hided columns are not showing up.

If there is any workaround, please let em know

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default CTRL+SHIFT+) is not working in Excel 2007

Does your SHIFT key work for other functions or shortcuts?


Gord Dibben MS Excel MVP

On Wed, 23 Dec 2009 07:20:01 -0800, Nagender Rathi
wrote:

Hi Mike,

Thanks for replying

But my CTRL+Shift +0 is not working to unhide the hidden column(s).

Any workaround?


"Mike H" wrote:

Hi,

This hasn't changed in E2007. To Hide as you correctly say hold CTRL and tap 0
To unhide you have to select the columns either side of the hidden column(s)
then CTRL+Shift +0

Mike

"Nagender Rathi" wrote:

Hi,

I am using Office 2007 on Vista machine.

When i am using CTRL+0, the excel columns are getting hide. But when i am
using CTRL+SHIFT+), my hided columns are not showing up.

If there is any workaround, please let em know


  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default CTRL+SHIFT+) is not working in Excel 2007

yes my SHIFT key works for other functions or shortcuts

"Gord Dibben" wrote:

Does your SHIFT key work for other functions or shortcuts?


Gord Dibben MS Excel MVP

On Wed, 23 Dec 2009 07:20:01 -0800, Nagender Rathi
wrote:

Hi Mike,

Thanks for replying

But my CTRL+Shift +0 is not working to unhide the hidden column(s).

Any workaround?


"Mike H" wrote:

Hi,

This hasn't changed in E2007. To Hide as you correctly say hold CTRL and tap 0
To unhide you have to select the columns either side of the hidden column(s)
then CTRL+Shift +0

Mike

"Nagender Rathi" wrote:

Hi,

I am using Office 2007 on Vista machine.

When i am using CTRL+0, the excel columns are getting hide. But when i am
using CTRL+SHIFT+), my hided columns are not showing up.

If there is any workaround, please let em know


.



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default CTRL+SHIFT+) is not working in Excel 2007

I cannot replicate the problem.

C + S + 0 works for me.

Out of guesses assuming you do select columns before and after as Mike
suggested.


Gord

On Thu, 24 Dec 2009 01:15:01 -0800, Nagender Rathi
wrote:

yes my SHIFT key works for other functions or shortcuts

"Gord Dibben" wrote:

Does your SHIFT key work for other functions or shortcuts?


Gord Dibben MS Excel MVP

On Wed, 23 Dec 2009 07:20:01 -0800, Nagender Rathi
wrote:

Hi Mike,

Thanks for replying

But my CTRL+Shift +0 is not working to unhide the hidden column(s).

Any workaround?


"Mike H" wrote:

Hi,

This hasn't changed in E2007. To Hide as you correctly say hold CTRL and tap 0
To unhide you have to select the columns either side of the hidden column(s)
then CTRL+Shift +0

Mike

"Nagender Rathi" wrote:

Hi,

I am using Office 2007 on Vista machine.

When i am using CTRL+0, the excel columns are getting hide. But when i am
using CTRL+SHIFT+), my hided columns are not showing up.

If there is any workaround, please let em know


.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
in excel, pressing shift+ctrl+arrow no longer works? any idea why excel user Excel Worksheet Functions 1 August 12th 09 03:04 PM
Excel 2007: Ctrl+PgUp or Ctrl+PgDn with Protected Sheets DrDave Excel Discussion (Misc queries) 1 July 28th 08 04:12 AM
2007 - Column unhide in Excel does not work i.e. "Ctrl+shift+)" MikeElstonJones Excel Discussion (Misc queries) 3 November 28th 07 12:42 PM
why dont shift+arrow or ctrl+arrow work in 2007 Naguib Excel Discussion (Misc queries) 1 July 24th 07 04:40 PM
Why doesn't CTRL+SHIFT+[ARROW] work 2 highlight in Excel 2003?! Euan Excel Discussion (Misc queries) 1 August 3rd 05 01:29 PM


All times are GMT +1. The time now is 08:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"