Category Archive: excel

May 13

Read only copy when opening Word file from network share

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 …

Continue reading »

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 …

Continue reading »