placeholder

  1. M

    How to create multiple text placeholder that disappears when user click on them

    Hi everyone! I am wondering how to create text placeholders in cells that disappears when users click on them in order to fill with information, like some online form that you have to fill to register some service or account. For example, I have a sheet with a form where I need that users...
  2. Q

    Placeholder

    I am sorry if this has been asked before. I tried to search but did not have any luck. I am looking to have placeholders in an excel spreadsheet for multiple cells and on multiple sheets. I would like to see the very simple thing to help accomplish this. What I am needing is for any cell I...
  3. I

    Is Placeholder text in cell an option ?

    Hi, On my sheet i have two drop down boxes in obviously two different cells. The drop down arrow is not shown until you click the cell so to remind users that it is there "but not always needed to click" i have used a slight grey in color to point this out to them. The thing is now they are...
  4. E

    Formula Question

    Hi, I need help with a formula please! I have an excel sheet with multiple tabs. So on sheet 1 I have all master data and on sheet 2, I break out a section of the data. In the example below, we are looking at the master data and on sheet two, I need to pull all books that have at least one...
  5. L

    Digit placeholder

    Hi I am trying to understand custom excel number format. So I am reading the article below. It says # is digit placeholder.... What does that mean? what does placeholder means here? Thanks https://support.office.com/en-us/article/Number-format-codes-5026bbd6-04bc-48cd-bf33-80f18b4eae68
  6. N

    Search and replace between strings of placeholder text

    Hi guys, how are you all? encountered a big problem and now I am hoping you can help to solve it... So basically to build a register for my book using indexmatic I need a list of the words looking kinda like this: /(wierer)|(Albin Wierer)|(Wierer Albin)/ => Albin Wierer The Names between the...
  7. P

    Add placeholder in last section

    Hi, I've got a list of device names and I need the last section of the name to have 3 digits. Here is a small example: SPT-01-1 SPT-01-20 SPT-01-250 I need: SPT-01-001 SPT-01-020 SPT-01-250 I've tried a couple formatting techniques and watched a couple tutorials on similar problems but...

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
Back
Top