(Tech Tip: Office) How to password protect a Word / Excel document
(Tech Tip: Office) How to password protect a Word / Excel document
Microsoft Office documents can be protected in several ways.
Opening the document requires a password (via Save As)
Modifying the document requires a password (via Save As)
Note: There is another area that offers template-style protection (via the Review tab) that only protects changing certain cells or sheets from modification.
(Tech Tip: Excel) Suppress 0 values
<span style="font-size:smallTo hide values (text or numeric) that have a 0
<
Bad: in general for your Excel sessions (independent of the file)
Tools(menu)… Options(menu)… View(tab)… Window Options(area)... Zero values(checkbox)
Better: You can use a formula such as
=IF(F7=0,"",F7)
Best: You can do it without a formula by formatting the cell with
Format(menu)… Cells(menu)… Number(tab)
Custom: #,###_);
How to get unique names from a list
1. Open file and click on column A (selects the entire column)
2. Then choose Data... Sort and select "header row" (figure 1) and click OK
Now the list is sorted in alpha order
(Tech Tip: Excel) How to get unique names from a list
If you have a list of information and you want to remove duplicates, use Excel and follow these simple steps.
