current location：Home > Technical Articles > Topics > excel
- Direction：
- All web3.0 Backend Development Web Front-end Database Operation and Maintenance Development Tools PHP Framework Common Problem Other Tech CMS Tutorial Java System Tutorial Computer Tutorials Hardware Tutorial Mobile Tutorial Software Tutorial Mobile Game Tutorial
- Classify：
-
- 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,
- excel 798 2025-04-07 10:16:11
-
- 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
- excel 289 2025-04-07 10:11:11
-
- 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
- excel 424 2025-04-07 10:10:12
-
- 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
- excel 213 2025-04-07 10:08:16
-
- 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
- excel 796 2025-04-07 10:04:10
-
- 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.
- excel 241 2025-04-07 10:02:11
-
- 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
- excel 515 2025-04-07 09:47:10
-
- 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
- excel 531 2025-04-07 09:43:10
-
- 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
- excel 898 2025-04-07 09:42:09
-
- 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
- excel 253 2025-04-07 09:23:08
-
- Excel slicer: visual filter for pivot tables and charts
- This tutorial demonstrates how to add slicers to Excel tables, pivot tables, and pivot charts in Excel 2010 through 365. We'll cover advanced techniques like creating custom slicer styles, connecting a single slicer to multiple pivot tables, and mor
- excel 581 2025-04-07 09:22:17
-
- Excel Nested IF statements - examples, best practices and alternatives
- The tutorial explains how to use the nested IF function in Excel to check multiple conditions. You will also learn a few other functions that could be good alternatives to using a nested formula in Excel. How do you usually implement a de
- excel 202 2025-04-07 09:13:10
-
- Calculate days from/before date in Excel
- Are you stuck with calculating how many days there are since a certain date or until date? This tutorial will teach you an easy way to add and subtract days from date in Excel. With our formulas you can quickly calculate 90 days from date
- excel 902 2025-04-07 09:12:10
-
- How to strikethrough in Excel: shortcut, button and conditional formatting
- This tutorial shows you how to add, use, and remove strikethrough formatting in Excel (desktop, online, and Mac versions). While Excel excels at number crunching, text formatting isn't always intuitive; strikethrough is a prime example. Unlike Word
- excel 406 2025-04-07 09:09:09
-
- Excel: convert text to number with formula and other ways
- This Excel tutorial demonstrates various methods for converting text strings to numbers, addressing common spreadsheet issues where numbers formatted as text hinder calculations. The tutorial covers identification of the problem, and multiple soluti
- excel 619 2025-04-06 10:26:10
Tool Recommendations
jQuery enterprise message form contact code
jQuery enterprise message form contact code is a simple and practical enterprise message form and contact us introduction page code.
form button
2024-02-29
HTML5 MP3 music box playback effects
HTML5 MP3 music box playback special effect is an mp3 music player based on HTML5 css3 to create cute music box emoticons and click the switch button.
Player special effects
2024-02-29
HTML5 cool particle animation navigation menu special effects
HTML5 cool particle animation navigation menu special effect is a special effect that changes color when the navigation menu is hovered by the mouse.
Menu navigation
2024-02-29
jQuery visual form drag and drop editing code
jQuery visual form drag and drop editing code is a visual form based on jQuery and bootstrap framework.
form button
2024-02-29
Organic fruit and vegetable supplier web template Bootstrap5
An organic fruit and vegetable supplier web template-Bootstrap5
Bootstrap template
2023-02-03
Bootstrap3 multifunctional data information background management responsive web page template-Novus
Bootstrap3 multifunctional data information background management responsive web page template-Novus
backend template
2023-02-02
Real estate resource service platform web page template Bootstrap5
Real estate resource service platform web page template Bootstrap5
Bootstrap template
2023-02-02
Simple resume information web template Bootstrap4
Simple resume information web template Bootstrap4
Bootstrap template
2023-02-02
Cute summer elements vector material (EPS PNG)
This is a cute summer element vector material, including the sun, sun hat, coconut tree, bikini, airplane, watermelon, ice cream, ice cream, cold drink, swimming ring, flip-flops, pineapple, conch, shell, starfish, crab, Lemons, sunscreen, sunglasses, etc., the materials are provided in EPS and PNG formats, including JPG previews.
PNG material
2024-05-09
Four red 2023 graduation badges vector material (AI EPS PNG)
This is a red 2023 graduation badge vector material, four in total, available in AI, EPS and PNG formats, including JPG preview.
PNG material
2024-02-29
Singing bird and cart filled with flowers design spring banner vector material (AI EPS)
This is a spring banner vector material designed with singing birds and a cart full of flowers. It is available in AI and EPS formats, including JPG preview.
banner picture
2024-02-29
Golden graduation cap vector material (EPS PNG)
This is a golden graduation cap vector material, available in EPS and PNG formats, including JPG preview.
PNG material
2024-02-27
Home Decor Cleaning and Repair Service Company Website Template
Home Decoration Cleaning and Maintenance Service Company Website Template is a website template download suitable for promotional websites that provide home decoration, cleaning, maintenance and other service organizations. Tip: This template calls the Google font library, and the page may open slowly.
Front-end template
2024-05-09
Fresh color personal resume guide page template
Fresh color matching personal job application resume guide page template is a personal job search resume work display guide page web template download suitable for fresh color matching style. Tip: This template calls the Google font library, and the page may open slowly.
Front-end template
2024-02-29
Designer Creative Job Resume Web Template
Designer Creative Job Resume Web Template is a downloadable web template for personal job resume display suitable for various designer positions. Tip: This template calls the Google font library, and the page may open slowly.
Front-end template
2024-02-28
Modern engineering construction company website template
The modern engineering and construction company website template is a downloadable website template suitable for promotion of the engineering and construction service industry. Tip: This template calls the Google font library, and the page may open slowly.
Front-end template
2024-02-28
