Solved Word Starter Excel missing some gridlines

bjclark

New member
Member
Local time
12:04 AM
Messages
51
Hi all
I am trying to create a Excel document with Office Starter. However, some of the gridlines disappeared as I was working on it. Note: only some of them. I want to be able to print the gridlines, but they are still missing in print preview. Nothing I have tried has brought it back. Any suggestions would be appreciated. Thanks.
 

My Computer My Computer

At a glance

Windows 7Pentium Dual-Core 2.70GHz6.00 GB
Computer Manufacturer/Model Number
Dell Inspiron 545
OS
Windows 7
CPU
Pentium Dual-Core 2.70GHz
Memory
6.00 GB
Do you have a fill color set? The default is none. The disappearing grid is a common "feature" when a fill color is set but the lines should still print if you have selected print gridlines.

Select the cell range or a single cell and check it there's fill color set.
 

Attachments

  • Grid Lines Disappear.jpg
    Grid Lines Disappear.jpg
    57.6 KB · Views: 0

My Computer My Computer

At a glance

Windows 7 Pro-x64i7-2600 3.4GHz - 3.8GHz Turbo8Gb - 2x4GB, Muskin 991770 PC3-1333Integrated Intel HD 2000
Computer type
PC/Desktop
Computer Manufacturer/Model Number
Built 2/11/2011
OS
Windows 7 Pro-x64
CPU
i7-2600 3.4GHz - 3.8GHz Turbo
Motherboard
Intel DH67BL-B3
Memory
8Gb - 2x4GB, Muskin 991770 PC3-1333
Graphics Card(s)
Integrated Intel HD 2000
Sound Card
Integrated Intel 10.1 HD, RealTek ALC892
Monitor(s) Displays
Asus LCD VH222H, Haier HL24XSL2a
Screen Resolution
1920x1080, 1920x1080
Hard Drives
Crucial SSD C300-128Gb,
Western Digital WD5002AALX - 500Gb,
Western Digital WD7501AALS - 750Gb
PSU
Seasonic 650W 80+ Gold Modular
Case
Rosewill Defender
Cooling
Stock CPU, Four 120mm case fans, PCH fan added
Keyboard
Logitech EX100 Y-RBH94 Wireless
Mouse
Logitech EX100 M-RCE95 Wireless
Internet Speed
3.0/1.5 Mbs
Antivirus
Microsoft Security Essentials
Browser
Microsoft Internet Explorer 11
Other Info
Antec Veris Premier-Multimedia IR Station,
Cyber Accoustics-3602 Speakers,
AFT XM-5U Card Reader,
Hauppauge TV-HVR-2250,
Sony LX300 USB Turntable
Hi carwiz
Thanks for your reply. Unfortunately, I'm not quite sure what you mean.

Select the cell range or a single cell and check it there's fill color set.

Could you try explaining it so this lady (who is not too computer savvy) could understand what to do? Thanks.
 

My Computer My Computer

At a glance

Windows 7Pentium Dual-Core 2.70GHz6.00 GB
Computer Manufacturer/Model Number
Dell Inspiron 545
OS
Windows 7
CPU
Pentium Dual-Core 2.70GHz
Memory
6.00 GB
Each block of the grid is referenced as a cell. You select a single cell by left clicking on it. You select a range of cells by clicking and holding then dragging the highlight until it covers all the cells you want to check. That "it" in my last post should be "if". Sorry. It should read; "...check if there's a fill color set".

After selecting the range, click on the small arrow next to the Fill Bucket in the menu ribbon. A drop down will appear like that shown in the previous image. At the bottom of that drop down, check to make sure the No Fill has a box around it rather than one of the colors above it. Click on the No Fill if it doesn't.
 

My Computer My Computer

At a glance

Windows 7 Pro-x64i7-2600 3.4GHz - 3.8GHz Turbo8Gb - 2x4GB, Muskin 991770 PC3-1333Integrated Intel HD 2000
Computer type
PC/Desktop
Computer Manufacturer/Model Number
Built 2/11/2011
OS
Windows 7 Pro-x64
CPU
i7-2600 3.4GHz - 3.8GHz Turbo
Motherboard
Intel DH67BL-B3
Memory
8Gb - 2x4GB, Muskin 991770 PC3-1333
Graphics Card(s)
Integrated Intel HD 2000
Sound Card
Integrated Intel 10.1 HD, RealTek ALC892
Monitor(s) Displays
Asus LCD VH222H, Haier HL24XSL2a
Screen Resolution
1920x1080, 1920x1080
Hard Drives
Crucial SSD C300-128Gb,
Western Digital WD5002AALX - 500Gb,
Western Digital WD7501AALS - 750Gb
PSU
Seasonic 650W 80+ Gold Modular
Case
Rosewill Defender
Cooling
Stock CPU, Four 120mm case fans, PCH fan added
Keyboard
Logitech EX100 Y-RBH94 Wireless
Mouse
Logitech EX100 M-RCE95 Wireless
Internet Speed
3.0/1.5 Mbs
Antivirus
Microsoft Security Essentials
Browser
Microsoft Internet Explorer 11
Other Info
Antec Veris Premier-Multimedia IR Station,
Cyber Accoustics-3602 Speakers,
AFT XM-5U Card Reader,
Hauppauge TV-HVR-2250,
Sony LX300 USB Turntable
Hi carwiz
Your instructions were easy to understand and the solution worked! Thank you so much!
 

My Computer My Computer

At a glance

Windows 7Pentium Dual-Core 2.70GHz6.00 GB
Computer Manufacturer/Model Number
Dell Inspiron 545
OS
Windows 7
CPU
Pentium Dual-Core 2.70GHz
Memory
6.00 GB
You're welcome. Glad I was able to help.
 

My Computer My Computer

At a glance

Windows 7 Pro-x64i7-2600 3.4GHz - 3.8GHz Turbo8Gb - 2x4GB, Muskin 991770 PC3-1333Integrated Intel HD 2000
Computer type
PC/Desktop
Computer Manufacturer/Model Number
Built 2/11/2011
OS
Windows 7 Pro-x64
CPU
i7-2600 3.4GHz - 3.8GHz Turbo
Motherboard
Intel DH67BL-B3
Memory
8Gb - 2x4GB, Muskin 991770 PC3-1333
Graphics Card(s)
Integrated Intel HD 2000
Sound Card
Integrated Intel 10.1 HD, RealTek ALC892
Monitor(s) Displays
Asus LCD VH222H, Haier HL24XSL2a
Screen Resolution
1920x1080, 1920x1080
Hard Drives
Crucial SSD C300-128Gb,
Western Digital WD5002AALX - 500Gb,
Western Digital WD7501AALS - 750Gb
PSU
Seasonic 650W 80+ Gold Modular
Case
Rosewill Defender
Cooling
Stock CPU, Four 120mm case fans, PCH fan added
Keyboard
Logitech EX100 Y-RBH94 Wireless
Mouse
Logitech EX100 M-RCE95 Wireless
Internet Speed
3.0/1.5 Mbs
Antivirus
Microsoft Security Essentials
Browser
Microsoft Internet Explorer 11
Other Info
Antec Veris Premier-Multimedia IR Station,
Cyber Accoustics-3602 Speakers,
AFT XM-5U Card Reader,
Hauppauge TV-HVR-2250,
Sony LX300 USB Turntable
Back
Top