Excel Headlines
My very own list of news on Excel, gathered from various sources!
This site
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
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 BlogWij 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)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 PulsWe'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 PeltierExcel 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 DalgleishWritten 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 AuthorsDelighting 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.
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.
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.
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
- Coming soon: Zoom button in the menu ribbon under the View tab!
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
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
- Select the Number Format drop down list > More Number Formats…
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