One big column with no column label

Dad.neo · May 5th, 2002, 10:08 AM

A family member found that after she saved a file and returned to it, the file had only one huge A column with no column labels (A, B, C, etc.). When one scrolls to the right the column labels appear in one of those status msgs in the lower right corner, but the display of the worksheet nevere even displays the A label. The expected data in the A column is presented, but because none of the columns B ... Z, etc. appear, none of the data in those columns appear.
I keep looking for some accidental resetting of an option, but with no luck. The user is a novice and might very well have responded to some pop-up selection without understanding the consequences.

Has anyone ever seen this? /Dad.neo

Chris Davison · May 5th, 2002, 10:15 AM

is there a big "Page 1" anywhere in grey text ?

Anne Troy · May 5th, 2002, 10:17 AM

Have you tried hitting ctrl-end? That should take you to the last used cell.

Any number of things could have occurred. Here's what I'd try, in this order:

Ctrl-a to select entire sheet. Keep it selected throughout, or hit Ctrl-a again to select it all before performing each step.

Format-Columns, Unhide
Format-Columns, Set width to 9
Format-Rows, Set height to 13
Set to Change font color to black
Change alignment to left-aligned
Format-Cells, Alignment tab, uncheck Merge cells

Hmmm...did I forget anything?

Dad.neo · May 5th, 2002, 10:17 AM

Like, the view was stuck in the "Pabe Break View"? No.

Chris Davison · May 5th, 2002, 10:19 AM

okie dokie

all yours Dreamboat

Dad.neo · May 5th, 2002, 10:20 AM

Like it was stuck in "Page Break View" ? No.

Dad.neo · May 5th, 2002, 10:21 AM

I'll try Dreamboat's approach and post result. It will be later today.

Dad.neo · May 5th, 2002, 01:16 PM

Quote:

On 2002-05-05 09:21, Dad.neo wrote:
I'll try Dreamboat's approach and post result. It will be later today.

Well, you won't believe this!

I noticed that the IE Browser wasn't painting the whole page too and thought that there might be something hosed in the RAM. So, we rebooted and ... all data in Excel sheets returned to view!

Thanks to all suggestors ...never argue with success.

-Peace,
Dad.neo

Anne Troy · May 5th, 2002, 01:18 PM

Hey, Dad?

If the problem returns, or other weird problems with your PC occur, try cleaning up the hard drive:

http://www.thewordexpert.com/cleanyourpc.htm

May 5th, 2002, 10:17 AM	#3
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Have you tried hitting ctrl-end? That should take you to the last used cell. Any number of things could have occurred. Here's what I'd try, in this order: Ctrl-a to select entire sheet. Keep it selected throughout, or hit Ctrl-a again to select it all before performing each step. Format-Columns, Unhide Format-Columns, Set width to 9 Format-Rows, Set height to 13 Set to Change font color to black Change alignment to left-aligned Format-Cells, Alignment tab, uncheck Merge cells Hmmm...did I forget anything? __________________ ~Anne Troy

May 5th, 2002, 01:18 PM	#9
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Hey, Dad? If the problem returns, or other weird problems with your PC occur, try cleaning up the hard drive: http://www.thewordexpert.com/cleanyourpc.htm __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 5th, 2002, 10:08 AM	#1
Dad.neo New Member Join Date: May 2002 Posts: 5	A family member found that after she saved a file and returned to it, the file had only one huge A column with no column labels (A, B, C, etc.). When one scrolls to the right the column labels appear in one of those status msgs in the lower right corner, but the display of the worksheet nevere even displays the A label. The expected data in the A column is presented, but because none of the columns B ... Z, etc. appear, none of the data in those columns appear. I keep looking for some accidental resetting of an option, but with no luck. The user is a novice and might very well have responded to some pop-up selection without understanding the consequences. Has anyone ever seen this? /Dad.neo

May 5th, 2002, 10:15 AM	#2
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	is there a big "Page 1" anywhere in grey text ?

May 5th, 2002, 10:19 AM	#5
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	okie dokie all yours Dreamboat

May 5th, 2002, 10:20 AM	#6
Dad.neo New Member Join Date: May 2002 Posts: 5	Like it was stuck in "Page Break View" ? No.

May 5th, 2002, 10:21 AM	#7
Dad.neo New Member Join Date: May 2002 Posts: 5	I'll try Dreamboat's approach and post result. It will be later today.