This tutorial demonstrates how to automatically protect data immediately after it has been entered in a cell. The steps are: Unlock all cells in the worksheet. To do this select all cells (click in an empty cell and use the shortcut CTRL A to achieve this) Open the Format Cells dialog (CTRL 1 will…Read More
Filter as You Type Search Box These tutorials will enable you to create a search box in Excel that filters a table as you type. Each letter that you type in the search box will automatically be applied to the filter. The first tutorial uses the FILTER function which is available in Excel 365. If…Read More
This video will show you how to add standard deviation error bars to an Excel chart.