Microsoft Office Tutorials and References
In Depth Information
Adding a Lookup Table
5 Enter the table entries in Table 5–4 in the range L3:M7. Select the range L3:M7, click the
Bold button on the Ribbon, and then click the Center button on the Ribbon. Select cell J9
to deselect the range L3:M7 (Figure 5–21).
grade
table
values
Sensitive Information
in a List
If you have a list with
one or more columns of
sensitive information, such
as salary information, you
can hide the columns
by selecting them and
then pressing CTRL +0.
Next, password protect
the worksheet. To view
the hidden columns,
unprotect the worksheet,
select the two adjacent
columns, and then
press CTRL + SHIFT + RIGHT
PARENTHESIS .
grade table
values determine
sales reps’ grades
in column J
Figure 5–21
 
 
Search JabSto ::




Custom Search