Trying to open a Word or Excel file off the network share we kept getting a message saying the file was locked for editing by another user and it asked if you'd like to open a read only copy. Here's the fix: Change Word (or Excel) options (File -> Options -> Trust Center -> Trust Center …
Category: excel
Feb 01
Doing math on a selection of cells in Excel
Why do I keep forgetting this? To do math on a selection of cells in Excel (like making all the numbers negative for example) type the new number in a blank cell (-1 for this example), copy it select the cells you want to do the math to pick paste special pick the correct math …