HOW DO I MAKE A BIG X APPEAR IN A CELL THAT IS NOT IN USE?

G

Guest

I WANT A BIG X OR SLASH/ TO APPEAR IN PLACE FOR WHEN I'M NOT USING A CELL FOR
DATA...HOW TO DO THIS???
 
D

Don Guillett

I find that shouting very loud always helps. Typing in all CAPS is
considered to be shouting and not proper netiquette here.

Perhaps a bit more information might also help.
 
E

ed

I WANT A BIG X OR SLASH/ TO APPEAR IN PLACE FOR WHEN I'M NOT USING A CELL FOR
DATA...HOW TO DO THIS???
Click to expand...

Type an X or whatever you want in an unused cell. Use Fomat/Font to
make it as big as you want. Copy it to the other unused cells. When
you enter data in the cell the big X will be replaced with the data.

More appropriate would be to use Conditional Formatting. Type the
following formula in the Conditional formula space in cell B2 =B2=""
and then choose bright red, or light blue or solid black for a
pattern. Using the format brush, copy B2 to all the cells you want
so indicated. The advantage to Conditional Formatting is that when
you erase the data the pattern format will return.

ed
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

when pressing forward slash key numbers appear below headings 2
Slash as first character in a cell 2
How do I make a zero appear with a slash 4
Checkbox Next to Mail Message - How Do I Make It Visible? How Do I Make a Check Appear? 1
How to Stream from Xbox One Series X to NVIDIA Shield? 2
Excel Typed text appears in wrong cell 0
Symbols in a cell 1
Include a value from one cell within text of another cell. 2

Top