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!