NZCity NewsLinks -

All Links

17 Jun 2025

Search

How to add helpful prompts to Microsoft Excel cells
Did you know that you can leave notes on specific Excel cells for people to read? It’s a great way to safeguard against data entry mistakes by putting in reminders or instructions. Here’s how to set it up: Click on the cell where you want the note. Go to the Data tab at the top. Click Data Validation in the Data Tools Group. In the window that opens, go to the Input message tab. Check the box that says “Show input message when cell is selected.” Add a title (32 characters). Type your input message (255 characters). Click OK. To help other users fill in the form, you can integrate hints into individual cells that appear automatically when you click on them. IDG

This Lenovo Snapdragon OLED 2-in-1 laptop is crazy for just $475
Microsoft and its partners have pushed hard to get people interested in the new field of laptops powered by Qualcomm’s Arm-based Snapdragon processors, but they haven’t exactly been flying off the shelves. Maybe if they were a little more affordable, like this $475 touchscreen laptop from Lenovo, they’d sell a little better. The Newegg store on eBay calls this refurbished laptop the “IdeaPad 5,” but it’s really the IdeaPad 5X, which PCWorld reviewed back in November of last year. It was already one of the few entries in the Snapdragon X Plus line that offered a decent value, in addition to the great battery life that these Arm-based laptops are known for. If you go for the refurb here, which comes with a one-year Allstate warranty, you save an impressive $375 versus the retail price. Highlights of the design include a 14-inch 1920×1200 touchscreen with an upgraded OLED panel, which can flip around for a convertible form factor, 16GB of RAM, and 1TB of SSD storage, all well above the usual options in this price range. The laptop offers two USB-C ports, two USB-A, full-sized HDMI, and microSD. It’s not the sleekest laptop around, but for basic tasks (except 3D gaming) it’ll handle them with aplomb and last a long time on a charge. This is quite the get in this price range, so get it now on eBay while you still can! Otherwise, if it’s not for you, then you can find more great budget picks in PCWorld’s best laptops roundup. Get this Lenovo Snapdragon OLED laptop for $475Buy now on eBay

Want classic Outlook to always reply to emails in a new window? Here’s how!
When replying to emails in classic Outlook, many users prefer to work or write in a new window. But after reinstalling the app, you might find that this no longer works. Here’s what you can do. The option to reply to emails using a new window can be reactivated in the settings. Navigate to File > Options, then click on the Mail item to the left in the dialog window. Scroll down to the Replies and forwards section, then tick the checkbox for the “Open replies and forwards in new window” item. Confirm with OK. The change is immediately available without restarting Outlook. Note that Microsoft wants to get everyone off classic Outlook by 2026, so you may want to migrate over to the new Outlook app sooner than later. Fortunately, Microsoft will soon make it possible to run both classic and new Outlook side by side, which should help make the transition that much easier if you’re still holding out. Further reading: The best tips for the new Outlook app