Forum Discussion
move spaces to a given column via worksheet command
i am 81 yoa and my lady is sickly. Among other things she has type 1 diabetes and heart problems.
I am building a worksheet containing foods and their calories and carbs.
i want to blank out input a column when she has completed her food menu and is done inputting. How can I do that?
I also want to protect all columns in the worksheet except the one for her input.
I am using Microsoft Professional + 2013 Office on a pc via wireless in Windows 11.
can anyone help me? I would be happy to attach a copy of the worksheet but i don't see how!
Thanks in advance!
3 Replies
You can do this easily in Excel without anything advanced. To protect the sheet, select the whole worksheet, open Format Cells, go to Protection, and keep Locked enabled, then select only the column your wife uses and uncheck Locked for that column. After that, go to the Review tab and choose Protect Sheet to lock everything except her input column. When she finishes entering her food, you can simply select that column and press Delete to clear it. If you want it to clear automatically, that would require a macro, but the manual method is the safest and simplest.
- I have made a suggestion to MS to add a 'table entry line'. I actually created this functionality using MS scripts. Not sure if MS scripts was added to your 2013 version. Here is the thread:
https://techcommunity.microsoft.com/t5/excel/table-entry-line/m-p/3920962
