Question about Microsoft Excel 2007 Home and Student Edition for PC

1 Answer

Which of the following lets you see and/or modify page breaksthat will occur when the worksheet is printed?

Posted by Anonymous on

Ad

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    Superstar:

    An expert that got 20 achievements.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

  • Microsoft Master
  • 3,957 Answers

Go to the print mode and hit the preview link. The page printout will be shown with dotted lines around it. You can either adjust the margins, or move the spreadsheet material to suit you back in the spreadsheet editing mode.

Posted on Mar 30, 2015

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that 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.
the service is completely free and covers almost anything you can think of.(from cars to computers, handyman, and even drones)
click here to download the app (for users in the US for now) and get all the help you need.
Goodluck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

How to delete a header/footer in excel 2010?


To remove the header or footer text from Excel 2010 worksheet, you can follow the instructions below:
1.Go to "Insert" tab and then go to "Text" section.
2.Click "Header and Footer"
3.Click the left, center, or right header or footer text box at the top or the bottom of your worksheet page.
(Note: Clicking any text box selects the header or footer and displays the "Header and Footer Tools", adding the "Design" tab.)
4.Press "Backspace" or "Delete" on your keyboard.
To know more about removing header and footer, you can refer to "Remove the header or footer text from a worksheet" section on the following Microsoft support page:
http://office.microsoft.com/en-in/excel-help/use-headers-and-footers-in-worksheet-printouts-HP010342991.aspx#BMremoveheaderfootertext

Hope this will help you.

GuruAid.com

Sep 03, 2014 | Microsoft Computers & Internet

Tip

Error Message: Spooler Subsystem App has encountered a problem and needs to...


<p><b>Important:</b><br /> <p><span>This article contains information about how to modify the registry. Make sure to back up the registry before you modify it. Make sure that you know how to restore the registry if a problem occurs. For more information about how to back up, restore, and modify the registry</span><br /> <p><span></span><b>Symptom:</b><br /> <p>When you try to start or stop the Print Spooler service, or when you click Start and then click Printers and Faxes, you may receive the following error message: <br /> <p>Spooler subsystem app has encountered a problem and needs to close.<br /> <p>When you try to print, you may receive the following error message: <br /> <p>Operation cannot be completed.<br /> <p><b>Cause:</b> loadTOCNode(1, 'cause'); <br /> <p>This issue may occur if the correct installation and functionality of a newly installed printer is affected by an existing third-party printer driver or service. <br /><br />For example, this issue may occur if the LexBCE custom printer driver from Lexmark is installed on your computer before you add another printer. <br /> <p><b>Resolution:</b> loadTOCNode(1, 'resolution'); <br /> <span> <p><span>Warning:</span></b><span> Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might result in reinstalling the operating system</span><br /><span> <p> 1.<br /> Start the computer in Safe mode. <br /><br />For additional information about starting your computer in Safe mode, click Start, click Help and Support, type <span>safe mode</span> in the Search box, press ENTER, and then click the Start Windows in Safe mode topic.<br /> 2.<br /> Start Windows Explorer, and then delete all files and folders in the following two folders:<br /> &bull;<br /> c:\windows\system32\spool\printers<br /> &bull;<br /> c:\windows\system32\spool\drivers\w32x86<br /> 3.<br /> Click Start, click Run, type <span>regedit</span> in the Open box, and then press ENTER.<br /> 4.<br /> Navigate to and then click the following registry key: <br /> <p>HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Print\Environment\Windows NT x86<br /> View the list of subkeys. There should be only the following subkeys: <br /> &bull;<br /> Drivers<br /> &bull;<br /> Print Processors<br /> 5.<br /> If there are any keys other than those listed in step 4, follow these steps: <br /> a. <br /> On the File menu, click Export.<br /> b. <br /> In the File Name box, type a descriptive name for this key -- for example, type <span>WindowsNTx86regkey</span> -- and then click Save. <br /><br />You can use this backup of the HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Print\Environment\Windows NT x86 registry key to restore the key if you experience any problems after you complete this procedure.<br /> c. <br /> Delete all keys other than those listed in step 4 .<br /> 6.<br /> Navigate to and then click the HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Print\Monitors registry key. View the list of subkeys. There should be only the following subkeys:<br /> &bull;<br /> BJ Language Monitor<br /> &bull;<br /> Local Port<br /> &bull;<br /> PJL Language Monitor<br /> &bull;<br /> Standard TCP/IP Port<br /> &bull;<br /> USB Monitor<br /> 7.<br /> If there are any keys other than those listed in step 6, follow these steps: <br /> a. <br /> On the File menu, click Export.<br /> b. <br /> In the File Name box, type a descriptive name for this key -- for example, type <span>WindowsNTx86regkey</span> -- and then click Save. <br /><br />You can use this backup of the HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Print\Monitors registry key to restore the key if you experience any problems after you complete this procedure.<br /> c. <br /> Delete all keys other than those listed in step 6. <br /> 8.<br /> Disconnect the printer cable from the computer, and then restart the computer. <br /> 9.<br /> Reconnect the printer cable to the computer, install the printer according to the manufacturer's installation instructions, and then try to print a test page.<br /><br /> <p> <br /></span></span>

on Mar 15, 2011 | Office Equipment & Supplies

1 Answer

How to delete Page breaks in Excel


