Allen Wyatt's Excel tips

Finding Rows with Values in Two Columns

When you use Excel to input and store information, you need to be concerned with whether the information meets your expectations. For instance, you may want to make sure that each row has a value in only one of two columns, and not in both columns. This tip examines ways you can find where the data doesn't meet this expectation.

Read this ExcelTip: Finding Rows with Values in Two Columns
Microsoft Excel Tips - Learn Excel Faster!

Protecting Individual Worksheets, by User

Excel allows you to protect worksheets, individually. Users can still see that the worksheets are there, but they cannot display them if they don't know the proper password. If you are developing a full-blown application in Excel, you may need a way to completely hide worksheets from users unless they enter their password. This tip explains the steps necessary to implement such a scenario.

Read this ExcelTip: Protecting Individual Worksheets, by User
Microsoft Excel Tips - Learn Excel Faster!

Páginas