Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Print preview doesn't work properly in Excel 2010

23 May 2014   #1
Franky

windows 7 32-bit
 
 
Print preview doesn't work properly in Excel 2010

Hello all,

First I made some contents and drew a border from Home > Font > all Borders on an Excel 2010 file. So it became like below image (capture1). After that I wanted to print it so went to File > Print to see its preview. But the problem is that the lines between tue and wed and also between mon and tue are not shown neither in preview nor when printing. The height of row 7 until 17 is 24 (that is 32 pixel) but heights of the rest of the rows are normal (20 pixel).

Any idea about why those lines aren't shown?




Attached Images
Print preview doesn't work properly in Excel 2010-capture1.png Print preview doesn't work properly in Excel 2010-capture2.png 
My System SpecsSystem Spec
.
24 May 2014   #2
Franky

windows 7 32-bit
 
 

Isn't there any solution!!?
My System SpecsSystem Spec
24 May 2014   #3
Irene

Windows 7 Home Premium 64bit
 
 

A couple of questions:

  1. Do you have any merging in the cells? If so, try removing it.
  2. Is there any reason why you have only changed the height of rows 7 - 14. If not, try formatting the entire spreadsheet. (see below) Apply or remove cell borders on a worksheet - Excel

Quote:
All cells on a worksheet Click the Select All button.

To select the entire worksheet, you can also press CTRL+A.
Note If the worksheet contains data, CTRL+A selects the current region. Pressing CTRL+A a second time selects the entire worksheet.
My System SpecsSystem Spec
.

24 May 2014   #4
Franky

windows 7 32-bit
 
 

No there isn't any merging data.
Look, I copied that form and pasted it into sheet3 (it was in sheet1). And increased the height of rows 7 till 17 from 15 (default) to 25, because reading data from printed paper his way will be more simple and also the amount of data and its format are so much more than this small form (I minimized the form so that finding the solution is simpler). After these works I pressed Ctrl+Z. There isn't any problem with preview!!
So I thought that problem is about something hidden in the background of the range B7 till D17 (the form). Therefore, I returned to sheet1 and selected the entire sheet (from the corner) and clicked on Editing > Clear > clear all. Then I again copied the form from sheet3 (which the preview for it was well) and pasted it to sheet1 (which now is clean apparently!) in range B7 till D17 and then increased rows (7 till 17) to height 25. Then tested it, BUT again I faced that problem, Why please?
My System SpecsSystem Spec
25 May 2014   #5
Irene

Windows 7 Home Premium 64bit
 
 

Try performing a repair:
Repairing a corrupted workbook - Excel
My System SpecsSystem Spec
Reply

 Print preview doesn't work properly in Excel 2010




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
Copying filtered table doesn't work as it is expected in Excel 2010
Hi all, I have a small table and want to copy it after filtering. The image is in below (image no. 1), and I have filtered it to shows only the red font color of the column "Days" as follows, (image no. 2). Now everything is ready to start the copying! So I select all the table (Double CTRL+A...
Microsoft Office
Total row doesn't work properly, Excel 2010
In my Excel 2010 file and in one of its sheets I have a small table. As following, when I checked the Total Row option in Table tools > Design > Table style options > Total Row the tabled appeared as follows. But it is against of the info when I hold the mouse pointer over the Total Row check box...
Microsoft Office
Color not displaying on screen or in print preview in Word or Excel
I am running Windows 7 Home Premium 64bit. I have MS Office Student/Home Edition. After a recent MS automatic update the color display on screen and in print preview suddenly stopped working in Word & Excel. It was working fine prior to the update. I have googled and searched and cannot...
Microsoft Office
Print Preview doesn't match printed document in IE 8 & 9
I'm helping to develop a web application that uses iframes. On the main page (outside of all frames), we have a div that we use to display and print forms. We also have 2 nested iframes; the innermost iframe contains the main page content. When printing, we use extensive CSS and Javascript...
Browsers & Mail
Excel 2010 not responding for 30 second after print options
I have office 2010 which i installed about 6 months ago. I've not used excel since then. I've just started using it and it has some serious issues. It is incredibly slow to do some tasks at which time windows states that the program is not responding. This happens when ever I select a printing...
Microsoft Office
Excel 2007 doesn't work properly with windows 7
I have found several issue on excel now I'm using windows 7. When you select multiple cells, using control, they aren't highlighted. I also have issues with excel crashing all the time, even on relatively small files and running on a 8Gb machine Anyone else having the same issues?
Microsoft Office


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 13:16.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App