![2011 2011](/uploads/1/2/5/4/125412038/371280643.jpg)
In this Article: On Windows On Mac Community Q&A References This wikiHow teaches you how to remove a macro from a Microsoft Excel spreadsheet. You can do this from within the spreadsheet's settings in Excel on both Windows and Mac computers.
Undo the last action This shortcut is a very basic but extremely useful shortcut. Have you ever been working on something and accidentally pressed the wrong key, erasing everything in a split second? After this brief tutorial you’ll be able to reverse this error in less time than it took to make it. This shortcut relies on an error or mistake to occur.
For this example I am going to have a cell with data in it, which I “accidentally” delete. I have a basic AutoSum formula in the active cell, adding up 55 + 77.
Now I “accidentally” press a random key. My AutoSum formula is replaced with z. Have no fear! This is where our shortcut comes in handy.
With a simple 2 key shortcut, “command” + “Z”, the cell will be reverted back to its previous state. ⌘Z And the AutoSum formula is back without any questions!
![Recycle Recycle](/uploads/1/2/5/4/125412038/833002826.png)
This shortcut is extremely useful when you are zooming through a Microsoft Excel spreadsheet and have no time to take your hands off the keyboard. It is useful even in a casual environment when the shortcut is simply easier than finding the Undo button in the toolbar. Whatever your application for the shortcut is, I have no doubt you will be using it often.
Excel for Office 365 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007 To apply several formats in one step, and to make sure that cells have consistent formatting, you can use a cell style. A cell style is a defined set of formatting characteristics, such as fonts and font sizes, number formats, cell borders, and cell shading. To prevent anyone from making changes to specific cells, you can also use a cell style that locks cells. Microsoft Office Excel has several built-in cell styles that you can apply or modify. You can also modify or duplicate a cell style to create your own, custom cell style. On the Home tab, in the Styles group, click the More dropdown arrow in the style gallery, and at the bottom of the gallery, click New Cell Style. In the Style name box, type an appropriate name for the new cell style.
Click Format. On the various tabs in the Format Cells dialog box, select the formatting that you want, and then click OK. Back in the Style dialog box, under Style Includes (By Example), clear the check boxes for any formatting that you do not want to include in the cell style. Note: A duplicate cell style and a renamed cell style are added to the list of custom cell styles. If you do not rename a built-in cell style, the built-in cell style will be updated with any changes that you make. To modify the cell style, click Format.
On the various tabs in the Format Cells dialog box, select the formatting that you want, and then click OK. In the Style dialog box, under Style Includes, select or clear the check boxes for any formatting that you do or do not want to include in the cell style.
Note: A duplicate cell style and a renamed cell style are added to the list of custom cell styles. If you do not rename a built-in cell style, the built-in cell style will be updated with any changes that you make. To modify the cell style, click Format. On the various tabs in the Format Cells dialog box, select the formatting that you want, and then click OK. In the Style dialog box, under Style Includes, select or clear the check boxes for any formatting that you do or do not want to include in the cell style.