I want to print only selected fields in reports during run time of reports.
Start by looking under FILE, PRINT AREA, SET PRINT AREA
Dear Shailajam,
I will try to copy my actions as I do the requested task.
I have opened the spreadsheet that I want to print only the selected data from.
I left click and hold to drag and highlight the area that I want to print.
I select "FILE" from the upper row of menu items.
I select "PRINT AREA" from the drop down list
I select "SET PRINT AREA" from a choice of two from a list of options.
A very slightly visible dashed boarder appears around the selection of the click and draged area that I want to print.
To change the selection I can go to edit at the top of the menu of the spread sheet and select "UNDO SET PRINT AREA" from the options presented in a drop down list.
THE TRICK is to select what you want to print BEFORE you go to File, Print area, Set print area.
You can select what you want to print by "Click and Drag" for an area or "Select" a cell and then "Shift+Select" for a range of cells or "Select and "Cntrl+Select" for random cells.
Happy to be of assistance.
Please evaluate my assistance even if bad, I can learn from any evaluation.
×
Note:
Default layouts are built against a generic printer. Each printer has its own printable area. As a result, you may have to reset the report to fit the printer. Ideally, if you know the various printers you will be using, you can design the report from the start to fit the printer with the smallest printable area.
79 views
Usually answered in minutes!
I am unable to view the solution.
×