How do I hide spreadsheet range from data entry?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Specifically, I want to restrict from view a specific range on a sheet where
I have someone entering data ... I need them to enter data into rows which
will create sensitive information in cells below (these I want to hide from
all but original creator) ... any ideas??
 
Set the height to zero, protect the worksheet - or put the output data
onto a hidden worksheet - OR have the sensitive data on another
workbook entirely which REFERENCES the input data.
 
You must log in or register to reply here.

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

Restricting Cell entry to certain letters 7
Excel JUMP FROM SEARCH BAR TO RESULT 3
How do I protect cells or a range of cells in excel spreadsheet? 1
Migrate mailboxes from one Microsoft Exchange Server to another Exchange 2
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Excel EXCEL - using a date dependant formula to hide rows 3
Return value from specific column if not in new column previously 1
Help with my Excel database 4

Back
Top