How to hide and unhide columns in Excel, including column A
Hide and unhide columns and rows in Excel for Windows, Mac and the web, bring back a hidden column A or row 1, unhide everything at once, and stop others unhiding your columns.
Blog archive
Hide and unhide columns and rows in Excel for Windows, Mac and the web, bring back a hidden column A or row 1, unhide everything at once, and stop others unhiding your columns.
Two ways to get Gmail contacts onto an iPhone in iOS 27: live Google sync or a one-time vCard import through iCloud. Steps, the default account, duplicates, fixes and Workspace notes.
Create an Excel drop-down list with Data Validation, keep it updating from a table, build a dependent second list with INDIRECT, and edit or remove lists on Windows, Mac and the web.
A worked three-table SQL join: sample schema, INNER and LEFT JOIN queries with results, the two mistakes that silently drop rows, and documented PostgreSQL, MySQL and SQL Server differences.
Join a WhatsApp group by scanning its QR code or tapping its invite link on iPhone, Android or a computer, plus admin approval, reset-link fixes and safety checks before you join.
Justify text in Excel for Windows and Mac through Format Cells, why it needs two or more wrapped lines, what Distributed and vertical Justify do, and when Wrap Text is the better choice.
The 7 indicators WhatsApp lists for being blocked, why none of them is proof, the privacy settings that look identical, and how to check each one on Android, iPhone and desktop.
Lock specific cells or formula cells in Excel, protect the sheet with or without a password, and use Manage Protection in Excel for the web. Steps for Windows, Mac and web.
Log out of Gmail on Android and iPhone by removing the account, take Gmail out of Apple Mail, and sign a lost or sold phone out remotely from your Google Account, with fixes for common problems.
Google Flow, YouTube Shorts and Bing Video Creator are the free AI video options that last. We checked credits, clip length, watermarks and commercial rights for 8 tools.
Merge and unmerge cells in Excel for Windows, Mac and the web, keep your data with &, CONCAT or TEXTJOIN, and centre headings across a selection so sorting still works.
Rename an Excel table on Windows, Mac and the web, follow Microsoft's naming rules, use Name Manager, and write structured references such as tbl_Sales[Sales] with a worked example.
Number rows in Excel four ways: the fill handle and Fill Series, a ROW formula that keeps its order, SEQUENCE for Microsoft 365, 2024 and 2021, and SUBTOTAL for filtered lists.
Open your MacBook camera in Photo Booth or FaceTime, allow it for Zoom, Teams and browsers, use an iPhone as a webcam, and fix a missing camera on personal and work Macs.
Macs have no Task Manager. Here is how to open Activity Monitor and the Force Quit window in macOS 27, read CPU and memory pressure, end a frozen process and save diagnostics for IT.
Open the VS Code terminal on Windows, Mac or Linux, change the default shell, split panes and fix a terminal that will not open, checked against the VS Code 1.146 docs.
Quick Share has worked with AirDrop since November 2025. Which phones support it, the steps in every direction, the 10 GB QR code fallback and fixes when a device does not appear.
Every way to quit apps on a Mac in macOS 27: Command-Q, the Dock, quitting all apps at once, force quitting a frozen app, and why Finder can only be relaunched, not quit.
Schedule an out of office status and message in Microsoft Teams on desktop and mobile, sync it with Outlook automatic replies, and fix the status message that hides your reply.
Keyboard shutdown routes for Windows 11 and macOS 27: Alt+F4, the Quick Link menu, the shutdown command, Mac Power-key shortcuts, the Control-F2 route for Touch ID and forced shutdowns.
Every way to split screen on a Mac: Split View from the green button, edge and Option-drag tiling, Fn-Control shortcuts, quarters, external displays and fixes when Split View is not working.
Split your Windows 11 screen with one shortcut, use Snap layouts for three or four windows, get a split back with Snap groups, fix Snap when it stops working and see what Windows 10 lacks.
A Mac-only screenshot guide for macOS 27: Shift-Command-3, 4, 5 and 6, window and menu captures, the Screenshot app's timer and HDR options, save location, clipboard copies and fixes.
Seven ways to take a screenshot on Windows 11, from Windows + Shift + S and PrtScn to Snipping Tool and Game Bar, with the folder each one saves to and how OneDrive backup changes it.