Row height too small-can't change

frant · May 21st, 2002, 04:46 PM

The first row is so small that I cannot see it. Tried to unhide it, that did not work. Tried to auto-height all rows, it still would not show up. Tried to delete the 2nd row and the 1st row. Only 2nd row deleted. Went to edit menu, said goto cell A1 and it would go there, but couldn't unhide or delete from there either. It's the weirdest thing. Any help would be appreciated.

Qroozn · May 21st, 2002, 04:49 PM

Highlight row 2 and drag up to the top of the sheet. now select
format/row/height, and make it 12.

[ This Message was edited by: Qroozn on 2002-05-21 15:56 ]

James · May 21st, 2002, 04:51 PM

Hi Frant,

Keypress Alt F11> Click on the Project Explorer Icon and check all Sheets,UserForms and Modules for code that may be creating this w/ VBA

Regards,
James

frant · May 21st, 2002, 04:56 PM

Still can't unhide the row. Doesn't seem to have any VBA code. When I go to cell A1 and try to insert a row, instead of inserting above cell A1, it inserts below....

PDuPre' · May 28th, 2002, 11:23 AM

GoTo the Window drop down on the menu bar and make sure you do not have Freeze Panes or Split activated. If you don't, it will sat Split and Freeze Panes, otherwise, it will say Remove Split or Unfreeze Panes.

Some of your description sounds like Freeze Panes is on. However, I can insert a line above my Freeze Panes row. So, still a mystery. Drop a line if you discover the cause.

Philip

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

May 21st, 2002, 04:46 PM	#1
frant New Member Join Date: May 2002 Posts: 2	The first row is so small that I cannot see it. Tried to unhide it, that did not work. Tried to auto-height all rows, it still would not show up. Tried to delete the 2nd row and the 1st row. Only 2nd row deleted. Went to edit menu, said goto cell A1 and it would go there, but couldn't unhide or delete from there either. It's the weirdest thing. Any help would be appreciated.

May 21st, 2002, 04:49 PM	#2
Qroozn Board Regular Join Date: Mar 2002 Location: Sydney/Brisbane , Australia Posts: 539	Highlight row 2 and drag up to the top of the sheet. now select format/row/height, and make it 12. [ This Message was edited by: Qroozn on 2002-05-21 15:56 ]

May 21st, 2002, 04:51 PM	#3
James Board Regular Join Date: Feb 2002 Location: Huntington Beach, CA USA Posts: 327	Hi Frant, Keypress Alt F11> Click on the Project Explorer Icon and check all Sheets,UserForms and Modules for code that may be creating this w/ VBA Regards, James

May 21st, 2002, 04:56 PM	#4
frant New Member Join Date: May 2002 Posts: 2	Still can't unhide the row. Doesn't seem to have any VBA code. When I go to cell A1 and try to insert a row, instead of inserting above cell A1, it inserts below....

May 28th, 2002, 11:23 AM	#5
PDuPre' Board Regular Join Date: Apr 2002 Location: Trussville, AL Posts: 134	GoTo the Window drop down on the menu bar and make sure you do not have Freeze Panes or Split activated. If you don't, it will sat Split and Freeze Panes, otherwise, it will say Remove Split or Unfreeze Panes. Some of your description sounds like Freeze Panes is on. However, I can insert a line above my Freeze Panes row. So, still a mystery. Drop a line if you discover the cause. Philip