LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 31st 13, 12:20 PM
Junior Member
First recorded activity by ExcelBanter: Jul 2013
Posts: 1
Default Text overlap and blank cells

Can I make text flow over cells that are blank visually, but contain formulae?

I have an “If” formula that gives the month or nothing (=IF(MONTH(G3)<MONTH(F3),(G3),""). It shows the beginning of each month above a long row of dates and is 'blank' otherwise.

I want the text to flow over adjacent cells, which are very narrow as they are part of a Gantt chart.

I understand that text overlaps blank cells, but it seems not to if the cells have a formula but are visually blank. Is there a way to make “blank” (meaning showing nothing) act like and “blank” (meaning empty cell)?

Last edited by Jaqcov : August 2nd 13 at 10:12 AM Reason: To make problem clearer when browsing topics

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
I would like text to overlap adjacent cell(s) Mike Excel Discussion (Misc queries) 3 December 16th 19 06:45 PM
Force text to overlap Aled Davies Setting up and Configuration of Excel 2 March 3rd 11 11:10 PM
Overlap Cells Vertically without Merging Muffi Zainu[_2_] Excel Discussion (Misc queries) 2 December 8th 09 09:37 AM
Getting text to overlap into other cells Maury Markowitz[_2_] Excel Programming 8 October 5th 08 10:08 AM
Formula Help: Add cells with certain text + cells that are blank Nicole L. Excel Worksheet Functions 3 February 27th 07 06:59 AM

All times are GMT +1. The time now is 02:33 AM.

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

About Us

"It's about Microsoft Excel"


Copyright © 2017