Question about Microsoft Excel for PC

1 Answer

In Excel I have page breaks and wish to hide some pages but when printing the hidden pages print as blank pages and print preview jumps from page before and page after but includes the hidden page num

Hidden page breaks

Posted by Anonymous on

Ad

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

    Governor:

    An expert whose answer got voted for 20 times.

  • Expert
  • 156 Answers

Don't put anything in blank pages, not even a space, now select the pages those you want to print and print selection.
It must help you out

It will locate all error containing cells, now rectify the error save it reopen in excel to see if problem is solved.

Posted on Sep 16, 2017

Ad

4 Suggested Answers

6ya6ya

6ya staff

  • 2 Answers

SOURCE:

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Anonymous

  • 82 Answers

SOURCE: Excel Print Preview does not match printing

dear, go into the print setting .

Posted on Sep 25, 2007

Anonymous

  • 2 Answers

SOURCE: In Print Preview my booklet looks like it will

rint Preview my booklet looks... Solve In Print Preview my booklet looks like it will print correctly. When I print my book the 1st page of the 2nd half of the book prints on top of the last page of the 1st half of the book. I have tried

Posted on Sep 11, 2009

Joe Alphonso

  • 2 Answers

SOURCE: print preview makes excel 2007 stop working

The Smart Technologies Notebook Version 11 software certainly seems to be the culprit. Taking the cue from Bob Cochran, this is what is what I did and the problem has stopped. Open Excel and click on the Office button at the top left. Then Click on Excel options. Click on Add-ins. In the "Manage" window, select COM Add-ins and click Go. In the COM Add-ins window uncheck SMARTInk-Excel-All and click OK and "poof" problem gone!!!

Posted on Nov 02, 2012

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Remove page breaks in excel


We would appreciate if you share with us your Excel version as well so that we can give you a more specific solution to your issue. In the meanwhile, you can refer to the following steps to delete a manually-inserted page break in Excel 2007, Excel 2010, or Excel 2013:

(Important: You cannot delete page breaks that Excel has added automatically. Adding manual page breaks, changing the page orientation, or adjusting column widths and row heights may affect automatically-inserted page breaks.)

1. Select the worksheet that you want to modify.
2. Go to "View" tab, then go to "Workbook Views" section, and click "Page Break Preview".
(Note: You can also click "Page Break Preview " on the status bar)
(Important: If you get the "Welcome to Page Break Preview" dialog box, click "OK". To avoid seeing this dialog box every time you go to "Page Break Preview" view, select "Do not show this dialog again" check box and click "OK".)
3. Now do one of the following:
a) To delete a vertical page break, select the column to the right of the page break that you want to delete.
b) To delete a horizontal page break, select the row below the page break that you want to delete.
(Note: You cannot remove automatic page breaks)
4. Go to "Page Layout", then go to "Page Setup" section, and click "Breaks"
5. Click "Remove Page Breaks"
(Important: You can also remove a page break by dragging it outside of the page break preview area {to the left or right for vertical page breaks, or up or down for horizontal page breaks}. If you cannot drag page breaks, make sure that the drag-and-drop feature is enabled. To check the status of your drag-and-drop feature, click office button , click "Excel Options" tab, click "Advanced", go to "Editing Options" and make sure you have checked the "Enable fill handle and cell drag-and-drop" option.)

To refer to a pictorial explanation of the above steps, you can refer to "Delete a manually inserted page-break" section on the following Microsoft Support Page:
http://office.microsoft.com/en-in/excel-help/remove-a-page-break-HA102576899.aspx?CTT=1

GuruAid.com

Jun 22, 2014 | Computers & Internet

1 Answer

Prints blank page


Have you checked the print que
Printer problems can be a real hassle.
From time to time, due to document layout or settings on your computer, in your software of choice, or even on your printer, a blank page may get "printed" with the rest of your document.
Fortunately, this issue is a simple one to troubleshoot.
Click "Print Preview" when you are finished with your document and ready to print.
Observe your document.
If you see an extra, blank page, you have created a second page.
To delete the second page, close Print Preview, go back into the document and eliminate any blank lines in your documents that you may not need.
You may also find an inadvertent page break at the end of your document.
Place your cursor on its symbol and delete it.
Locate the symbol by clicking on the Show Formatting paragraph icon in the toolbar.


Circumvent this "ghost page" if you do not see a second (or additional) blank page in Print Preview.

Specify the number of pages you wish to print, within the Print dialogue box.
This is typically done by selecting the "Print From" option, then entering the page numbers desired.
If your document happens to be ten pages (without, of course, that final blank page), then enter in the "Print From" field the numbers "1-10".
This will print only pages 1 through 10, without an eleventh (blank) page.


