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.

04-13-2007, 09:21 AM	#1 (permalink)
bawimmer Registered User Join Date: Mar 2007 Location: Newburgh, NY Posts: 4 OS: xp	EXCEL - Normal view does not show Font or cell fill formatting 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! Last edited by bawimmer; 04-13-2007 at 09:33 AM. Reason: didn't specify Office application

04-13-2007, 12:14 PM	#2 (permalink)
Glaswegian Moderator/ Rangemaster TSF Academy; Analyst, Security Team; Oor Wullie; TSF Surgeon and Resident Comic Join Date: Sep 2005 Location: Glasgow Posts: 28,100 OS: Win XP Pro SP3 / Win 7 Pro My System Blog Entries: 10	Re: Normal view does not show Font or cell fill formatting 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. __________________ Iain - Defender of the Haggis and all things Scottish. I don't help by PM - post in the Forums. PC Safety & Security::PC running a bit slow?::Donate::Photographers Corner

04-13-2007, 12:22 PM	#3 (permalink)
bawimmer Registered User Join Date: Mar 2007 Location: Newburgh, NY Posts: 4 OS: xp	Re: Normal view does not show Font or cell fill formatting 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!

04-13-2007, 02:58 PM	#4 (permalink)
Glaswegian Moderator/ Rangemaster TSF Academy; Analyst, Security Team; Oor Wullie; TSF Surgeon and Resident Comic Join Date: Sep 2005 Location: Glasgow Posts: 28,100 OS: Win XP Pro SP3 / Win 7 Pro My System Blog Entries: 10	Re: Normal view does not show Font or cell fill formatting Hi Yes, could also be Normal.dot - have a look here http://www.techsupportforum.com/arti...-problems.html __________________ Iain - Defender of the Haggis and all things Scottish. I don't help by PM - post in the Forums. PC Safety & Security::PC running a bit slow?::Donate::Photographers Corner

04-14-2007, 07:49 AM	#5 (permalink)
bawimmer Registered User Join Date: Mar 2007 Location: Newburgh, NY Posts: 4 OS: xp	Re: Normal view does not show Font or cell fill formatting 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!)

04-14-2007, 01:28 PM	#7 (permalink)
bawimmer Registered User Join Date: Mar 2007 Location: Newburgh, NY Posts: 4 OS: xp	Re: Normal view does not show Font or cell fill formatting It's all good... no worries! thanks for trying to help me! I have moments of confusion myself!

11-26-2009, 01:22 AM	#8 (permalink)
ThorneM Registered User Join Date: Nov 2009 Posts: 2 OS: XP	Re: Normal view does not show Font or cell fill formatting 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?

11-26-2009, 04:18 AM	#9 (permalink)
ThorneM Registered User Join Date: Nov 2009 Posts: 2 OS: XP	Re: Normal view does not show Font or cell fill formatting I solved the problem, the Normal view was zoomed out and pressing control + mouse scroll the screen was resized.