Sometimes there's stuff that you want displayed on screen while using a Microsoft Excel spreadsheet, but you don't want it appearing on printouts.
For example, I use a budgeting spreadsheet that has a number of text boxes with reference text for use while filling in information. I don't want all of that to show up when I print out the budget, though. I also don't want to have to move them outside of the print area, or perhaps delete them temporarily.
Objects such as text boxes, shapes, and pictures all have a setting which dictates whether or not it will print. By default, objects will print. You can go in and change this.
First, you need to bring up the properties. If it's a text box or other shape, right-click it and select 'Format Shape...'. If it's an image, right-click it and select 'Format Picture...'.
From the options on the left-hand side, choose 'Properties' (it's the third from the bottom). Uncheck the checkbox next to 'Print object'. Click the 'Close' button when you're done.
If you ever want the object(s) to print once more, simply repeat those steps and place a checkmark back in that same checkbox.
For example, I use a budgeting spreadsheet that has a number of text boxes with reference text for use while filling in information. I don't want all of that to show up when I print out the budget, though. I also don't want to have to move them outside of the print area, or perhaps delete them temporarily.
Objects such as text boxes, shapes, and pictures all have a setting which dictates whether or not it will print. By default, objects will print. You can go in and change this.
First, you need to bring up the properties. If it's a text box or other shape, right-click it and select 'Format Shape...'. If it's an image, right-click it and select 'Format Picture...'.
From the options on the left-hand side, choose 'Properties' (it's the third from the bottom). Uncheck the checkbox next to 'Print object'. Click the 'Close' button when you're done.
If you ever want the object(s) to print once more, simply repeat those steps and place a checkmark back in that same checkbox.
Thanks for this great post, i find it very interesting and very well thought out and put together. I look forward to reading your work in the future. Rowan Salazar
ReplyDeleteOk, I did all that you said, but the problem was with another thing. I tried to open csv file https://wikiext.com/csv, and nothing gonna work, until I download the right file. All stay good right now. But thank you for your advises.
ReplyDelete