Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I use Excel 2003 in Vista.
I have a file containing a calendar grid. Each month has a column of day values, aligned with column B (the day of week column) and a column of day data. From the top left corner, I see B EA EB EC ED ... 1 Jan 13 Feb 13 2 Sun 3 Mon 4 Tue 01 1_Jan_13_data 5 Wed 02 2_Jan_13_data 6 Thu 03 3_Jan_13_data 7 Fri 04 4_Ja 01 1_Feb_13_data 8 Sat 05 5_Ja 02 2_Feb_13_data .... Occasionally, I want to see data for Earlier years. When I unhide columns between B and EA, the data for columns C, D, E, .... appears, but I can't use the slider to see to the right of column W. I went searching and found the issue is that I have Freeze Panes set so I can scroll right to see beyond Sep 13. I still can't unhide column A. When I select column B, that column and the row numbers get highlighted. Format/Column/Unhide is ineffective. I would value suggestions on why this might be. I have solved my major difficulty. I am hoping for some light from here on my minor difficulty. ;) -- Walter Briscoe |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi Walter,
Am Sun, 16 Jun 2013 07:58:56 +0100 schrieb Walter Briscoe: I still can't unhide column A. When I select column B, that column and the row numbers get highlighted. Format/Column/Unhide is ineffective. I would value suggestions on why this might be. press CTRL+A to select all cells. Then rightclick on a column header = unhide Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi Walter,
Am Sun, 16 Jun 2013 09:08:09 +0200 schrieb Claus Busch: press CTRL+A to select all cells. Then rightclick on a column header = unhide if column B is visible put the cursor on the left seperator in column header of column B til it becomes a double arrow. Then leftclick an drag to the right. Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
In message of Sun, 16 Jun 2013 09:15:20
in microsoft.public.excel.worksheet.functions, Claus Busch writes Danke, Claus. Hi Walter, Am Sun, 16 Jun 2013 09:08:09 +0200 schrieb Claus Busch: press CTRL+A to select all cells. Then rightclick on a column header = unhide That did not work if column B is visible put the cursor on the left seperator in column header of column B til it becomes a double arrow. Then leftclick an drag to the right. It did not become a double arrow. It did become a width marker. I dragged that to the right and A appeared to the left of where I was dragging. That did it. Thanks for your help. Regards Claus Busch -- Walter Briscoe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Unhide column - why doesn't click unhide column work? | Excel Discussion (Misc queries) | |||
hide one column skip two column and unhide one of 11 | Excel Programming | |||
unhide column A | Excel Discussion (Misc queries) | |||
How do I unhide a column when format/column/unhide won't work | Excel Worksheet Functions | |||
How do I unhide The first column or row | Excel Discussion (Misc queries) |