Question In excel 2007, if I enter any data in an unlocked cell of a protected worksheet,the print function is grayed-out. However, the print function is available if no data is entered in any unlocked cell of the worksheet.
The same worksheet will print normally if opened with excel 2010 and data is entered into those unlocked cells.
How can i print this worksheet in excel 2007?
Answer Hi. Make sure that you have properly edited a cell and that the cursor is still active. (Not in Edit mode with a blinking cursor). What you said should ideally not happen and is not a bug. Upload your file somewhere, if you want me to test it out.
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here
I can answer questions regarding using Excel in general, analytics, macros, VBA, formulae, etc. I try to understand your business requirement, and suggest an effective and efficient method to solve your problem.
Hire me to work on your project at vWorker.com
I have extensively used MS Excel since version 2000 up to 2007 in various business scenarios such as evaluating feasibility of a project or investment, compiling small level database and running metrics on them, formula to manipulate and extract information from unorganized data, forms to use Excel data in external applications, etc. I am a Business Analyst by profession and Excel is a key requirement.
Organizations Coal and Oil, LLC
Education/Credentials MS(IT)+MBA Dual Degree, Bentley University, USA