How do I change the default print settings in Excel 2010?
If you want to change the default page margins, you can do so by following these steps:
- Open a new Excel workbook.
- Change the page margins for all the worksheets in the workbook.
- Make any other desired “default” changes in the workbook.
- Choose Save As from the File menu.
Why is my spreadsheet printing so small in Excel 2010?
In the worksheet, click File > Print. Under Settings, click Custom Scaling > Custom Scaling Options. Click Page and in the Adjust to box, choose a percentage by which you want to increase or decrease the font size. Review your changes in Print Preview and—if you want a different font size—repeat the steps.
Why is Excel saying there is a problem with the Clipboard?
The message is apparently caused if you try to use Ctrl+C, Ctrl+X, the Format Painter tool, or a drag-and-drop operation and Excel detects that the Clipboard is locked by a non-Office application or, in some cases, simply accessed a non-Office application. …
Why is Excel not printing all columns?
Step 1: Open the spreadsheet in Excel 2010. Step 2: Click the Page Layout tab at the top of the window. Step 3: Click the Print Area button in the Page Setup section of the navigational ribbon, then click the Clear Print Area button. You should now be able to navigate to the Print menu and print the entire spreadsheet.
What is the Excel default print setting?
For the normal print job, just print, and Excel will default to the Print Area. When you need to quickly print another area, print a selected range.
How do I change printer settings in Excel?
Add a new printer
- In Excel, click File > Print.
- Click the Printer drop-down menu, and click Add Printer.
- In the Find Printers dialog box, type the name of your printer in the Name text box. Click Find Now to search.
- In the search results, select the printer, and click OK.
Why is my Excel spreadsheet printing so many pages?
It could also be that you have horizontal page breaks that you want to keep when you print your spreadsheet. Click the Page Layout tab. Set the Scale to Fit option for Width to be 1 page. Set the Scale to Fit option for Height to be Automatic.
How do you clear formatting in Excel?
Clear Formatting Highlight the portion of the spreadsheet from which you want to remove formatting. Click the Home tab. Select Clear from the Editing portion of the Home tab. From the drop down menu of the Clear button, select Clear Formats.
How do you fix there’s a problem with the clipboard but you can still paste your content within this workbook?
There’s a problem with the clipboard, but you can still paste this content within this workbook. Open Options at the bottom of the menu. There’s a problem with the clipboard, but you can still paste this content within this workbook. Find Enable Live Preview under User Interface Options and uncheck it.