Microsoft Office Questions? Ask a IT Expert for Support ASAP
My name isXXXXX will be happy to assist you today. If you would like me to assist in the future, just include Richard W. in the question title.
Which version of Excel are you using?
Also, you say you "whited out" an area? How did you do this?
Changed the font colour
Changed it to "white"?
Change the font color the protected the worksheet
Changed the font color then protected the worksheet
Okay. Just a moment...
Okay. What you can do is "lock" the cell and you can "hide" the cell. Then, when you protect the sheet, make sure that users cannot select locked cells. If the cells are hidden, then they should not be able to see them.
More info coming...
Here is my quick video demo: http://screencast.com/t/g238Up9z
Please note that we are only compensated for our time helping you and others when our customers click the green "Accept" button. We do not receive a salary from JustAnswer. Also, positive feedback and tips are greatly appreciated! :-)
If you need more info, just reply to this message, and I will be back to help further. :-)
Thanks I wiil try to fix the problem - I am very new to Excel 2010 and find it hard to find the funtions in it. (used to excel XP - sort of.) but 2010 is so much different and hard to find the funtions.
Did my video help? I showed where the functions for locking and hiding cells are found. You already seemed to know how to protect the sheet so I didn't show where I clicked on the screen to bring that up. I just right-clicked on the Sheet1 tab at the bottom left to bring up the context menu.
I tried that but if you goto page break preview, you can still see all the data
Did you use the "hide" option or just the "lock" option.
Did you make sure that when you protected the sheet that you made sure that under "Allow all users of this worksheet to:" you unchecked the "Select locked cells" option?
I used Locked & Hide - users to use only unlocked cells then protected wooksheet? I will try again.
Okay. That should work.
Tried again - can't see cells in normal mode but can still see info in Page Break preview.
Look here: http://screencast.com/t/Ko3f7jaFr8Ml
I am willing to offer more assistance. I have Office 2010 and showed the exact steps to do to hide the information in your worksheet. We need to do some more investigation to figure out why it is not working on you end.
It worked ok on sheet 1 - tried to do the same on sheet 2 -didn't work - tiied a few times - no go??
Okay. Let me try that on my end.
Give me a minute...
It is working fine for me.
Are these old worksheets with an .xls extension?
Or were they converted from xls to xlsx?
They are xlsx sheets. tried going through the same procedure only in page break preview mode & got it to work in sheet 2 & 3. There is another area in sheet 1 that I needed to add to the procedure but it did'nt work???
I will undo the procedure in sheet 1 & redo selecting all the sells at the sme time .
You might try running a repair on your Office installation. I am not having to fight with these features at all to make them work.
You can apply a blanket lock and hide to all cells. If the end user does not need to make any changes, that should be fine.
I have to step away for a minute, but I'll be right back.
I can't undo the procedure? Thanks I'm running out of time at the moment so I will have to give this a miss until I get a chance to try again later. regards Owen.
I know I have given you the correct steps and have answered the question and ahve spent a good deal of time here with you. Please let me know how it goes when you try it again later.
The steps you gave were a bit confusing & didn't work that well.
However I discovered myself the best way was to highlight the columbs that needed to be hiden,
then went to format - visability - Hide columns - then Protected the work sheet.
that seems to work OK.