MrExcel Excel Videos

Ctrl+5 toggles strikethrough

Use Ctrl+Period to move to next corner of selection.

Using Ctrl+Arrow to jump to the edge of data.

Ctrl+1 to format anything

New feature in Excel provides gentle feedback sounds to let you know that something worked. New feature July 2017 - Provide Feedback with Sounds Choose the Modern Sounds Opening a Pane, Closing a Pane, Autocorrect, Copy, Undo, Redo, Paste, Saving a Document, Deleting Cells, Inserting Cells, Deleting Rows, Deleting Columns

Copy some cells to the clipboard Excel clears the clipboard if you insert rows or columns You have to copy again! Not anymore … Office 365, starting July 2017 They will Keep the Copy If you want the marque to disappear, use Enter to paste Or, after the Paste, press Esc to Cancel the Copy

Superscript and Subscripts were hard to do in Excel June 2017, in response to customer votes on Excel.UserVoice.com there are now two items you can add to your Quick Access Toolbar

Breaking news on a bad recalc bug in Excel. If you ever use RANK or Sort, you could be impacted. Fundamental belief: Excel stores 15 digits of precision. How RANK returns duplicates How RANK+COUNTIF eliminates duplicates Mystery where RANK+COUNTIF still returns a duplicate Four cells contain 1.15 =A2=A3 shows the cells are equal Ctrl+` shows the cells are equal But the four cells do not sort correctly. Something is different. Change the XLSX to a Zip file Open the XML inside the Zip File What? Excel is storing 17 digits!?! So - is that a good thing? More accurate, right? Maybe 16-digit credit card numbers stored as numbers, right? Hooray? But... while some functions only use 15 digits (COUNTIF and equality tests) others use 17 digits...

New feature in Excel, Word, PowerPoint - Office 365 Exclusive Insert 3D Models in Excel Lots of 3D models available for free on the Internet Resize - change view, or free rotate With VBA, you can move the objects container, but you can't rotate.