


Provided you are still viewing the document in Print Layout view, you should be able to see any text boxes. Make sure the Show Drawings and Text Boxes on Screen check box is selected.Make sure the Show Picture Placeholders check box is cleared.The advanced options of the Excel Options dialog box. Scroll through the options until you can see the Show Document Content section.Click Advanced at the left side of the dialog box.


In Word 2010 and later versions, click the File tab of the ribbon and click Options.) (In Word 2007 click the Office button and choose Word Options. If the text box is still not visible, then you should check to make sure that the display of drawings hasn't been turned off. If you are viewing your document in some other view, then you won't be able to see some of your graphics, including text boxes. Now, make sure you are viewing your document in Print Layout view. You should make note of any surrounding text or elements that can help you to narrow down where to look in the document itself. This is a simple determination-just look at the printout to see on which page it occurs. First, make sure you know the page on which the text box is located. Vanessa wants to delete the text box and wonders, since she can't see the text box, how she can find it to get rid of it. When she looks at the document on-screen, she can't see the text box or the text it contains. Paste values only: Pastes only the text contained in the original range of cells.When Vanessa prints her document, the printout includes a text box with text in it.By default, the original formatting of the content will stay the same.Paste the content in the same spreadsheet.In a spreadsheet, copy the content you want to paste.You can format the content after you paste it. For example, if you copy a column of cells and use paste transpose, it will paste them into a row, and vice versa. Paste transposed: Pastes a rotated version of the copied cells.Paste conditional formatting only: Only applies conditional formatting rules to a range of cells.Paste data validation only: Pastes a data validation rule over a range of cells without changing existing formatting, formulas, or text.Paste formula only: Pastes the formulas contained in a copied range of cells, not the resulting calculations of the formulas.Paste column widths only: Resizes the selected columns to match the original.Paste all except borders: Pastes everything except cell borders.Paste format only: This option is identical to using the paint format tool - it only copies cell formatting, and won't change existing text or formulas.Paste values only: Pastes only the text from the original range of cells.Copy the data you want to paste and put your cursor in the cell you want to paste into.On your computer, open a spreadsheet in Google Sheets.You can't copy cells from one spreadsheet and use paste special in a spreadsheet open in another tab. Paste special works only within a single spreadsheet. You can use paste special to decide which formatting gets copied when copying cells.
