Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ctl Page Up and Ctl Page Down work selectively
I just received a workbook, and on the first sheet I can press Ctl page down
and navigate to the next worksheet. However, on all the other sheets, this same action (or Ctl page up) does not change sheets, but shifts me left or right, like I had clicked on the horizontal scroll bar. I have examined all the settings in Tools, Options (using excel 2003), but do not see anything different between the sheets. New sheets act normal - I can shift from one new sheet to the other via key strokes. The sheets which do not work normal have had their sheet tabs colored and contain () in the names as they are copied sheets. Removing the color and renaming does not solve. Copying to a new workbook does not solve. There are no hidden or very hidden sheets in the workbook. The workbook and sheets are not protected. There are no macros in the workbook Any ideas? Bob |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ctl Page Up and Ctl Page Down work selectively
Hi Bob,
CTRL+Page not working is normally caused by the worksheet having been protected and only unlocked cells being selectable. I know you said the sheets were not protected but have you checked the setting via Tools Protection. As some cells will be editable. What version of xl are you using? Cheers Andy Bob Flanagan wrote: I just received a workbook, and on the first sheet I can press Ctl page down and navigate to the next worksheet. However, on all the other sheets, this same action (or Ctl page up) does not change sheets, but shifts me left or right, like I had clicked on the horizontal scroll bar. I have examined all the settings in Tools, Options (using excel 2003), but do not see anything different between the sheets. New sheets act normal - I can shift from one new sheet to the other via key strokes. The sheets which do not work normal have had their sheet tabs colored and contain () in the names as they are copied sheets. Removing the color and renaming does not solve. Copying to a new workbook does not solve. There are no hidden or very hidden sheets in the workbook. The workbook and sheets are not protected. There are no macros in the workbook Any ideas? Bob -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ctl Page Up and Ctl Page Down work selectively
Andy, that was it. I had assumed the sheet was unprotected as I could
modify cells. Why would the protection status of a sheet change how ctl-pageup and down work? Is this a feature or a bug? Looks like a bug.... Bob "Andy Pope" wrote in message ... Hi Bob, CTRL+Page not working is normally caused by the worksheet having been protected and only unlocked cells being selectable. I know you said the sheets were not protected but have you checked the setting via Tools Protection. As some cells will be editable. What version of xl are you using? Cheers Andy Bob Flanagan wrote: I just received a workbook, and on the first sheet I can press Ctl page down and navigate to the next worksheet. However, on all the other sheets, this same action (or Ctl page up) does not change sheets, but shifts me left or right, like I had clicked on the horizontal scroll bar. I have examined all the settings in Tools, Options (using excel 2003), but do not see anything different between the sheets. New sheets act normal - I can shift from one new sheet to the other via key strokes. The sheets which do not work normal have had their sheet tabs colored and contain () in the names as they are copied sheets. Removing the color and renaming does not solve. Copying to a new workbook does not solve. There are no hidden or very hidden sheets in the workbook. The workbook and sheets are not protected. There are no macros in the workbook Any ideas? Bob -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ctl Page Up and Ctl Page Down work selectively
A bug rather than a feature.
Although I can not locate any pages detailing the problem. Cheers Andy Bob Flanagan wrote: Andy, that was it. I had assumed the sheet was unprotected as I could modify cells. Why would the protection status of a sheet change how ctl-pageup and down work? Is this a feature or a bug? Looks like a bug.... Bob "Andy Pope" wrote in message ... Hi Bob, CTRL+Page not working is normally caused by the worksheet having been protected and only unlocked cells being selectable. I know you said the sheets were not protected but have you checked the setting via Tools Protection. As some cells will be editable. What version of xl are you using? Cheers Andy Bob Flanagan wrote: I just received a workbook, and on the first sheet I can press Ctl page down and navigate to the next worksheet. However, on all the other sheets, this same action (or Ctl page up) does not change sheets, but shifts me left or right, like I had clicked on the horizontal scroll bar. I have examined all the settings in Tools, Options (using excel 2003), but do not see anything different between the sheets. New sheets act normal - I can shift from one new sheet to the other via key strokes. The sheets which do not work normal have had their sheet tabs colored and contain () in the names as they are copied sheets. Removing the color and renaming does not solve. Copying to a new workbook does not solve. There are no hidden or very hidden sheets in the workbook. The workbook and sheets are not protected. There are no macros in the workbook Any ideas? Bob -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ctl Page Up and Ctl Page Down work selectively
Hi
Old bug that I report a few times in betas, I not think it will be fixed. -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Andy Pope" wrote in message ... A bug rather than a feature. Although I can not locate any pages detailing the problem. Cheers Andy Bob Flanagan wrote: Andy, that was it. I had assumed the sheet was unprotected as I could modify cells. Why would the protection status of a sheet change how ctl-pageup and down work? Is this a feature or a bug? Looks like a bug.... Bob "Andy Pope" wrote in message ... Hi Bob, CTRL+Page not working is normally caused by the worksheet having been protected and only unlocked cells being selectable. I know you said the sheets were not protected but have you checked the setting via Tools Protection. As some cells will be editable. What version of xl are you using? Cheers Andy Bob Flanagan wrote: I just received a workbook, and on the first sheet I can press Ctl page down and navigate to the next worksheet. However, on all the other sheets, this same action (or Ctl page up) does not change sheets, but shifts me left or right, like I had clicked on the horizontal scroll bar. I have examined all the settings in Tools, Options (using excel 2003), but do not see anything different between the sheets. New sheets act normal - I can shift from one new sheet to the other via key strokes. The sheets which do not work normal have had their sheet tabs colored and contain () in the names as they are copied sheets. Removing the color and renaming does not solve. Copying to a new workbook does not solve. There are no hidden or very hidden sheets in the workbook. The workbook and sheets are not protected. There are no macros in the workbook Any ideas? Bob -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I work on one page without seeing other pages | New Users to Excel | |||
Rows to repeat on every page does not work? | Excel Discussion (Misc queries) | |||
Page setup doesn't work | Excel Discussion (Misc queries) | |||
page break doesn't work. Help is no help. Help? | Excel Discussion (Misc queries) | |||
why doesn't ctrl+page down work? | Excel Discussion (Misc queries) |