Home Article index Newsletter


Excel Headlines

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

This site

A new tool: Github VBA exporter
I've added a new tool (in beta!!) to my download section called Github VBA Exporter. This utility enables you to export all components from a VBAProject to a user-selectable set of folders. Very useful if you need to upload the contents of a VBA project into Github. The tool generates a textfile which contains all properties of all userforms and their controls, and the ribbonX is exported too, which enables you to do diff's on your user interface.
Wed, 13 Jan 2021 10:30:00 GMT
Update: Name Manager
Name Manager has just been updated to build 675. You can now filter for Lambda names and you can edit name comments
Mon, 14 Dec 2020 13:55:00 GMT

Excel Experts Nederland

Excel Expert Nederland Blog
Nieuw: ons Excel Forum
Wij kregen tamelijk veel Excel gerelateerde vragen in onze commentaren. Om deze vragen beter te kunnen kanaliseren zijn we daarom een Excel forum gestart. Heb je een vraag? Word lid van ons forum en stel hem hier: Excel Experts Nederland Forum
Mon, 30 Jan 2017 16:38:13 +0000

Daily Dose Of Excel

By Dick Kusleika (et al)
Name Manager updated
Do you use Range names in Excel? Today I have updated my 100% free Excel Name Manager add-in with two new features: – Edit the name’s comment – Filter Lambda names https://jkp-ads.com/officemarketplacenm-en.asp Here’s a screen-shot: Regards, Jan Karel Pieterse jkp-ads.com
Mon, 14 Dec 2020 14:02:55 +0000

The Ken Puls Blog

By Ken Puls
New Monkey Tools Features

We're super excited to let you know that we've just released some new Monkey Tools features!  Let's take a quick look as to what is new... The Table Monkey This feature was actually released back in December. However, since we … Continue reading

The post New Monkey Tools Features appeared first on The Excelguru Blog.


Tue, 12 Jan 2021 19:26:16 +0000

PTS Blog

By Jon Peltier
VBA Test for New Excel Functions

Excel has awesome new Dynamic Array, LET, and LAMBDA functions. Here's a VBA test for whether a user's installation supports these functions.

The post VBA Test for New Excel Functions appeared first on Peltier Tech Blog.


Wed, 10 Feb 2021 18:53:45 +0000

Contextures Blog

By Debrah Dalgleish
Quick Tip: Find and Replace Line Breaks in Cells

Written by Debra Dalgleish from Contextures Blog

To show text on separate lines in an Excel worksheet cell, use a shortcut, Alt+Enter, to add a line break. If you want to remove them later, use Ctrl+J in Find and Replace. This short video shows the steps. Video: Add and Remove Line Breaks In her latest video, Sarah shows how to add a … Continue reading "Quick Tip: Find and Replace Line Breaks in Cells"

Quick Tip: Find and Replace Line Breaks in Cells is a post from Contextures Blog and is not allowed to be copied to other sites


Thu, 18 Feb 2021 05:02:00 +0000

Microsoft Excel blog on TechCommunity

By various Authors
What's New in Excel for the web

Delighting our customers with faster, smoother, and richer experiences in Excel for the web is an uncompromised goal across our Excel team.  Recently we shared how we’ve continued to improve performance to make opening workbooks, navigating a workbook, and other interactions faster and smoother for you.  Today we’re introducing several additional features to help you better navigate and manipulate your Excel files in a browser:

  • Easier worksheet navigation
  • Multiple range selection
  • Zoom in/out
  • Excel keyboard shortcuts by default
  • Version history
  • Regional settings

 

Easier worksheet navigation

When opening an Excel workbook with multiple worksheets, you can now jump directly to the worksheet you want. Simply click on the new All Sheets button in the lower left corner and then select your worksheet.

 

cuong_16-1614714305315.png

 

 

Multiple range selection

You can now select multiple ranges that are not adjacent to each other – and fill color or copy-and paste.  Hold the Ctrl key while selecting as many ranges as you want.  The example below shows how you can select two non-adjacent columns and apply conditional formatting.

 

discon.selection.gif

 

 

Excel keyboard shortcuts by default

Excel for the web now supports your keyboard shortcuts by default.  Keyboard shortcuts like Alt, Ctrl-1, Ctrl-Shift-A, etc., go to Excel and not your browser.  To see the list of Excel keyboard shortcuts, click on the Help tab and select Keyboard Shortcuts – Override browser shortcuts is checked by default.

 

cuong_18-1614714305516.png

 

 

Zoom in/out

Excel for the web now supports many ways to zoom in/out.  Zoom in to get a close-up view of your data or zoom out for an overview look of your worksheet:

  • Pinch/stretch to zoom on touch screen or trackpad
  • Ctrl + mouse wheel
  • Ctrl Alt +/- key
  • Click the +/- button
  • Select a predefined zoom level from 25% to 200% in the bottom right corner

 

cuong_19-1614714305517.png

 

 

  • Coming soon: Zoom button in the menu ribbon under the View tab!

 

cuong_20-1614714305523.png

 

 

Version history

You can now view and restore previous versions of your Excel file using version history.  Track activities in the workbook by others collaborating with you and revert to a previous version if needed.  Select File > Info > Version History

 

version-history.gif

 

 

Regional settings

You can now change region settings in Excel for the web to set your date/time, number, and currency formats in a couple ways:

  • Select File > Options > Regional Format Settings, or

 

regional-settings.gif

 

 

  • Select the Number Format drop down list > More Number Formats…

 

cuong_23-1614714309884.jpeg

 

 

These are just some of the latest improvements, many more are coming soon!

 

Your feedback helps shape the future of Excel for the web.  Please let us know how you like a particular feature and what we can improve upon—send us a smile or frown.

 

Want to know more about Excel for the web?  See What's new in Excel for the web and subscribe to our Excel Blog to get the latest updates.  Stay connected with us and other Excel fans around the world – join our Excel Community and follow us on Facebook and Twitter.

 

 

 


Tue, 2 Mar 2021 12:22:59 PST