Excel Headlines

Updated: Flexfind JavaScript edition
Today I've updated my Flexfind (JS edition). I've added an option to either search in Values or in Formulas and Contiguous ranges are now displayed as one block (A1:B2) instead of as individual cells. To get the update, load the add-in in the usual way, click in it's pane and press control+F5
Tue, 04 Jun 2024 14:40:00 GMT

Updated: Flexfind
Flexfind was updated to fix a bug when the replace string contains a # character
Tue, 28 May 2024 16:00:00 GMT

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

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

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

Debra’s Excel News–July 2024
There are bad characters, musical spreadsheets, and more, in this month’s Excel news. AutoFit Specific Cells Quick Grand Totals Bad Characters Number Keypads Spreadbeats Monthly Photo New on Contextures Pivot Table Tips: Make your Excel pivot tables look better with these 3 quick layout tips. One tip – AutoFit Cells – is described below Overlap … Continue reading "Debra’s Excel News–July 2024"
Tue, 09 Jul 2024 11:45:00 +0000

Modernized Excel Grid (part 2)

Dive into the latest enhancements for Excel for the web, where we've streamlined your spreadsheet experience to be more intuitive and efficient. Now, previewing hyperlinks, customizing your view, renaming sheets, and more, is smoother than ever, allowing you to focus on what matters most—your data.

Hyperlink Previews 

Now, when you hover over web or internal links, you'll see improved hyperlink previews with options to copy, edit, or remove the link. If a thumbnail of the linked page is available, you'll see that too, giving you a better idea of where the link will take you. 
Hyperlink previews

 

 

Easily Adjust Zoom in Status Bar 

Customizing your grid zoom just got easier with the status bar. You can now quickly edit zoom values to suit your preferences. 

Easily adjust the zoom in the status bar

 

Hassle-free Sheet Rename 

Renaming sheets is now a breeze. Simply go to the sheet tab and double-click to rename it directly—no more navigating through dialogs.

Easily rename sheets

 

Open Local Files in Your Browser with Excel for the Web 

We've added a handy "Open files from this device" option in the file menu. This lets you upload a local file to your OneDrive and access it directly from your browser. 

Open local files from the file menu

 

New Keyboard Shortcuts for Faster Access 

Good news for keyboard shortcut enthusiasts! We've added support for accelerator keyboard shortcuts (Alt, E, Alt, V, Alt, I, Alt, O) and over 120 legacy shortcuts. Additionally, we have modernized the Keyboard Shortcuts dialog, with richer information and styling. 

New keyboard shortcuts

 

One Click feedback and Help 

You can now quickly access shortcuts to Feedback, Help, and Keyboard shortcuts, all at your fingertips, from the Status bar.  

New feedback and help shortcuts on the status bar

 

Availability

These features are currently rolling out to all Excel for the web users.

Read up on the other exciting Excel for the web grid enhancements in part one - Modernized Excel Grid.

 

Tue, 16 Jul 2024 06:00:00 PDT