Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 279
Default Unhide column difficulty

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,872
Default Unhide column difficulty

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,872
Default Unhide column difficulty

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 279
Default Unhide column difficulty

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
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
Unhide column - why doesn't click unhide column work? H Stevens Excel Discussion (Misc queries) 1 November 15th 07 12:36 AM
hide one column skip two column and unhide one of 11 JLGWhiz Excel Programming 0 January 11th 07 02:59 AM
unhide column A Nanodream Excel Discussion (Misc queries) 3 June 14th 06 09:51 AM
How do I unhide a column when format/column/unhide won't work lincolnblaze Excel Worksheet Functions 1 December 14th 05 03:38 AM
How do I unhide The first column or row ashekumar Excel Discussion (Misc queries) 2 April 10th 05 11:57 AM


All times are GMT +1. The time now is 10:29 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"