I’m a fan of Google Docs and Google Spreadsheets. I love having access to important spreadsheets and documents from ANYWHERE. I also use Microsoft Excel for more advanced spreadsheets that Google can’t handle yet.
I am a big fan of the “Paste Special” Option that you get when you right click in excel. It lets you paste just the values of cells and not the formatting. I just now discovered how to use the Google Spreadsheets equivalent of this function.
It’s not a full featured as EXCEL’s paste special function, but it gets the job done when you want to just paste just your values or just your formatting.
1. Cut or Copy your values
2. Click on the “Paste Button / Icon”. It’s on the edit tab. It looks like a little clipboard with a piece of paper on it.
3. Three options will appear: PASTE, PASTE VALUES ONLY, and PASTE FORMAT ONLY.
4. Select the one you want! Viola!
Where are you finding the “Paste Button” (little clipboard). This is not visible in google docs, nor are you able to paste from google docs–you need to paste from your browser.
Are you using a mac and google docs?
When you are in Google Spreadsheets, select “Edit” from the drop down menu and you will see 3 options: Paste, Paste Format Only, and Paste Values Only.
I am doing this from a PC with Google Spreadsheets.
I did notice that there isn’t a comparable feature in Google Documents. It appears that you have to do all the pasting from the right click menu from the mouse or with keyboard commands. I get an this error whenever I try to use the Paste feature from the “Edit” drop down menu:
“Your browser does not allow access to your computer’s clipboard.
Instead, please use Ctrl-C for Copy, Ctrl-X for Cut and Ctrl-V for Paste,
or use Edit menu above the browser toolbar.”