

What feature lets you apply predefined formatting to cells with one click?ĭo you spend a lot of time formatting data in Excel? If yes, then you may find the AutoFormat option useful in speeding up your formatting work.

Excel has several predefined cell styles that you can apply. To prevent anyone from making changes to specific cells, you can also use a cell style that locks cells. What type of formatting can you do to modify your spreadsheet?Ī cell style is a defined set of formatting characteristics, such as fonts and font sizes, number formats, cell borders, and cell shading. How do I exclude a cell from a sum in Excel?Įxclude cells in a column from sum with formula Select a blank cell for saving the summing result, then enter formula =SUM(A2:A7)-SUM(A3:A4) into the Formula Bar, and then press the Enter key. To reselect any of those cells, hold the Ctrl key again and reselect those cells.Click to deselect any cell or click and drag to deselect a range of cells within a selection.How do you deselect highlighted cells in Excel? You can also right-click any of the selected tabs and choose Ungroup Sheets. To deselect multiple sheets you can just click on any tab that is not in the current selection. To cancel all the selections, select the none option from the select menu or stroke the SHIFT+CTRL+A keys. In the case of no selections, it will not do anything.

To deselect the currently selected tool, select the None option from the Select menu.
