Before LAMBDA was introduced to Excel, you’d need to know how to use VBA or macros to create your own function. However, today, Excel’s LAMBDA tool lets you do this using familiar Excel language and syntaxes.
[mai mult...]How to customize the Always-on Display on a Samsung Galaxy Phone
How to create a New File in macOS Finder
How to completely Hide an Excel Worksheet
Whether you want to tidy up your workbook tabs, have a dedicated sheet for drop-down list option and other controls, leave only the most important sheets visible, or conceal information you don’t want others to see, you can make worksheets very hidden in Excel. Taking this step reduces the chances of other people making those worksheets visible again.
How to stop Excel from changing your fractions
In a program like Excel, which is designed to handle numbers, you’d expect to be able to use fractions without any hiccups. However, because Excel is programmed to automate and simplify, it often converts your fractions into something other than what you typed.
[mai mult...]Why I always add alt Text in Microsoft 365 Apps
Alternative text (or alt text for short) is a short description of a graphic that helps people with visual impairments fully understand the content of what’s on their screen. Screen readers read alt text aloud, meaning those who can’t see the details of the graphic still know what it contains.
[mai mult...]10 Tips for macOS Newbies
Don’t Increase or Decrease Values in Excel manually
Excel’s spin button lets you quickly increase or decrease a value in a cell without having to type it manually. It can be used in wide-ranging contexts, such as a data entry form, a dashboard worksheet, or a price calculation table, and its flexible controls mean you can tailor it to your needs.
[mai mult...]4 Worthy alternatives to Windows File Explorer
How to disable or hide Copilot in Individual Microsoft 365 Apps
In January 2025, Microsoft introduced Copilot to Word, Excel, PowerPoint, Outlook, and OneNote as part of the Microsoft 365 subscription by default.
[mai mult...]