Printscreen section of Excel spreadsheet

[stirlsa]

How do you print screen a section of an Excel spreadsheet to illustrate a problem that you want help with?

 

[corinereyes]

Hello,

Try to select the area/section that illustrates your problem in excel, press CTRL+C, then open MS Paint, go to Edit menu then click Paste.

Or you can Print Screen the whole Excel window, go to MS Paint, paste it there, select the area you want, go to File menu click New, click Ok, go to Edit then Paste.

 

[erik.van.geit]

Hi,

With the new Boardsoftware you can copy-paste straight from Excel to your message. If you want to display data and formulas, you can still use tools like
HTMLmaker (don't see where the link has gaon, previously it was on each webpage here)
Table-It can generate a table and/or formulalist: see my signature

kind regards,
Erik

EDIT: Corine, nice Avatar!

 

[stirlsa]

Thanks - I had heard about the new software, but when I control C and then paste into the thread, I just get this text that does not line up correctly:

Work Contract Employment Status Contract Type
InTrng/Trl Srv Active Non-Permanent
InTrng/Trl Srv Active Permanent
Probation Active Non-Permanent

 

[stirlsa]

I copied into PAINT and then tried to copy and paste from PAINT into my edit of my thread, but nothing happened.

 

[erik.van.geit]

works quite good for me using IE 6
Work

ContractEmployment StatusContract TypeInTrng/TrlSrvActiveNon-PermanentInTrng/TrlSrvActivePermanentProbation

ActiveNon-Permanent

Are you using another browser? Then try with IE if possible.
Go to the Test forum and have a play with all this. You will find a thread I "bumped up" today.

EDIT:
DOESN'T work anymore for me neighter

 

[stirlsa]

I use IE6.

 

[erik.van.geit]

IE6 like me...

not sure why it doesn't work in this thread for me, but it does in TEST forum
I just tried again: check it out there...

 

[joefrench]

Check out PrintKey 2000 for screen caps (allows you to crop, edit, etc...) and ImageShack to host the screen cap. After hosting the pic at imageshack, copy the urls given for messageboards and paste into your message here at MrExcel.

 

[erik.van.geit]

This opinion is shared by some other MVP's, but anyway it's kinda "common sense". It will probably contain some repeats from previous posts.

• avoid "pictures" of what should be "data": to perform a test, the potential helpers would need to read+type (with inevitable typos) instead of copy+paste
• avoid links: 1. they will die soon (frequently) or late 2. they require to "go somewhere else" for more information I'm not talking about references to other threads providing background information.

• Copy range + Paste within your message "should" work, since the New Board has been installed.
• If the above doesn't work for you, there are tools, which can be used from "within" Excel. A few buttonclicks and you're ready to paste. I am really very happy with Table-it, because it's easy to generate tables and formulalists and simple to get back your stuff to the sheet within the original range! If you want to display formatted data (like colored cells, borders, more fonts), you can use Colo's HTMLmaker or similar tools. (disadvantage: larger bandwidth)

To be clear:

• When I see a thread with a picture instead of data, I'm moving on... (Like threads with unformatted code)
• Same for posts with "check out this file", unless it looks really necessary to test some complicated behaviour. Even then, I would wait to post a link, until someone asks for it. Anyway, an explanation of the problem within the thread is always required.

Hoping to contribute to good communication with this post.

best regards,
Erik