Join Early Retirement Today
Reply
 
Thread Tools Display Modes
How to paste a spreadsheet
Old 09-29-2009, 12:18 PM   #1
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
haha's Avatar
 
Join Date: Apr 2003
Location: Hooverville
Posts: 22,983
How to paste a spreadsheet

How can I copy and paste the values displayed on a spreadsheet to a forum page?

I am trying to illustrate the food labeling problem that I mentioned yesterday.

Ha
__________________
"As a general rule, the more dangerous or inappropriate a conversation, the more interesting it is."-Scott Adams
haha is offline   Reply With Quote
Join the #1 Early Retirement and Financial Independence Forum Today - It's Totally Free!

Are you planning to be financially independent as early as possible so you can live life on your own terms? Discuss successful investing strategies, asset allocation models, tax strategies and other related topics in our online forum community. Our members range from young folks just starting their journey to financial independence, military retirees and even multimillionaires. No matter where you fit in you'll find that Early-Retirement.org is a great community to join. Best of all it's totally FREE!

You are currently viewing our boards as a guest so you have limited access to our community. Please take the time to register and you will gain a lot of great new features including; the ability to participate in discussions, network with our members, see fewer ads, upload photographs, create a retirement blog, send private messages and so much, much more!

Old 09-29-2009, 12:22 PM   #2
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
REWahoo's Avatar
 
Join Date: Jun 2002
Location: Texas: No Country for Old Men
Posts: 50,004
Unless you post it as a screen shot I think you'll have to do it as a table: http://www.early-retirement.org/forums/f32/tables-in-posts-46405.html
__________________
Numbers is hard
REWahoo is offline   Reply With Quote
Old 09-29-2009, 12:32 PM   #3
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
haha's Avatar
 
Join Date: Apr 2003
Location: Hooverville
Posts: 22,983
Quote:
Originally Posted by REWahoo View Post
Unless you post it as a screen shot I think you'll have to do it as a table: http://www.early-retirement.org/foru...sts-46405.html
Thanks. Can you tell me the screen shot technique? Maybe that is easier.

Ha
__________________
"As a general rule, the more dangerous or inappropriate a conversation, the more interesting it is."-Scott Adams
haha is offline   Reply With Quote
Old 09-29-2009, 12:39 PM   #4
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
REWahoo's Avatar
 
Join Date: Jun 2002
Location: Texas: No Country for Old Men
Posts: 50,004
Here is a "Blast from the Past" describing the technique (saving a screen shot as a jpg file): How to post a screen shot
__________________
Numbers is hard
REWahoo is offline   Reply With Quote
Old 09-29-2009, 01:59 PM   #5
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
RonBoyd's Avatar
 
Join Date: Dec 2007
Location: Denver, Colorado
Posts: 6,256
CFB was so ahead of his times.

I use Vista's Snipping tool exclusively -- and simply ignore the red border.. As in this:

attachment.JPG

Does the Red X mean what I think it means?
__________________
"It's tough to make predictions, especially when it involves the future." ~Attributed to many
"In theory, there is no difference between theory and practice. But, in practice, there is." ~(perhaps by) Yogi Berra
"Those who have knowledge, don't predict. Those who predict, don't have knowledge."~ Lau tzu
RonBoyd is offline   Reply With Quote
Old 09-29-2009, 04:16 PM   #6
Moderator Emeritus
Martha's Avatar
 
Join Date: Feb 2004
Location: minnesota
Posts: 13,228
Where is Vista's snipping tool?
__________________
.


No more lawyer stuff, no more political stuff, so no more CYA

Martha is offline   Reply With Quote
Old 09-29-2009, 04:29 PM   #7
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
RonBoyd's Avatar
 
Join Date: Dec 2007
Location: Denver, Colorado
Posts: 6,256
Start/Accessories/Snipping Tool.

Or in my case (after programming my MS Ergonomic Keyboard 4000) it is found at "My Favorites" button #5.

