Handy, eh?Į.g., in a cell type “This report was updated on ” then press CTRL + While I have been using this for many years, only recently and by accident did I discover that I could use the shortcut to insert the date/time anywhere inside some other text. Insert the current date or time inside text too Insert current time and date with a keyboard shortcutĬTRL+ (semicolon) to insert the current dateĬTRL + : (colon) to insert the current time Instead, insert today’s date or the current time in Excel, using a shortcut. You are updating your Excel table with the time and date of your most recent call to a customer, you want to be fast and not type the date and time manually. MrExcel ® is a registered trademark of Tickling Keys, Inc.Īll contents © 1998 - 2023 MrExcel Publishing | All rights reserved.Data entry in Excel can be tedious enough. View our Privacy Policy, Cookies Policy, and Terms of Use.Įxcel ® is a registered trademark of the Microsoft Corporation. You can earn a commission for sales leads that you send to us by joining our Any affiliate commissions that weĮarn when you click a link to Amazon or other sites is reinvested in keeping Website are provided "as is" and we do not guarantee that they can be used in all The Formulas, Functions and Visual Basic procedures on this provides examples of Formulas, Functions and Visual Basic proceduresįor illustration only, without warranty either expressed or implied, includingīut not limited to the implied warranties of merchantability and/or fitness forĪ particular purpose. You have to turn off Speak Cells onĮnter, and then “Damn straight Go Irish”! All you need is one line of code,Ī (“Damn straight! & Target.Value), which is what Top-right, choose Change, so now, every time they change something on the Double-click, top-left, choose Worksheet, Go to the sheet that they're working on, now this only works on one sheet, so Hey, you want to do the bonus trick? Alt+F11, Well hey, I want to thank you for stoppingīy, we'll see you next time for another netcast from MrExcel! Remove from Quick Access Toolbar, and then wait for your coworker to start Scroll down to Speak Cells on Enter,Ĭlick Add to add to the toolbar, turn on the feature, right-click the icon, Quick Access Toolbar, choose Customize Quick Access Toolbar from the top-leftĭropdown and choose Commands Not in The Ribbon. Alright, recap: great April Foolsĭay trick to pull on a co-worker! Wait till they leave, right-click on the Top-right hand corner for a link to the book. Whole bunch of other really good tricks, are in this book, click the “i” on the This time the computer is repeating what you say, justĪn awesome, awesome trick, Speak Cells on Enter. Like Lieutenant Uhura on the original Star Trek, except she would repeat what You know that you've got them if they rip the speakers out of the wall, just Spreadsheet income statement, Excel will repeat back everything that they type! Spreadsheets for 25 years, right, sits down to start to create their Your coworker comes back, has been creating Then, to really do the trick right, right-click and say Remove from Quick Access Wait till your coworker goes to get a cup of coffee, and thenĭo this on their computer, turn it on, “Cells will now be spoken on Enter.” And To the S’ and find Speak Cells, and put 5 icons in order on the toolbar.Īlthough for this particular trick, all you need is the last one called SpeakĬells on Enter. Speak Cells, right-click, Customize Quick Access Toolbar, All Commands, go down This bonus tip 40b, click the “i” in the top-right hand corner to get to the playlistĪlright, yesterday I set this up with the I'm podcasting this entire book, including Learn Excel from MrExcel podcast, episode
If only you could get the voice to be Nichelle Nichols, it would be perfect.
#Excel tip of the day code
If you have a little more time, add the following macro to the code pane for the current worksheet. The computer will repeat back everything the co-worker types. Your co-worker comes back, sits down, and starts to build a worksheet. This will hide any sign that you were there. Once you’ve turned on Speak Cells on Enter, right-click the icon in the Quick Access Toolbar and choose Remove from Quick Access Toolbar. Click the icon once and the computer will say, “Cells will now be spoken on Enter.” But if you enable the feature while your co-worker goes to get a cup of coffee, hilarity will ensue.ĭo you want a harmless prank to pull on a co-worker? When he leaves his leave their desk to grab a cup of coffee, add the fifth icon to his Quick Access Toolbar: Speak Cells on Enter. This is an obscure command that most people don't know about.
#Excel tip of the day how to
How to drive your co-workers crazy with the Excel command: Speak Cells on Enter.
0 kommentar(er)
