3 tips for perfect print Excel

books online free online library

Do any rows or columns of your spreadsheet are printed on different pages? Want to print the same rows or columns on every page? Just want to print a specific area of the spreadsheet? These are common problems that can be solved with relative ease. So, yes, you can print perfect in Excel.

Adjust the spreadsheet in a personal way is easy:


1.-Open the dialog "Page Setup" document, which can be done from "Preview" tab or the "Page Layout"
2.-In the "Page" dialog box, locate "Scaling"
3.-Customize the scale according to how you print: for example, set it to 1 page wide by 1 page tall print all data on the same page, which can reduce the size of the text, since it must fit into a sheet
4.-Click "OK"

Set the area to be printed
Some things can not see around the world. Perhaps the spreadsheet you're working is confidential information. Choosing what to include in the printed version distributed at the meeting is simple.

To print only part of the worksheet, you must define a print area. Select the cells that make up the print area. In the "Page Layout" in the "Page Setup", click "Print Area" and select "Set Print Area."

Hide data within certain cells is a bit more difficult. Select the cells whose contents you want to hide the source and choose the same color for the background of the cell. The content is hidden. For example, if the cell had a standard white background, change the font color to white. To select multiple cells with the same background color, hold down Ctrl and select the cells.

To achieve the perfect print in Excel, you need not devote much time to change the format, for example. Any of these three simple tips will help you print what you need or want