In web forms, surveys, and polls, it can be very useful to limit the choices for a selection with a simple drop-down list. This is also possible in an excel spreadsheet, but the process isn't very well known or very intuitive.
In Access, you can limit user entries by forcing users to choose a value from a list control. Office applications use the same functionality in built-in drop-down lists. For instance, the Highlight and Font Color controls on most Formatting toolbars use this flexible tool. Simply click the small triangle to the right of the icon to display a list of choices.
Links between two workbooks are common and useful. But multiple links where values in workbook1 depend on values in workbook2, which links to workbook3, and so on, are hard to manage and unstable. Users forget to close files, and sometimes they even move them. If you're the only person working with those linked workbooks, you might not run into trouble, but if other users are reviewing and modifying them, you're asking for trouble. If you truly need that much linking, you might consider a new design.
Securing data is a tiered process with password protection at the bottom level--the file level. It's a first step effort, but certainly not the only step you should take to protect confidential and proprietary data. Password protecting an Excel workbook at the file level controls access in two ways: It lets a user in, and it lets a user save changes. In this article, I'll show you more than just how to password-protect a workbook. You'll learn what that protection does and doesn't do for you and how to avoid some gotchas.
Before we discuss Excel's password-protection feature, let's clarify what we mean by security. Although the terms security and protection are bantered about interchangeably, feature-wise in Excel, they aren't the same thing. Security lets you choose who gets in and by virtue of doing so, who doesn't. Protection limits users who are already in. Security is about access; protection is about maintaining integrity.
Headers and footers are easy to implement as long as the same text appears on every page in your document. Beyond the basics, this feature often confuses users. The key to working successfully with headers and footers is this: headers and footers belong to sections, not the document or individual pages, and a document can have a unique header or footer for every section.
Comments
Post a Comment