LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 27
Default Changing Font Size Doesn't Allow More Text to Fit in Cell

I'm starting a journal using excel and the 10+ Journaling format I learned
about on the web (ie: one page is for todays date, the workbook contains
sheets for each day of the month. Each worksheet has room for 10 years...
Ultimately, the full page will contain entries for Todays date - Dec 4
2008-2018, and there will be one page for each day of the year).

Anyway... I created one worksheet, and copied it 31 times to create a
Master, which I will use for each new month.

I merged 4 rows per year/block (merged several columns as well).

The problem is that on some pages, I can type 4 lines of text, but most
pages will only accept 3 lines of text.

Changing the size of the font does not change how much text I can put in the
merged cell, I still get the ###### error, no matter how small I make the
font.

I can't use "Shrink to Fit" in the format option, it's greyed out.

I'd prefer to use a consistent font on the entire page, rather than
switching to a smaller font occassionally. So far, I've just been editing my
content to make it fit, but sometimes a few more words would be nice.

Any suggestions or help?
I can't imagine why changing the size of the font doesn't fix the problem.

Sorry so long,

TIA
 
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
Changing Font color based on font type or size John Excel Discussion (Misc queries) 2 February 7th 08 12:50 AM
Change all text one font size up with various font sizes used. omchrystal New Users to Excel 2 March 6th 07 09:01 PM
Changing font size of drop down box linked to cell gharris172 Excel Discussion (Misc queries) 1 January 30th 06 01:06 PM
How to sent for cell: font size=7,text format in VBA netx Excel Discussion (Misc queries) 1 August 8th 05 06:50 PM
Changing font size in a list box [email protected] Excel Discussion (Misc queries) 1 December 21st 04 04:07 PM


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

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

About Us

"It's about Microsoft Excel"