Normal view does not show Font or cell fill formatting

bawimmer · 04-13-2007, 09:21 AM

Normal view in Excel 2003 does not show Font or cell fill formatting, but when I print preview or print, it displays and prints with all my formatting. I'm sure it's a quick option, but don't know what or where.. Thanks for any help!

**Glaswegian** · 04-13-2007, 12:14 PM

Hi and welcome to TSF.

Try Tools > Options > View tab and make sure the radio button "Show All", about half way down on the left, is selected.

bawimmer · 04-13-2007, 12:22 PM

Thanks Glaswegian... it didn't work.. we actually tried all those settings. It must be something in the user's profile, because when another user (myself and another tech) log in as ourselves, it all works fine. We're just going to back up anything in his profile, delete his profile and rebuild a new one... have to get it done quickly.. he's a high profile user.
Appreciate the response... have a great weekend! time for a glass of wine!

**Glaswegian** · 04-13-2007, 02:58 PM

Hi

Yes, could also be Normal.dot - have a look here

http://www.techsupportforum.com/arti...-problems.html

bawimmer · 04-14-2007, 07:49 AM

Thanks... already directed tech to remove and rebuild user's profile. Didn't realize that the normal.dot had any impact on Excel... I'll have to look at that... (and by the way... don't even know if it's working yet. will have to wait until I go back to work on Monday!)

**Glaswegian** · 04-14-2007, 12:44 PM

Quote:

Originally Posted by bawimmer

Thanks... already directed tech to remove and rebuild user's profile. Didn't realize that the normal.dot had any impact on Excel... I'll have to look at that... (and by the way... don't even know if it's working yet. will have to wait until I go back to work on Monday!)

Oooops! Ignore me - I obviously can't distinguish between Word and Excel these days...

bawimmer · 04-14-2007, 01:28 PM

It's all good... no worries! thanks for trying to help me! I have moments of confusion myself!

ThorneM · 11-26-2009, 01:22 AM

Same problem as previous user
The problem is when the click on the file to open the spreadsheet, Excel 2003 opens and it appears to be a totally blank file but when I click on Print Preview, the information on the spreadsheet is indeed there.
What solution works?

ThorneM · 11-26-2009, 04:18 AM

I solved the problem, the Normal view was zoomed out and pressing control + mouse scroll the screen was resized.

Our Communities

Automotive Communities

RV & Travel Trailer Communities

Marine Communities