View Full Version : Excel Question - equivalent of Word text box?
Storymama
03-30-2008, 12:11 PM
I have seen Excel spreadsheets that include a text box for expository writing. It sort of floats above the spreadsheet cells, similar to how a chart floats. I have an Excel project due tomorrow and there are some questions I have to answer sentence-style. Last time, I just made some inelegant ginormous cells and typed in those. That satisfied the professor, but I'm thinking there is a nicer way to do this. Anyone?
mirage1
03-30-2008, 12:13 PM
If you pull up the Drawing toolbar (or if it's already there at the bottom of yours) it's the button before the WordArt "A".
That is, if you don't have that freaky new 2007 that I'm still trying to get the hang of at work! :)
Storymama
03-30-2008, 12:18 PM
I have freaky 2007 :p. Your answer was all I needed though, I figured it out! It's on the "Insert" ribbon, as "Text Box." I had a couple false starts, but realized that once I click Text Box, I have to click and drag on the spreadsheet to create the text box. It functions exactly like I'd hoped, thanks!
This was much faster than my online course's discussion board :loveit:!
mirage1
03-30-2008, 12:43 PM
I am appreciating the cool new features of 2007 but it's NOT a good time to have to suss out how to do things that used to be second nature! We moved from one building to another, and had to move all our files to different servers (in other words, every 10 minutes I'm searching around for things that used to be just where I put them last!). I have a brand-new computer which seems to have a glitchy network connection, and just to make it more interesting, for the first whole week my widescreen monitor was showing S-T-R-E-T-C-H-E-D because the video car didn't support the optimum resolution for that monitor (it literally made me nauseous for the first two days, it was that bad!). And finally, we have this shared spreadsheet with handy macros that used to be the brain for all 12 of us to keep track of the status of the 250+ documents we have in process at a time, and going to 2007 has done something extremely bizarre to it--bizarre as in "but I just updated it all yesterday, and hit save, why is it not there now?"
So 2007 is making me crabby. :p I am actually going in to work today to try to sort out what the HELL is wrong with the spreadsheet... we had some people who were still opening it in 2003 for a while and that's when it really started to act oddly, but we have it as an .xlsm file now and it's still weird. I think I'm just going to put the data on a new spreadsheet and recreate the macros in 2007 to see if that helps.
I'm glad you found what you needed!
vBulletin® v3.7.4, Copyright ©2000-2009, Jelsoft Enterprises Ltd.