![]() Even though VBA is supported, some features have been disabled, like customizing the Ribbon. The Mac version of Excel 2016 has been released, but if you’re using add-ins, Jon Peltier warns that you shouldn’t upgrade yet. It doesn’t work for everything, but it’s a real timesaver! 4. Productivity Tricks and ShortcutsĬhandoo shared 25 shortcuts and tricks to boost productivity, and #22 is one that I use frequently – press the F4 key to repeat the last action. There’s a short video too, and a sample file you can download, to follow along. For example, if a column has numbers and some blank cells, use the Go To Constants command to select only the numbers, and ignore the blanks, text, or other types of data. On this blog last week, I showed how to use the built-in Excel tools to select specific things. What do you think about the version of Excel that you’re using at work? Here’s a 3-question survey, and I’ll share the results in the next Excel Roundup. In the latest collection of Excel tweets, on my Excel Theatre blog, someone said, “We just got upgraded to Excel 2013 at work and I hate everything.” We’re on our summer schedule now, so the next roundup will be published on Monday, August 3rd. In this week’s roundup, let me know if you like the version of Excel that you’re using at work, get productivity tips, add a sneaky filter to a pivot table, and more.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |