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 MoreFilter as You Type Search Box in Excel
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 MoreCreate Standard Deviation Error Bars in an Excel Chart
This video will show you how to add standard deviation error bars to an Excel chart.
This type of chart displays the mean value for each data set: here I have used a column chart. The size of the error bars indicate the standard deviation within the data set. Download the… Read More