Excel Magic Trick #7: Clear Formatting Only!
Loading...
Loading...
21,909
Loading...
Link to this comment:
Share to:
Uploader Comments (ExcelIsFun)
see all
All Comments (4)
-
nice video.
-
Dude,
Risk! Risk! aster-RISK
Not Ricks
Loading...
- 1:59
Excel Magic Trick #8: Text To Columnby ExcelIsFun30,432 views
- 3:09
Excel Magic Trick #6: Conditional Formatting for a Rowby ExcelIsFun59,202 views
- 2:56
Excel Magic Trick # 9: Join 2 Cells into 1by ExcelIsFun32,426 views
- 4:16
Excel Magic Trick #5: Data Validation List & VLOOKUPby ExcelIsFun119,933 views
- 10:34
Excel Magic Trick 167p2 IF function formula: 12 Examples!by ExcelIsFun29,229 views
- 8:51
Excel Magic Trick #126: Macro: Advanced Filter Extract Textby ExcelIsFun47,449 views
- 7:55
Excel Magic Trick #130: 3 Dimensional Database in Excelby ExcelIsFun23,408 views
- 7:50
Excel Magic Trick #184: Setup Database in Excelby ExcelIsFun100,776 views
- 9:46
Excel Magic Trick #90: Consolidationby ExcelIsFun47,856 views
- 10:03
Conditional Formattingby AuditExcel4,474 views
- 10:03
The Beauty Of Excel #2: Formulas, Functions & Chartsby ExcelIsFun43,833 views
- 7:58
Excel Lookup Series #1: VLOOKUP Function 1st Exampleby ExcelIsFun319,257 views
- 12:05
Highline Excel Class 26: Fixing Other Peoples Spreadsheetsby ExcelIsFun7,806 views
- 10:27
Mr Excel & excelisfun Trick 23: Excel 2010 New Functionsby ExcelIsFun16,282 views
- 8:05
Excel Magic Trick 534: Conditional Formatting for Weekends and Holidaysby ExcelIsFun25,697 views
- 7:52
Excel Magic Trick # 158: VLOOKUP w 2 Variables As Criteriaby ExcelIsFun20,581 views
- 6:03
Excel Magic Trick #151: DATEDIF function (between two dates)by ExcelIsFun21,280 views
- 5:19
Excel Name Trick #7: INDIRECT function, Names and LOOKUPby ExcelIsFun69,067 views
- 4:52
Excel Magic Trick #139: HYPERLINK function & Drop Down Listby ExcelIsFun35,510 views
- 8:02
Excel Magic Trick #111: Build A Questionnaireby ExcelIsFun25,188 views
Ctrl+E+A+A = Ctrl+E+A+T in excel spanish version.
shiryu008 3 years ago
Dear shiryu008,
Awesome!!! I love it Ctrl EAT!
--ExcelIsFun
ExcelIsFun 3 years ago
Damn. Ctrl E+A+A dosen't work in spanish version1. I got a lot of cuestion to you Mike. is there an option in excel that let you see the key board shortcut of each ribbon button by just pointing the mouose close to the button or something like this?. Thanks a lot
shiryu008 3 years ago
Dear shiryu008,
To Clear all in Excel 2007, go to the Home Ribbon, Editing Group. In 2003, edit menu, Clear, Clear All.
To tuen on Screen Tips that tell you what the keyboard shortcuts are, 2003: right-click any toolbar, point to Customize, then check the box for showing keyborad shorst cuts (I don't have 2003 and I am doing it from memory). In 2007, just point to the icon and the screen tip comes up. Also, try hitting Alt and see what happens
--ExcelIsFun
ExcelIsFun 3 years ago
Dear shiryu008,
It may be that you are not doing it right. Try holding the Alt key (don't let go), then hit E, then A, then A. See if that works.
--ExcelIsFun
ExcelIsFun 3 years ago