Be sure to try (or, at least, look at) all of the "preferences."
__________________
"It's tough to make predictions, especially when it involves the future." ~Attributed to many
"In theory, there is no difference between theory and practice. But, in practice, there is." ~(perhaps by) Yogi Berra
"Those who have knowledge, don't predict. Those who predict, don't have knowledge."~ Lau tzu
RonBoyd is offline   Reply With Quote
Old 09-29-2009, 04:34 PM   #8
Moderator Emeritus
Martha's Avatar
 
Join Date: Feb 2004
Location: minnesota
Posts: 13,228
Thanks.
__________________
.


No more lawyer stuff, no more political stuff, so no more CYA

Martha is offline   Reply With Quote
Old 09-29-2009, 08:35 PM   #9
Recycles dryer sheets
heyduke's Avatar
 
Join Date: Aug 2009
Posts: 348
you can also just very simply use this... shift PRT SCR and that copies your screen to memory and then open something up like word and paste it in (Control V or right click the mouse and select paste).
heyduke is offline   Reply With Quote
Old 09-29-2009, 10:11 PM   #10
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
RonBoyd's Avatar
 
Join Date: Dec 2007
Location: Denver, Colorado
Posts: 6,256
Quote:
Originally Posted by heyduke View Post
you can also just very simply use this... shift PRT SCR and that copies your screen to memory and then open something up like word and paste it in (Control V or right click the mouse and select paste).
A "Screen" capture is not the same (nor as useful) as a "Selective" capture.
__________________
"It's tough to make predictions, especially when it involves the future." ~Attributed to many
"In theory, there is no difference between theory and practice. But, in practice, there is." ~(perhaps by) Yogi Berra
"Those who have knowledge, don't predict. Those who predict, don't have knowledge."~ Lau tzu
RonBoyd is offline   Reply With Quote
Old 09-29-2009, 10:33 PM   #11
gone traveling
 
Join Date: May 2008
Posts: 3,864
I usually do ctrl/prnt scrn, and then paste it into powerpoint- that way you can use the picture toolbar to quickly crop, resize, etc. Then save as a .jpg picture and you should be good to go.

This may be a bit neanderthal, but it works for me...
Westernskies is offline   Reply With Quote
Old 09-30-2009, 07:37 AM   #12
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
donheff's Avatar
 
Join Date: Feb 2006
Location: Washington, DC
Posts: 11,318
Quote:
Originally Posted by RonBoyd View Post
A "Screen" capture is not the same (nor as useful) as a "Selective" capture.
The snipping tool sounds much more useful than a screen capture and edit. I found a version for XP called Snippy. I wish you could just paste the snip into the text body of the post but you have to save it and attach. Here is a snip:
Attached Images
File Type: jpg SNIPPY.JPG (47.3 KB, 0 views)
__________________
Idleness is fatal only to the mediocre -- Albert Camus
donheff is offline   Reply With Quote
Old 09-30-2009, 07:44 AM   #13
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
donheff's Avatar
 
Join Date: Feb 2006
Location: Washington, DC
Posts: 11,318
Shift+drag makes a rectangular section. Right click allows you to save as a jpg:
Attached Images
File Type: jpg sip.jpg (32.9 KB, 0 views)
__________________
Idleness is fatal only to the mediocre -- Albert Camus
donheff is offline   Reply With Quote
And for Mac users...
Old 09-30-2009, 08:14 AM   #14
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
 
Join Date: Sep 2005
Location: Northern IL
Posts: 26,821
And for Mac users...

The key-combo:

Command-Shift-3 will take a screen shot

Command-Shift-4 will take a selective screen shot, just click/drag over the area you want.

You get a nice old-fashioned "camera shutter" sound for feedback. Each saves it as a file to your desktop, named sequentially. Those commands have been consistent across every version of the Mac going back into the previous century.


Here's a few more tips/tricks from the HELP section (I didn't know or forgot about the control key to go direct to clipboard).


Quote:
Screen shots are saved as files on the desktop. If you want to put the screen shot in the Clipboard (rather than create a file) hold down the Control key when you press the other keys. You can then paste the picture into a document.

When you're selecting an area after after pressing ⌘-Shift-4, you can modify the selection by doing one of the following:


To move the selection rectangle, hold down the Space bar.


To constrain the selection rectangle horizontally or vertically, hold down the Shift key.


