Excel Headlines

My very own list of news on Excel, gathered from various sources!

This site

Update: Name Manager
Name Manager has just been updated to build 706. Editing a name now also updates PowerQuery queries
Wed, 21 Feb 2024 15:30:00 GMT
Solving problems with VBA
I have just added a chapter to my article on solving startup problems in Excel, to solve an issue where Excel thinks it has lost the VBA code in a file
Wed, 14 Feb 2024 10:00:00 GMT

Excel Experts Nederland

Excel Expert Nederland Blog
Bereiknamen beheren in Excel online
Gebruik je bereiknamen, maar ben je soms gedwongen om in Excel on-line te werken? Dan heb ik goed nieuws, je kunt nu mijn Name Manager downloaden en in Excel on-line bereiknamen beheren, maken en bewerken! Zie https://jkp-ads.com/excel-name-manager-js.asp
Tue, 02 Jan 2024 13:14:18 +0000

Daily Dose Of Excel

By Dick Kusleika (et al)
Navigating Outlook Favorites
I have these four favorites defined in Outlook: From the inbox, I could hit Shift+F6 to get into the Favorites area but sometimes I would end up in no man’s land and couldn’t figure out how to get back into the inbox. So, god forbid, I had to use my mouse. I wrote this macro: […]
Thu, 23 Mar 2023 20:41:08 +0000

The Ken Puls Blog

By Ken Puls
Monkey Shorts

In case you missed it, I've been posting free video content over on our Skillwave Training YouTube channel.  In addition to a new series of monthly "Ask Skillwave" sessions that I'm hosting with my good friend Matt Allington of Excelerator … Continue reading

The post Monkey Shorts appeared first on The Excelguru Blog.


Thu, 24 Feb 2022 19:42:55 +0000

PTS Blog

By Jon Peltier

An error has occured while trying to process http://feeds.feedburner.com/peltiertech/EsrO
Please contact web-master.


Contextures Blog

By Debrah Dalgleish
Data Validation Selection Popup Tool – Contextures
With the free Data Validation Select Popup (DVSP) tool from Contextures, you can add popup lists to Excel workbooks. Set the rules you’d like for the pop-up lists — allow single item selection in some columns, and allow multi-selection in other columns. You can even let people add new items to some lists – if … Continue reading "Data Validation Selection Popup Tool – Contextures"
Thu, 07 Mar 2024 06:01:00 +0000

Microsoft Excel blog on TechCommunity

By various Authors
Office Scripts is now available for Office 365 Enterprise E1 and Office 365 F3 licenses

We are happy to announce that Office Scripts in Excel is now available for customers with Office 365 Enterprise E1 and Office 365 F3! Starting today you can find the Office Scripts feature set in the Automate tab on the Excel ribbon.  

 

What is Office Scripts? 

Office Scripts is an automation platform in Excel that allows users with all levels of programming experience to automate their repetitive workflows. To get started, use the Action Recorder to record the actions you take in Excel. These actions are then translated into a script that you can run at any time. No programming experience required! If you need to modify your script, you can use the Code Editor, a TypeScript-based editor directly within Excel. You can use it to edit your existing scripts or to create new ones using the Office Scripts API. If you want to see more examples, see our numerous sample scripts based on real-world scenarios. 

 

How it works  

  1. To start a recording, select Automate > Record Actions, and then select stop once you’re done. scritps with box good 1.gif

     

  2. You can edit your script using the Edit button.scripts recording 2.gif

     

  3. Click the Run button to run your script or any of our samples.  

scritps with box good 3.gif

 

Learn more about Office Scripts  

Are you new to Office Scripts and wondering how to get started? Check out the following resources created by our team and community. 

 

Share your feedback  

We'd love to hear your feedback as you try out Office Scripts! Below are a few ways you can connect with our team:  

  • Give us feedback by selecting the Feedback button located in the overflow menu when you select a script.   

Thank you for using Office Scripts!  


Mon, 18 Mar 2024 11:25:19 PDT