Renaming rows and columns

O

Osyris

I was wondering if there is a way to mask the names or the rows and
columns (at the top...A B C...and the side...1 2 3... into something
like "Reports" or a different letter/number) but I still want the
proper names to be what formulas and macros reference.

The reason why is that I have a sheet that many users will be using and
i have merged the sensitive cells onto each other, so at the top, the
lettering goes, A B C D E F G H I R S T U V etc. and I don't want
anybody wondering what is there and unmerging the cells and damaging
the formulas.

Thank You!
 
T

Tom Ogilvy

The best you could do is hide the row and column labels, then in row1 and
column 1, format the cells to look like the labels you want.
 

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

Array with many cells from a row but not in order or together 11
Advice on multiple macros, same code just a different column 9
Border formatting row of cells 22
Move data from first 7 rows from one column A into multiple Columnsthen the next 7 rows 2
Single column to multiple columns 5
Modify working code to expand the output. 5
Resize a row but copy but skip columns I don't want to copy 6
Insert Row also adds formulas and moves cursor 2

Top