How to unmerge cells in Excel
This concise guide demonstrates how to quickly unmerge cells in Microsoft Excel, locate all merged cells within a worksheet, and restore original values to individual cells after unmerging. Merging cells, while sometimes convenient for alignment or c
Apr 07, 2025 am 10:49 AM
How to insert bullet points in Excel in 8 different ways
This tutorial explores several simple methods for creating bulleted lists in Microsoft Excel. We'll also cover efficient techniques for copying bullets and customizing your lists. Excel, while primarily numerical, frequently handles textual data lik
Apr 07, 2025 am 10:39 AM
Quick ways to move, hide, style, and change rows in Google Sheets
Google Sheets: Mastering Row Management and Formatting Google Sheets offers a versatile suite of tools for managing rows, allowing you to move, hide, unhide, resize, and merge them with ease. Enhance your spreadsheet's visual appeal and usability wi
Apr 07, 2025 am 10:33 AM
How to alphabetize tabs in Excel in ascending and descending order
The tutorial shows how you can quickly sort Excel worksheets in alphabetical order by using VBA code and the Workbook Manager tool. Microsoft Excel provides a number of quick and easy ways to arrange columns or rows in alphabetical order.
Apr 07, 2025 am 10:23 AM
Scroll Lock in Excel – how to turn it off and on
Excel scroll lock is turned on unexpectedly? Easy to solve! Imagine that you are using an Excel table normally and suddenly you can't move cells by cell-by-cell-the arrow keys no longer move to the next cell, but scroll the entire worksheet. Don't panic, your Excel is not broken, you just accidentally turned on Scroll Lock, which is easy to solve. - What is Excel scroll lock? How to determine if scroll lock is on? How to turn off scroll locking for Excel for Windows? How to turn off scroll locking for Excel for Mac? What is Excel scroll lock? Scroll lock controls the behavior of arrow keys in Excel. Normally,
Apr 07, 2025 am 10:16 AM
Google Sheets SUMIFS to sum cells with multiple AND / OR criteria
This tutorial demonstrates how to use the SUMIFS function in Google Sheets to sum cells based on multiple criteria. Several real-world examples are provided, showcasing both AND and OR logic. Google Sheets offers two functions for conditional summat
Apr 07, 2025 am 10:11 AM
How to freeze rows and columns in Excel
This tutorial demonstrates how to freeze cells in Excel, ensuring they remain visible while navigating other worksheet areas. Detailed instructions cover freezing rows (single or multiple), columns (single or multiple), and both simultaneously. - Fr
Apr 07, 2025 am 10:10 AM
How to alphabetize in Excel: sort alphabetically columns and rows
This tutorial provides several methods for alphabetizing data in Excel, covering both simple and complex scenarios. It explains how to use the built-in A-Z/Z-A buttons, the Sort feature, and filtering for quick alphabetization of columns or rows, in
Apr 07, 2025 am 10:08 AM
30/60/90 days from today or before today - date calculator in Excel
The tutorial shows how to create a date calculator in Excel exactly for your needs to find a date any N days from or before today, counting all days or only business days. Are you looking to calculate the expiration date that is exactly 9
Apr 07, 2025 am 10:04 AM
CHOOSE function in Excel with formula examples
This tutorial explores the versatile Excel CHOOSE function, demonstrating its syntax, basic usage, and advanced applications beyond its initial appearance. While seemingly simple, combining CHOOSE with other functions unlocks powerful capabilities.
Apr 07, 2025 am 10:02 AM
SUMIF in Google Sheets with formula examples
The tutorial shows how to use the SUMIF function in Google spreadsheets to conditionally sum cells. You will find formula examples for text, numbers and dates and learn how to sum with multiple criteria. Some of the best functions in Goog
Apr 07, 2025 am 09:47 AM
How to superscript and subscript in Excel (text and numbers)
This tutorial will teach you a few quick ways to insert superscript and subscript in Excel, both for text values and numbers. Microsoft Office users sometimes wonder why a particular feature is present in one Office application and absent
Apr 07, 2025 am 09:43 AM
Excel COUNTIF and COUNTIFS with OR logic
This tutorial demonstrates how to use Excel's COUNTIF and COUNTIFS functions to count cells meeting multiple OR conditions (e.g., if a cell contains X, Y, or Z). While COUNTIF handles single criteria and COUNTIFS uses AND logic, this tutorial provide
Apr 07, 2025 am 09:42 AM
How to freeze rows in Google Sheets, insert multiple rows, delete empty rows
It's time to learn more about rows in Google Sheets. Learn how to insert new lines to your table – one or many at once; freeze rows in a spreadsheet in a few clicks; delete selected or only empty rows in your table. Some useful shortcuts
Apr 07, 2025 am 09:23 AM
Hot tools Tags
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
vc9-vc14 (32+64 bit) runtime library collection (link below)
Download the collection of runtime libraries required for phpStudy installation
VC9 32-bit
VC9 32-bit phpstudy integrated installation environment runtime library
PHP programmer toolbox full version
Programmer Toolbox v1.0 PHP Integrated Environment
VC11 32-bit
VC11 32-bit phpstudy integrated installation environment runtime library
SublimeText3 Chinese version
Chinese version, very easy to use
