Excel 2019 Bible

Chapter 6: Understanding Excel Files and Templates

6

File-Naming Rules

Excel workbook files are subject to the same rules that apply to other Windows files. A filename can

be up to 255 characters, including spaces. This length enables you to give meaningful names to your

files. You can’t, however, use any of the following characters in your filenames:

\ (slash)? (question mark)

: (colon) * (asterisk)

“ (quote) < (less than)

> (greater than) | (vertical bar)

You can use uppercase and lowercase letters in your names to improve readability, but the filenames

aren’t case sensitive. For example, My 2019 Budget.xlsx and MY 2019 BUDGET.xlsx are equivalent

names.

Password-Protecting a Workbook

In some cases, you may want to specify a password for your workbook. When a user

attempts to open a password-protected workbook, a password must be entered before the

file is opened.

To set a password for a workbook, follow these steps:

1. Choose File ➪ Info and click the Protect Workbook button. This button displays
   some additional options in a drop-down list.


2. Choose Encrypt with Password from the list. Excel displays the Encrypt Document
   dialog box, as shown in Figure 6.3.

FIGURE 6.3

The Encrypt Document dialog box is where you specify a password for your workbook.