Move a page break Important To enable dragging of page breaks to another location in a worksheet, make sure that the cell drag-and-drop feature is enabled. If this feature is not enabled, you may not be able to move any page breaks.
To verify that drag-and-drop is enabled, do the following:
Click the File tab.
  1. Under Help, click Options.
  2. In the Advanced category, under Editing options, select the Enable fill handle and cell drag-and-drop check box, and then click OK.
  3. Select the worksheet that you want to modify.
  4. On the View tab, in the Workbook Views group, click Page Break Preview.
    1. za010165475.gif
    2. Tip You can also click Page Break Preview za010181030.gif on the status bar.
    3. Note If you get the Welcome to Page Break Perview dialog box, click OK. To not see this dialog box every time you go to Page Break Preview view, select the Do not show this dialog again check box before you click OK.
  5. To move a page break, drag the page break to a new location.
Note: Moving an automatic page break changes it to a manual page break.

Delete a manually-inserted page break Note 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.
To delete a manually-inserted page break, do the following:
  1. Select the worksheet that you want to modify.
  2. On the View tab, in the Workbook Views group, click Page Break Preview.
za010165475.gif
Tip You can also click Page Break Preview za010181030.gif on the status bar.
Note If you get the Welcome to Page Break Perview dialog box, click OK. To not see this dialog box every time you go to Page Break Preview view, select the Do not show this dialog again check box before you click OK.
  1. Do one of the following:
    • To delete a vertical page break, select the column to the right of the page break that you want to delete.
    • To delete a horizontal page break, select the row below the page break that you want to delete.
Note You cannot delete an automatic page break.

Jul 20, 2014 | Microsoft Excel 2010

1 Answer

Sharp mx 3110n, all settings are at "Plain Paper", when print a worksheet from excel, does not print because settings say "Heavy Paper"


Excel treats each worksheet as a different print job. Make sure each page is set to the type of paper that you want to print on.

Under the Page Setup make sure the type is set for the correct type, as well as in the print driver.

How To Configure Sharp Print Drivers with Installed Options to print...

Oct 21, 2013 | Sharp "MX-3110N Color Copier, Printer,...

1 Answer

Problems printing excel worksheet, does not acknowledge the worksheet, printing icon shows up at bottom but indicates 0 jobs pending


hi....this problem due to your formater card upgrade the firmwere of your printer by taking the test page you will be find there current firmwere verson then go to hp web site & find the upgrade firmwere there & install.it is the known issue of this printer if problem persists pls contact hp

Jul 01, 2010 | HP LASERJET P1005 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

1 Answer

Before printing several worksheets together I cannot pick out one sheet at random and print.


This is driver issue.

Go to the page you want to print. Do a File >Print and from within the driver screen select "Current Page". That should take care of it.

Don

Nov 23, 2009 | Epson Office Equipment & Supplies

1 Answer

Can't print line


Depending on what version of Excel you are using try the following:
The lines are called gridlines
  1. Click the worksheet.

  2. On the File menu, click Page Setup, and then click the Sheet tab.

  3. Select the Gridlines check box.
Note Large worksheets print faster if you do not select the Gridlines check box.

Please rate this solution...Thanks

Mar 24, 2009 | HP Officejet 5610 All-In-One InkJet...

1 Answer

Datamax WS6308 print error in .net


El controlador de Seagull es muy bueno y con muchos parametros, intenta modificar los parametros del spooler. Seagull driver is very good and with many parameters, try to modify the parameters of the spooler. buscar

Nov 24, 2008 | Epson Printer

1 Answer

LINE 100


If Sale Line 100 is an Excel Template then it is simple.

The Templates are just preformatted spreadsheets which are edited just like any other spreadsheet.

If you mean that you are using the Template to create another document but wanting all the fields to be the same as the Invoice then I suggest the following method:

Copy the Template fron Worksheet 1 onto Worksheet 2.

Add and remove any fields that you wnt to add or remove (Prices would be deleted on this copy and the title would be changed from Invoice to Delivery Docket, etc)

Then (on Worksheet 2) in the fields that you want to be the same - click on the cell you want the same Data in and hit the = sign. Then go to Worksheet 1 and Click on the cell that you want the data to be the same. Hit Enter. This will send you back to Worksheet 2 and you will see that any data entered into the cell in Worksheet 1 will now also appear in Worksheet 2.

Repeat this process for all the cells you want copied from worksheet 1.

When you complete the data in Worksheet 1 (the Invoice) all the data selected will automatically appear in the cells selected on Worksheet 2.

Try this on worksheet 2 select cell A1, type =, then open worksheet 1 and select B1. You will be returned to worksheet 2 and the formula in cell A1 will now read =Sheet1!A1. Enter anything into Shhet 1 A1 and you will see that it appears in the appropriate cell on Sheet 2.

When you want to print off the Invoice and the Delivery Docket - you only have to open each Worksheet and hit Print and a copy of each worksheet will be printed giving you an Invoice and a Delivery Docket with the appropriate info on each printout (eg if you exclude prices from the Del. Docket then after completing all the details in the Invoice will create a Del Docket with all the relevant information other than the prices.

Does this answer your question?

Apr 25, 2008 | Computers & Internet

Not finding what you are looking for?
Microsoft Excel 2007 Home and Student Edition for PC Logo

92 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2878 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18407 Answers

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

Answer questions

Manuals & User Guides

Loading...