Microsoft Office - kamiltech
, , ,

How To: Filter Range of Data in Microsoft Office Excel

Built-in comparison operators such as “greater than” and “top 10” can show the data you want and hide the rest. That’s a big help with large worksheets or when you just want to focus on particular data ranges.Select the data you…
microsoft office excel word power-point
, , ,

How To: Filter Data in Microsoft Office Excel

When you put your data in a table, filtering controls are added to the table headers automatically.For quick filtering, do this:Click the arrow in the table header of the column you want to filter. In the list of text or numbers, uncheck…
microsoft office excel word power-point
, , ,

Unlock specific areas of a protected worksheet in Office Excel

To give specific users permission to edit ranges in a protected worksheet, your computer must be running Microsoft Windows XP or later, and your computer must be in a domain. Instead of using permissions that require a domain, you can also specify…
microsoft office excel word power-point
, , ,

Lock specific areas of a protected worksheet in Office Excel

When you protect a worksheet, all cells are locked by default, which means that they cannot be edited. To enable cells to be edited while leaving only some cells locked, you can unlock all the cells and then lock only specific cells and ranges…
Microsoft Office - kamiltech
, , ,

How To: Protect a Worksheet in Microsoft Office Excel

To prevent other users from accidentally or deliberately changing, moving, or deleting data in a worksheet, you can lock the cells on your Excel worksheet and then protect the sheet with a password. Say you own the team status report worksheet,…
microsoft office excel word power-point
, , ,

How To: Add Pop-up Tool-tip to a Cell in Microsoft Excel

Want a neat trick you can use to make your worksheets more helpful to users? How about adding a pop-up window that displays documentation whenever the cell is selected? To add such a feature, follow these steps:Select the cell for which…