Excel 2007 guru needed

[marine]

Hey folks, question for the excel geeks here.

i have an excel sheet open, and I go to a Word doc, select all, copy and then want to paste it inside a single cell in the excel file.

in older versions of excel i was able to just double click the cell i wanted, and then paste all the text right in. By locking the row height, i was able to keep the cell at its original size and only the first few words of the text i pasted in would appear. I could then double click on the cell and a window would pop with the entire block of pasted text.

When i try to do this in excel 2007, the full window doesn't appear - it is only as wide as the regular size of the cell/column.

how can i fix this?

*easier way to explain it ----
I copy a person's resume from their Word doc. want to paste it in the excel cell and keep it that nice small size. So that if someone wants to actually see the resume, they can just double click on that cell and the entire resume will pop up.

 

[bsucards]

can you just set the row height that you want it to be. Not sure why you would put a resume in excel either, never heard of such a thing

 

[marine]

Its not for one resume.
Imagine a sheet 100 rows deep. Each column has different info for a person.. location, salary, clearance, etc. I want to embedded the resume. For each person as well. But. I don't want rows that are 40 inches tall.

 

[Woodson]

Sounds like something useful for HR or a technical recruiter.

You can protect the height and width of box. I'm not familiar with 2007 but in 03 you can go to format, and unclick WRAP TEXT and it will resolve your autosizing issue.

For the mouse over expand functionality I have used "double click On Cell Event" in the past.

Good luck.

 

[marine]

Sounds like something useful for HR or a technical recruiter.

You can protect the height and width of box. I'm not familiar with 2007 but in 03 you can go to format, and unclick WRAP TEXT and it will resolve your autosizing issue.

For the mouse over expand functionality I have used "double click On Cell Event" in the past.

Good luck.

it's a pretty handy tool. especially when there are unique skills/themes to be able to sort by - like military branches of security clearance levels, or the rank they were.

had a database in excel with over 1700 rows/candidates. going across i had about 14 different columns of identifying categories (navy/army/usmc, logistics, pilots, rangers, etc) to be able to drill down and find exactly what you were looking for... like an army colonel that was in the infantry.
and bam, you could find them in 3 clicks.

i also had each of their resumes embedded in a cell in their row.
someone browsing the whole list could mouseover the cell and bring up the whole resume if they wanted to see more - OR, they could do a key word search thru the entire database and the candidate's resumes were searched.

switched from excel 03 to excel 07 and now i've lost that feature. and it's making my life miserable.

 

[dawgball]

I just tried this in 2007. It's a little junkier, but it is still possible.

Double click then paste. Your row height will reset (if you don't have it locked for entire document). Right click on the rwo number and click Row Height. 15 is the standard size.

The next part is jankier as well. Instead of just mousing over the name, you will need to double click the name. This will expose all of the text. When you pull the focus off of that cell, it will return to just showing the person's name.

Hope this helps.

 

[marine]

I just tried this in 2007. It's a little junkier, but it is still possible.

Double click then paste. Your row height will reset (if you don't have it locked for entire document). Right click on the rwo number and click Row Height. 15 is the standard size.

The next part is jankier as well. Instead of just mousing over the name, you will need to double click the name. This will expose all of the text. When you pull the focus off of that cell, it will return to just showing the person's name.

Hope this helps.

Correct. when you do it, how wide is the column?
i can do all of that and make it work. the problem is, the column (not row) does not widen out - it remains at the standard column width.
i want the column to show up much wider.

 

[dawgball]

Correct. when you do it, how wide is the column?
i can do all of that and make it work. the problem is, the column (not row) does not widen out - it remains at the standard column width.
i want the column to show up much wider.

Same situation here. Sorry I couldn't be of more assistance.