excel

Question

i need to protect data in a cell that contains a formula. the same formula i need to use the next day ,gut the data in the same row of cells should not change? please help

Anonymous · Answer

You save the data and next day you open the saved data and edit it and then save the edited data in the option save as and store in different name .

I think this might have helped you .

SAM ANDERSON

Tim Babcock · Answer

Highlight the cells you want to format. Move the mouse to the highlighted area, press the right mouse button and make sure the locked option is on under the protection tab.

Make sure protect sheet is enabled. To activate it, press the review under the menu options and select protect sheet (if its on sheet) or workbook for more than one sheet.

Related Topics:

Trustworthy Expert Solutions

Excel i need to protect data in a cell that contains a formula. the same formula i need to use the next day ,gut the data in the same row of cells should not change? please help

2 Answers

Anonymous

Tim Babcock

Add Your Answer

Attachments: Added items

Ask a Question

Check Out the Mobile Browsers Report

Top Microsoft Computers & Internet Experts

Sudeep Chatterjee

Grand Canyon Tech

Brad Brown

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Manuals & User Guides

Related Topics:

Trustworthy Expert Solutions

Excel i need to protect data in a cell that contains a formula. the same formula i need to use the next day ,gut the data in the same row of cells should not change? please help

2 Answers

Anonymous

Tim Babcock

Add Your Answer

Attachments: Added items

Related Topics

Ask a Question

Popular Questions

CSV file to Import correctly into Excel 2003

Indian Rupee format in Excel spreadsheet

How to select all sales entry in tally 9 and how to delete it

Excel file opens in read only mode

Using excel to solve problem by trial and error method