Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Striker475
 
Posts: n/a
Default Trying to achieve defined format with any Excel


The goal is to have a spreadsheet that can have text inserted really
easily and have the cell/textbox/label autosize to the text size, and
have it impossible to insert text behind this so it stays neat.

I am probably going to use a text box to set up the first section...

If it can be done with any version of Office it's okay, but it is
preferrable to get it done with Excel 97 as this is the software in use
at my workplace.

1) Can it be done?

2) If so, how?

3) If not, is it possible to get close to this?


--
Striker475
------------------------------------------------------------------------
Striker475's Profile: http://www.excelforum.com/member.php...o&userid=28690
View this thread: http://www.excelforum.com/showthread...hreadid=484149

  #2   Report Post  
damorrison
 
Posts: n/a
Default Trying to achieve defined format with any Excel

Start with this
when you are in a cell press
Alt,Enter
this will give you a new line to type text in the cell

when you bring up a new text box, use the buttons that help size them,
like shift,alt,ctrl,
check your help file to find out more

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 to 95 File format conversion Judith C Excel Discussion (Misc queries) 3 July 17th 05 04:24 PM
Excel 2003, It wont print in landscape format STEVE665 Excel Discussion (Misc queries) 1 July 12th 05 04:47 PM
Imported Date & Time format with calcs. managed in excel from imrp Todd F. Excel Worksheet Functions 0 July 8th 05 09:03 PM
EXCEL FORMAT PROBLEM WHEN SENDING EXCEL SHEET AS MESSAGE BODY IN . P.S.Sodha Excel Discussion (Misc queries) 0 April 2nd 05 01:53 PM
how to format excel format to text format with separator "|" in s. azlan New Users to Excel 1 January 31st 05 01:57 PM


All times are GMT +1. The time now is 06:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"