Jul 11, 2013 | HP Deskjet 5940 Photo InkJet Printer

1 Answer

I can't print an Excel spreadsheet on Office for Mac 2011 on my new HP Office jet 8600 printer. The preview is blank! I have check the HP settings & all is in order,i think. Help!


if your printer is already, click file -> print, then do you hear the voice from printer. if not, your printer is not boot.
and you said your preview is blank. you not load the page with content. I guess you don't have the right to print it.
by the way, if you forgot the office password, visit this site to know how office password recovery

Apr 20, 2013 | HP OfficeJet Office Equipment & Supplies

1 Answer

Tray 1 is pulling more than one page at a time, How do I fix this Problem?


try this
are you printing a word document or excel file? for example check how many pages are having a data then try to delete some blank page at the bottom of your file. then do the page preview before you print again
thanks for using Fixya

May 31, 2011 | Computers & Internet

1 Answer

I guyz. my hp officejet printer works very fine as in you send document to the printer but the most amazing thing is that afetr printing and you discover there is no ink on the printer page. Please...


Hello

Before actually printing your report, use the Print Preview function to see how it will look. If there are blank pages, you will see them in Print Preview.

To use the Print Preview function, simply open the report, click on the "File" menu and choose "Print Preview" from the file menu. You will then see your report just as it will look on the printed page.

Scroll through the report for blank pages. If you see blank pages, it is an indication that the data on the report is wider than the paper you are using. You can use your printer properties to change the size of the paper if you wish. If you have access to legal-size paper, you may be able to print the report on the larger paper. If legal-size paper is not an option, you will need to adjust the margins so that the blank pages are eliminated.

To adjust the margins of your report, click on the "File" menu and choose "Page Setup" from the drop-down box. Go to the Margins tab and adjust the margins as needed. It may take a bit of experimentation to get the margins just right; toggling back and forth between Print Preview and Page Setup will make the process faster and easier.

Click on the "Page" tab and choose either portrait or landscape orientation. Changing the orientation to landscape may allow all the fields to print on the same page, thus eliminating the blank pages and saving your paper.

Nov 05, 2010 | HP OfficeJet d145 InkJet Printer

1 Answer

My printer will not print Excel worksheets, charts, or Access tables. It will only print Word documents from the XP,2003 computers in my class. It prints fine from my new computer Vista, 2007. What can I...


Try to do a print preview from excel.
What you see is what you should get since word is working properly.

If the print preview is leaving stuff out, you need to modify the page layout in page setup

Mar 24, 2010 | Brother HL 5170DN Laser Printer

2 Answers

Excel print preview problem - the margin does not work


Be sure to apply Service pack 3 for Excel 2000.

Also, be sure to have selected the correct printer for printing before or during print preview.
An incorrectly recognized printer could cause problems.
Try reinstalling your printer driver. If your printer is a USB printer, unplug the USB, wait a moment and plug it back it (This reloads the printer driver)
More information like printer model, service pack installed for Excel2000, what exactly is the margin doing, things like that, can help me diagnose.

Mar 21, 2010 | Microsoft Excel 2000 Step by Step...

1 Answer

I am unable to print excel spreadsheet - no facility to remove grid lines and as a result it wants to print a small spreadsheet into 666 pages


I can see the page in excel with data i want to print but when i want to see the print preview or print the page, i am unbale to access the page. some fixed pages crops up for print preview or on printing the page

Nov 26, 2009 | Kodak EASYSHARE Plus Series 3 Thermal...

1 Answer

In Print Preview my booklet looks like it will print correctly. When I print my book the 1st page of the 2nd half of the book prints on top of the last page of the 1st half of the book. I have tried...


rint Preview my booklet looks... Solve In Print Preview my booklet looks like it will print correctly. When I print my book the 1st page of the 2nd half of the book prints on top of the last page of the 1st half of the book. I have tried

Sep 11, 2009 | Microsoft Office Professional 2007 Full...

1 Answer

LaerJet 5p Extra page prints with code


check all your application.(word, Excel) by going into print preview, you might have a single black page at the begining. ( this happens when you save the templete with a blank page.)

if that is not, let me know. got to go one step at atime.

Oct 28, 2008 | HP LaserJet 5p Printer

Not finding what you are looking for?

Open Questions:

See all Microsoft Excel for PC Questions

Microsoft Excel for PC Logo

Related Topics:

137 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Ekse

Level 3 Expert

13434 Answers

Alun Cox

Level 3 Expert

2679 Answers

ThaMp3Doctor
ThaMp3Doctor

Level 3 Expert

8597 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...