Blur Text Under Cell

mamun_ges

New Member
Joined
Jul 21, 2016
Messages
46
Hi,
I searched for the following thought in my head but getting no idea.
I am trying to describe it.

I have a merged cell box from B2:E2
I use this merged box for type which auto filter data as I type.
Now I want to write some information in this search box which will be blur, take no effect on filtering data.
When I start to type the blur text will be gone & whenever I erase the search word the informative word will be back again.

Is it possible? Apricate any feedback.

Thanks in advance
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Taul

Well-known Member
Joined
Oct 24, 2004
Messages
754
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
Hi,
I don't think it can be done with merged cells but there is a work around with an unmerged cell. Assuming your worksheet can be modified to use an un-merged cell?
Add the temporary word you wish to display in the cell to the left. This cell can be made very narrow so it is not too visible (suggest 0.25 width) such that the text is visible in the cell to the right. You can add a ' sign and several spaces before the word to shift it further to the right as you see fit.
There may also be a vba solution but I would have to leave that to someone else.

Good luck,
Paul.
 

Forum statistics

Threads
1,141,075
Messages
5,704,156
Members
421,330
Latest member
imdumb

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top