MrExcel Message Board


Go Back   MrExcel Message Board > Question Forums > Technical Excel Issues

Technical Excel Issues Technical problems with running Excel - program crashes, freezes, unexpected program behavior, etc.

Reply
 
Thread Tools Display Modes
Old Nov 5th, 2009, 02:59 PM   #1
dj_jay_smith
 
Join Date: Nov 2009
Posts: 4
Default Column and Row heading look wrong!

Hi All,

I have a strange problem. When I create a new workbook the column and row headings look strange. The row heading are too small and you can't see the number. And the columns just don't look right.





What is wrong?

Is must be a setting but I don't know what. I have enabled to view the headings so I am not sure what it is.

Thanks
dj_jay_smith is offline   Reply With Quote
Old Nov 6th, 2009, 09:41 AM   #2
rorya
MrExcel MVP
 
rorya's Avatar
 
Join Date: May 2008
Location: Burwash, East Sussex
Posts: 9,149
Default Re: Column and Row heading look wrong!

Those don't look like real column headings to me - there shouldn't be a row number next to the A for a start. Are you sure you have row and column heading set to display?
__________________
HTH,
Rory

$e = $m$cē - the theory of absolutes.

Microsoft MVP - Excel
rorya is offline   Reply With Quote
Old Nov 6th, 2009, 12:49 PM   #3
dj_jay_smith
 
Join Date: Nov 2009
Posts: 4
Default Re: Column and Row heading look wrong!

Yes. I has double checked.

On the page layout tab Headings is enabled. And on the View tab then headings are also enabled.

The strange thing is that this is only for new blank books. If I open an old book then it look perfectly normal.
dj_jay_smith is offline   Reply With Quote
Old Nov 6th, 2009, 12:57 PM   #4
rorya
MrExcel MVP
 
rorya's Avatar
 
Join Date: May 2008
Location: Burwash, East Sussex
Posts: 9,149
Default Re: Column and Row heading look wrong!

Check in your two XLSTART folders and look for a file called Book.xltx or Book.xlt. If you find one, move it somewhere else and then see if creating a new book still has the same problem.
__________________
HTH,
Rory

$e = $m$cē - the theory of absolutes.

Microsoft MVP - Excel
rorya is offline   Reply With Quote
Old Nov 6th, 2009, 02:02 PM   #5
dj_jay_smith
 
Join Date: Nov 2009
Posts: 4
Default Re: Column and Row heading look wrong!

My XLSTART folder is empty!

I tried creating a Book.xltx in this folder (one which looks OK) but to no avail.


Also I have noticed. If I start up excel, the default new book it opens is OK. It is only when I go to new Blank Workbook that I have the problem.
dj_jay_smith is offline   Reply With Quote
Old Nov 6th, 2009, 02:06 PM   #6
rorya
MrExcel MVP
 
rorya's Avatar
 
Join Date: May 2008
Location: Burwash, East Sussex
Posts: 9,149
Default Re: Column and Row heading look wrong!

There are two XLSTART folders - did you check both? There is also an option in the Excel Options called something like 'At startup open all files in'
If you just press Ctrl+N, does the new workbook look OK?
__________________
HTH,
Rory

$e = $m$cē - the theory of absolutes.

Microsoft MVP - Excel
rorya is offline   Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 10:43 AM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
All contents Copyright 1998-2009 by MrExcel Consulting.