To resize the selection rectangle around the center of the selection, hold down the Option key.
-ERD50
Attached Images
File Type: png Picture 14.png (113.1 KB, 3 views)
ERD50 is online now   Reply With Quote
Old 09-30-2009, 08:25 AM   #15
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
RonBoyd's Avatar
 
Join Date: Dec 2007
Location: Denver, Colorado
Posts: 6,256
What I earlier called "Preferences" is actually "Options." Clicking on that gives a few choices among which are "Always copy snip to Clipboard" and "Prompt to save snips."

The "Save" screen allows for several formats and is much easier than embedding it in a third program.

I did find that you can't use Snipping to capture itself. I also found, by re-visiting the "Options" menu, that I could get rid of that pesky red outline by changing the color.

Snipping Snip.JPG
__________________
"It's tough to make predictions, especially when it involves the future." ~Attributed to many
"In theory, there is no difference between theory and practice. But, in practice, there is." ~(perhaps by) Yogi Berra
"Those who have knowledge, don't predict. Those who predict, don't have knowledge."~ Lau tzu
RonBoyd is offline   Reply With Quote
Old 09-30-2009, 10:43 AM   #16
Moderator Emeritus
Martha's Avatar
 
Join Date: Feb 2004
Location: minnesota
Posts: 13,228
I am kind of dense with computer stuff. How do you take snip you just made and put it in a message here?
__________________
.


No more lawyer stuff, no more political stuff, so no more CYA

Martha is offline   Reply With Quote
Old 09-30-2009, 11:39 AM   #17
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
donheff's Avatar
 
Join Date: Feb 2006
Location: Washington, DC
Posts: 11,318
Quote:
Originally Posted by Martha View Post
I am kind of dense with computer stuff. How do you take snip you just made and put it in a message here?
You save the snip as a jpg image and then attach the image file using the paper clip icon on the top tool bar of the reply to thread/editing box.
__________________
Idleness is fatal only to the mediocre -- Albert Camus
donheff is offline   Reply With Quote
Old 09-30-2009, 11:49 AM   #18
Moderator Emeritus
Martha's Avatar
 
Join Date: Feb 2004
Location: minnesota
Posts: 13,228
Quote:
Originally Posted by donheff View Post
You save the snip as a jpg image and then attach the image file using the paper clip icon on the top tool bar of the reply to thread/editing box.
I think I have it. I didn't do the save part. Which is a nuisance.
Attached Images
File Type: jpg Capture.JPG (30.5 KB, 0 views)
__________________
.


No more lawyer stuff, no more political stuff, so no more CYA

Martha is offline   Reply With Quote
Old 09-30-2009, 01:03 PM   #19
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
RonBoyd's Avatar
 
Join Date: Dec 2007
Location: Denver, Colorado
Posts: 6,256
Quote:
Originally Posted by Martha View Post
I think I have it. I didn't do the save part. Which is a nuisance.
Okay, I'll bite. How did you do it without creating a jpg (or whatever) image? I have never been able, for example, to accomplish this procedure with the "cut & paste" method.
__________________
"It's tough to make predictions, especially when it involves the future." ~Attributed to many
"In theory, there is no difference between theory and practice. But, in practice, there is." ~(perhaps by) Yogi Berra
"Those who have knowledge, don't predict. Those who predict, don't have knowledge."~ Lau tzu
RonBoyd is offline   Reply With Quote
Old 09-30-2009, 01:05 PM   #20
Moderator Emeritus
Martha's Avatar
 
Join Date: Feb 2004
Location: minnesota
Posts: 13,228
My message wasn't clear. I tried cut and paste and it didn't work. I had to save the image and then attach the saved image.
__________________
.


No more lawyer stuff, no more political stuff, so no more CYA

Martha is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Tracking basis with spreadsheet, how to structure the spreadsheet? bamsphd FIRE and Money 13 08-03-2009 09:31 AM
spreadsheet nnkrealtor Other topics 4 09-18-2005 03:01 PM
How do I paste a photo? brewer12345 Other topics 40 03-22-2005 12:14 PM

» Quick Links

 
All times are GMT -6. The time now is 06:14 PM.
 
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2024, vBulletin Solutions, Inc.