How-To Geek - Microsoft Excel

Microsoft Excel Can Now Stop Turning Everything Into a Date

Corbin Davenport — Fri, 20 Oct 2023 17:11:46 GMT

Microsoft Excel converting numbers into other formats has been a running joke for years, especially with date conversions, Microsoft rolled out a new setting last year that turns off data conversions like scientific notation and removing leading zeroes, and now an additional setting to turn off date conversion has arrived. Also, the options are available on Excel for Mac for the first time.

Microsoft Excel is Adding a Python Editor

Arol Wright — Tue, 19 Sep 2023 14:42:22 GMT

If you know how to use it, Microsoft Excel can be a tremendously powerful and versatile tool. Of the Word-PowerPoint-Excel trio of apps, Excel is probably the most powerful one. It's simple to use for data storing, but if you want to, you can make all sorts of things with it — some people have even made games. Now, though, those options are just growing exponentially with Python integration.

How to Add a Drop-Down List to a Cell in Excel

Lori Kaufman — Wed, 06 Sep 2023 12:31:29 GMT

Drop-down lists are very useful data entry tools we see just about everywhere, and you can add custom drop-down lists to your own Excel worksheets. It’s easy and we’ll show you how.

Python Is Coming to Microsoft Excel, With a Few Catches

Corbin Davenport — Tue, 22 Aug 2023 15:56:20 GMT

Microsoft Excel has many built-in functions for manipulating and organizing data, and on Mac on Windows, you can extend the application even further with the use of VBA scripts. Microsoft is now introducing support for running Python code in your Excel spreadsheet, opening up even more possibilities for data analysis.

Microsoft Excel's Formula Bar Has a New Look

Corbin Davenport — Fri, 18 Aug 2023 20:48:51 GMT

Microsoft Excel has changed a lot since the first version arrived in 1987, but much of the core functionality is still the same. The formula bar is one of those components that has remained mostly the same, but now Microsoft is introducing a small but important change: a new font.

Microsoft Adds a Modern Touch to One of Excel's Oldest Features

Andrew Heinzman — Thu, 10 Aug 2023 20:10:41 GMT

When you need to modify an Excel spreadsheet without triggering any new calculations, you turn on manual calculation mode. This is one of the oldest features in Microsoft Excel, and after three decades, it still suffers from one awkward problem—Excel doesn't indicate when a change you've made in manual mode affects an existing calculation. If you aren't careful when editing a spreadsheet in manual calculation mode, you can end up with incorrect or "stale" values.

Every Strikethrough Shortcut for MS Office, Google Docs, & Gmail

Mahesh Makvana — Tue, 01 Aug 2023 12:00:26 GMT

Applying the strikethrough effect (which adds a line crossing your text) in popular apps like Word, Excel, PowerPoint, Outlook, Google's online office suite, and Gmail is as easy as pressing a key combination. Let us show you what those keyboard shortcuts are for the Windows and Mac computers.

How to Calculate Variance in Microsoft Excel

Ben Stockton — Sun, 23 Jul 2023 14:00:26 GMT

Variance is used to measure the spread of data values against the mean in a data set. Microsoft Excel can be used to calculate this variance to help you analyse your data, determine its quality, and make important decisions.

How to Use Less Than or Equal To in Excel

Mahesh Makvana — Sat, 22 Jul 2023 13:01:26 GMT

Using the less-than-or-equal-to

How to Show the Ribbon in Microsoft Excel, Word, and Outlook

Mahesh Makvana — Wed, 10 May 2023 14:00:18 GMT

Has your Excel, Word, or Outlook app's ribbon suddenly disappeared? It's easy to hide it accidentally, and sometimes the tabs disappear too. In either case, you can bring it back in your Office app on your Windows or Mac machine in a few clicks. Here's how.

How to Set Excel as the Default App for Spreadsheets on Mac

Tim Brookes — Wed, 19 Apr 2023 13:00:37 GMT

Microsoft Excel works great on a Mac, but sometimes spreadsheets open in other apps like Apple Numbers instead. You can fix this by telling your Mac which app to use by default and converting incompatible files.

Microsoft Excel Now Has a ChatGPT Function

Corbin Davenport — Wed, 12 Apr 2023 10:42:54 GMT

Microsoft announced a Copilot AI feature that is coming to Excel sometime in the future, along with Word, Excel, and other apps. In the meantime, there's a new function that can plug your spreadsheet data directly into ChatGPT.

How to Combine First and Last Names in Microsoft Excel

Mahesh Makvana — Thu, 16 Feb 2023 13:00:24 GMT

Do you want to bring the first and last names that are in separate cells into a single cell? Combining text is easy in Excel, and we'll show you five different ways to combine names.

How to Add Text to a Cell With a Formula in Excel

Mahesh Makvana — Sun, 05 Feb 2023 12:00:51 GMT

Do you want to add some text to the beginning, middle, or end of the existing text in your cells? Microsoft Excel has you covered. You can use a formula or function to append text to your cells, including finding a specific character and adding your text before or after it. Here's how.

How to Check If a Cell Is Blank With ISBLANK in Excel

Mahesh Makvana — Mon, 30 Jan 2023 12:00:00 GMT

Microsoft Excel's

How to Remove Blank Rows in Excel

Mahesh Makvana — Sat, 28 Jan 2023 12:00:00 GMT

Want to remove all the blank rows from your dataset? If so, Microsoft Excel offers both automatic and manual methods to let you clear the blank rows and shift your data up. Here's how to use those ways.

3 Ways to Insert Hyperlinks in Microsoft Excel

Sandy Writtenhouse — Tue, 24 Jan 2023 12:00:19 GMT

For quick access to a cell, document, or webpage, you can insert hyperlinks in your Excel spreadsheet. Just paste in a hyperlink, give it a readable label, and click to follow the link. Here are a few ways to insert hyperlinks in Excel.

Save Time in Outlook With These 6 Custom Quick Step Examples

Sandy Writtenhouse — Mon, 23 Jan 2023 12:00:48 GMT

Using Quick Steps in Microsoft Outlook, you can click a button to run one or more automated actions on an email you select. While Outlook gives you some handy premade Quick Steps, you may want to create your own.

How to Apply Color to Alternate Rows in Microsoft Excel

Sandy Writtenhouse — Thu, 19 Jan 2023 17:40:00 GMT

One way to make spreadsheet data easier to read is by applying colored shading to alternating rows. Microsoft Excel offers a couple of ways to alternate row color so you can whichever method works best for you.

11 Little-Known Excel Functions That Are Very Useful

Sandy Writtenhouse — Wed, 18 Jan 2023 12:00:11 GMT

Microsoft Excel offers hundreds of functions. So, there's bound to be at least a handful you don't know exist. These unique functions have specific purposes that you'll be thrilled to learn about and use.

6 Uses for the HYPERLINK Function in Microsoft Excel

Sandy Writtenhouse — Mon, 16 Jan 2023 11:00:29 GMT

Excel offers its own built-in linking feature in the toolbar. But the HYPERLINK function lets you do more, like a link to a workbook on your company intranet, shared server, another drive, or even a bookmark in a Word document. Let's look at everything you can do with this versatile function.

Excel for Beginners: The 6 Most Important Tasks to Know

Sandy Writtenhouse — Wed, 11 Jan 2023 12:00:18 GMT

If you've never spent time using Microsoft Excel, it can feel a bit overwhelming at first. We'll teach you the basic tasks you need to know to use this popular spreadsheet application.

How to Use the FILTER Function in Microsoft Excel

Sandy Writtenhouse — Tue, 10 Jan 2023 12:00:00 GMT

Microsoft Excel offers a built-in filter feature along with the option to use an advanced filter. But if you want to filter by multiple criteria and even sort the results, check out the FILTER function in Excel.

Don't Have a Wearable? Track Your Health in Excel

Sandy Writtenhouse — Sat, 07 Jan 2023 09:00:08 GMT

Don't have a health tracker that you can strap on like a Fitbit or even an Apple Watch? You can still effectively log fitness, nutrition, diet, blood sugar, and other health details using an app you probably have on your computer, Microsoft Excel.

Microsoft Excel's Automation Tab Is Now on Mac and Windows

Arol Wright — Thu, 05 Jan 2023 16:58:33 GMT

Amid all the CES news, Microsoft is also pushing some helpful updates for its Microsoft 365 suite of programs. Excel's Automate tab is now finally available on the desktop versions of the beloved spreadsheet app.

How to Add or Remove a Secondary Axis in an Excel Chart

Sandy Writtenhouse — Thu, 01 Dec 2022 14:00:37 GMT

If you have a chart where you're plotting different types of data or the values vary, consider adding a second axis for easier viewing. We'll show you how to painlessly create a two-axis chart in Excel.

7 Ways to Sort Data in Microsoft Excel

Sandy Writtenhouse — Wed, 30 Nov 2022 12:00:00 GMT

It's easy to sort data in Excel alphabetically or numerically. But maybe you want to sort based on color, formatting, or a list like months of the year. We'll show you different ways to sort data in Excel.

How to Use an Advanced Filter in Microsoft Excel

Sandy Writtenhouse — Tue, 29 Nov 2022 13:00:57 GMT

While Microsoft Excel offers a built-in feature for filtering data, you may have a large number of items in your sheet or need a more complex filter. Here, we'll explain how to create an advanced filter in Excel.

How to Use a Data Table in a Microsoft Excel Chart

Sandy Writtenhouse — Mon, 28 Nov 2022 13:00:51 GMT

When you make a graph in Excel, you may want to include the source data with it. By adding a data table, which takes just a few steps, you can provide extra details or further explain your visual.

How to Find the Smallest or Largest Number in Microsoft Excel

Sandy Writtenhouse — Tue, 22 Nov 2022 13:00:35 GMT

When you have a spreadsheet packed with data, finding the number you need can be tedious. Yet, whether you're looking for the lowest product sales amount or the highest test score, Excel's SMALL and LARGE functions can help.

How to Add and Customize Data Labels in Microsoft Excel Charts

Sandy Writtenhouse — Sun, 20 Nov 2022 13:00:28 GMT

When you create an Excel chart that contains a ton of data, it can be difficult to decipher it all at a glance. One helpful way to point out information is using data labels for a series of data points. We'll show you how to use data labels here.

How to Unhide All Rows in Excel

Mahesh Makvana — Thu, 17 Nov 2022 14:00:10 GMT

Unhiding all the rows in a Microsoft Excel spreadsheet is as easy as pressing a keyboard shortcut or using a button on the ribbon. We'll show you how.

How to Optimize Workbook Performance in Excel for the Web

Sandy Writtenhouse — Thu, 17 Nov 2022 13:00:34 GMT

When you use Excel on the web, do you notice that your workbook takes a long time to load? Microsoft seeks to help you solve this problem with Check Performance. Here's how it works.

How to Multiply Columns in Microsoft Excel

Sandy Writtenhouse — Tue, 15 Nov 2022 13:00:02 GMT

Microsoft Excel is full of useful features, including those for performing calculations. If there comes a time when you need to multiply two columns in Excel, there are various methods for doing so. We'll show you how to multiply columns right here.

How to Use the IS Functions in Microsoft Excel

Sandy Writtenhouse — Mon, 14 Nov 2022 13:00:50 GMT

When you want to test your data and receive a simple True or False result, the IS functions in Excel are just what you need. You can check for blank cells, errors, text, numbers, references, and more quickly and easily.

7 Excel Data Analysis Features You Have to Try

Sandy Writtenhouse — Mon, 14 Nov 2022 08:00:28 GMT

No matter what you use Excel for, whether business financials or a personal budget, the tool's data analysis features can help you make sense of your data. Here are several Excel features for data analysis and how they can help.

How to Export a Cell Range or Excel Workbook as a PDF

Sandy Writtenhouse — Sun, 13 Nov 2022 14:00:30 GMT

If you want to share data from Excel without sharing the Excel file, you can export a selection of cells or the entire workbook as a PDF. The result is a super handy document you can share any way you want.

How to Count Checkboxes in Microsoft Excel

Sandy Writtenhouse — Thu, 10 Nov 2022 15:00:11 GMT

If you use Excel to create a checklist, you may want to count the number of checked or unchecked boxes. With a simple formula, you can tally them in a cell that adjusts as more boxes are marked or unmarked.

How to Use the Microsoft Excel SORT Function

Sandy Writtenhouse — Wed, 09 Nov 2022 15:00:18 GMT

While Microsoft Excel offers a built-in tool for sorting your data, you may prefer the flexibility of a function and formula. We'll show you how to use the Excel SORT function with helpful examples.

How to Use the SUBTOTAL Function in Microsoft Excel

Sandy Writtenhouse — Tue, 08 Nov 2022 14:00:57 GMT

Obtaining subtotals for groups of related items is easy in Microsoft Excel. In fact, you have two ways to do this. You can either use the SUBTOTAL function or the Subtotal feature, whichever works best. We'll show you how.

Microsoft Create Is Here to Revamp Office Templates

Corbin Davenport — Mon, 07 Nov 2022 15:36:17 GMT

Templates have been a core feature of the Microsoft Office suite for years, giving people an easy way to make better-looking presentations and papers. Now the company has consolidated its templates in one place: Microsoft Create.

How to Show Changes in Microsoft Excel on Desktop

Sandy Writtenhouse — Mon, 07 Nov 2022 15:00:50 GMT

Do you see something unusual in your Excel spreadsheet? Wondering how the change may have happened? Whether you're working with others or alone on an Excel sheet, there's a simple way to see the changes that take place.

How to Use Microsoft Excel Templates for Event Planning

Sandy Writtenhouse — Fri, 04 Nov 2022 14:00:35 GMT

Microsoft Excel is often synonymous with company financials, household budgets, and other numeric data. But Excel can be a terrific tool for planning events like weddings, showers, parties, and more, too. Keep reading for templates you can use to plan your next event.

How to Find Merged Cells in Microsoft Excel

Sandy Writtenhouse — Mon, 31 Oct 2022 15:00:58 GMT

Have you ever tried to sort data in Excel, only to receive an error about merged cells? It can be a pain to try and locate all of those merged cells manually. Luckily, there's a simple way to find them.

How to Group Columns in Microsoft Excel

Sandy Writtenhouse — Sat, 29 Oct 2022 13:00:24 GMT

If you organize a spreadsheet by columns, you may only want to work with specific columns at one time. In Microsoft Excel, you can group columns and expand and collapse them as you work. We'll show you how to do just that.

How to Import Data From a PDF to Microsoft Excel

Sandy Writtenhouse — Fri, 28 Oct 2022 15:55:00 GMT

If you have a PDF document such as a bank statement or financial report, you may want to pull this information into Microsoft Excel. With a built-in feature, you can easily import and automatically convert a PDF to Excel.

How to Group and Collapse Rows in Microsoft Excel

Sandy Writtenhouse — Fri, 28 Oct 2022 15:00:30 GMT

Viewing only the data you want to see can be tedious when you're working with a large spreadsheet. Luckily, Excel offers various tools you can use to simplify your data. For example, you can easily group rows in Excel and then collapse or expand your data as needed.

How to Make a Scatter Plot in Microsoft Excel

Marshall Gunnell — Thu, 27 Oct 2022 15:00:51 GMT

A scatter plot, sometimes referred to as a scatter chart or XY chart, compares the relationship between two different data sets. This makes it easier to visualize two sets of values in your Excel spreadsheet. Here's how it works.

How to Convert a JSON File to Microsoft Excel

Mahesh Makvana — Mon, 24 Oct 2022 16:20:00 GMT

Have you received a JSON file that you'd like to convert to Microsoft Excel format? Excel offers a built-in option to help you import it without third-party parsing tools. Here's how you can do it.

How to Use the IF Function in Microsoft Excel

Mahesh Makvana — Tue, 18 Oct 2022 15:00:53 GMT

Whether you're grading exams or simply trying to make sense of a spreadsheet full of data, Microsoft Excel's IF function can help. You can also use an IF function inside of another IF function to run deeper tests, too. We'll show you how.

How to Track Almost Anything with Excel List Templates

Sandy Writtenhouse — Fri, 14 Oct 2022 14:00:00 GMT

Microsoft Excel is known for being an excellent tool for tracking things like a budget, inventory, or sales and revenue. But there are so many templates available you might not realize exist that can help you track just about anything.

How to Quickly Search the Menus in Microsoft Office

Sandy Writtenhouse — Thu, 13 Oct 2022 15:00:32 GMT

While the Microsoft Office applications Word, Excel, and PowerPoint all have robust features, those features are not always easy to find. Stop scouring every menu, drop-down box, or dialog launcher on each tab and search the menus for what you need.

Excel's New Keyboard Shortcut Can Paste Without Formatting

Corbin Davenport — Thu, 13 Oct 2022 14:38:49 GMT

Microsoft Excel has many keyboard shortcuts, but surprisingly, the option to paste without formatting isn't one of them. That's finally changing with a new update that Microsoft is testing.

How to Lock Column Width and Row Height in Microsoft Excel

Sandy Writtenhouse — Wed, 12 Oct 2022 13:00:00 GMT

Do you have an Excel sheet where you want the columns and rows at fixed sizes? You can lock the column width and row height for your entire spreadsheet in a few steps to prevent accidental resizing.

How to Sum a Column in Microsoft Excel

Mahesh Makvana — Tue, 11 Oct 2022 14:00:00 GMT

Microsoft Excel offers multiple ways to sum the values of a specific column. You can use the status bar, AutoSum, and the SUM function to add up the values in your column. Here's how to use them.

How to Add, Edit, Show, and Convert Notes in Microsoft Excel

Sandy Writtenhouse — Tue, 11 Oct 2022 13:00:36 GMT

Like jotting down notes when you're composing a document, you can use notes in Excel for a spreadsheet. You might use a note as a reminder, to add a reference, or include a detail that should stay outside of the cell data.

How to Link to Another Sheet in Microsoft Excel

Sandy Writtenhouse — Mon, 10 Oct 2022 14:00:00 GMT

Just like linking to another place in a Word document, you can link to another sheet in an Excel workbook. This is a handy way to quickly jump to a spreadsheet related to your current sheet or cell.

How to Make a Family Tree in Microsoft Excel

Sandy Writtenhouse — Sat, 08 Oct 2022 13:00:06 GMT

Creating a family tree is a fun and interesting activity to do on your own or with your family. It may even be homework for your child. Luckily, if you have Excel, you can make a family tree easily.

How to Insert Data From a Picture in Excel on Windows

Sandy Writtenhouse — Fri, 07 Oct 2022 14:00:05 GMT

If you have data from a physical source that you want to add to Excel, you have the option to snap a photo of it, save it to your computer, and upload the data into your sheet to save time.

How to Easily Move or Copy a Worksheet in Microsoft Excel

Lori Kaufman — Tue, 04 Oct 2022 17:13:00 GMT

There may be times when you want to create a new Excel worksheet based on an existing worksheet. You can easily copy an entire worksheet in Excel to a new worksheet in the same file or even to a new, separate workbook using the "Move" or "Copy" command. It's one of the many great features in Excel.

How to Use the IMAGE Function in Microsoft Excel

Sandy Writtenhouse — Tue, 04 Oct 2022 15:00:36 GMT

If you want to include an image in Excel, like a company logo or product photo, you can add the image using the Insert tab. But, to keep the image within a particular cell, use the IMAGE function instead.

How to Freeze Multiple Rows in Microsoft Excel

Mahesh Makvana — Mon, 03 Oct 2022 13:00:37 GMT

Freezing a single row is easy, but what if you want to freeze multiple rows at the top of your Microsoft Excel spreadsheet? Luckily, there's an option to do that, too, and we'll show you how to use it.

How to Remove Dotted Lines in Microsoft Excel

Sandy Writtenhouse — Sat, 01 Oct 2022 14:00:14 GMT

Have you ever been working on an Excel spreadsheet when dotted lines suddenly appeared? While fine to some, those dotted lines may be distracting to others. We'll show you when and why these dotted lines appear and how to remove them.

How to Calculate Workdays With a Function in Microsoft Excel

Mahesh Makvana — Fri, 30 Sep 2022 13:00:12 GMT

With Microsoft Excel's

How to Easily Work With Excel Tables in the Mobile App

Sandy Writtenhouse — Wed, 28 Sep 2022 15:00:44 GMT

If you find yourself working on-the-go in the Excel mobile app, you might struggle when it comes to tables. That tiny screen isn't always sufficient for viewing table data, much less editing it. Luckily, there's a feature that can help.

12 Default Microsoft Excel Settings You Should Change

Sandy Writtenhouse — Wed, 28 Sep 2022 12:00:00 GMT

Like any other program, Microsoft Excel comes with some default settings that won't work well for everyone. You can potentially save yourself time and energy by changing what happens every time you open and work in Excel.

How to Find Circular References in Microsoft Excel

Ben Stockton — Tue, 27 Sep 2022 15:00:49 GMT

A circular reference in Excel happens when a cell containing a formula is dependent on its own result in some way, creating a loop that can't be resolved. If you want to stop this error, you'll need to find and remove these references to allow Excel to complete the calculation. Here's how.

Excel Has a New Feature for Speeding up Spreadsheets

Corbin Davenport — Mon, 26 Sep 2022 14:45:34 GMT

Microsoft Excel spreadsheets can have thousands of cells for storing data, which can slow down your PC -- even if there's no visible data in many of the cells. Thankfully, Microsoft is rolling out a new feature to improve spreadsheet performance.

How to Use the IFS Function in Microsoft Excel

Sandy Writtenhouse — Mon, 26 Sep 2022 14:00:00 GMT

If you're familiar with using the IF function in Excel, then you might be ready to check out the IFS function. With it, you can test multiple conditions at once, instead of using nested IF statements.

How to Combine, Reshape, and Resize Arrays in Excel

Sandy Writtenhouse — Wed, 21 Sep 2022 14:00:06 GMT

Working with arrays, or adjacent cell ranges, in Microsoft Excel can be challenging at times. If you'd like to combine, reshape, or resize an array, you can choose from a collection of functions that can cover many situations.

How to Split and Extract Text in Microsoft Excel

Sandy Writtenhouse — Mon, 19 Sep 2022 15:00:08 GMT

Microsoft Excel offers a set of functions for working with text. When you want to extract part of a text string or split a string into rows or columns, there are three particular functions that get the job done.

How to Highlight Values Above or Below Average in Excel

Sandy Writtenhouse — Wed, 07 Sep 2022 14:00:52 GMT

If you want to find numbers that are above or below average, you don't have to calculate that average and then review the values for those higher or lower. With conditional formatting in Excel, you can automatically highlight those numbers.

How to Get the Month or Year From a Date in Microsoft Excel

Sandy Writtenhouse — Tue, 06 Sep 2022 15:00:00 GMT

Dates in Microsoft Excel are useful for tracking finances, orders, and sales. So, there may come a time when you want to pull a month or year out of a date entry. Functions and formulas make this an easy task.

How to Use the Ink Features in Microsoft Office

Sandy Writtenhouse — Sat, 03 Sep 2022 11:00:19 GMT

If you like to scribble your words, shapes, or equations, you can use Microsoft Office's ink features to convert those items. With Ink to Text, Ink to Shape, and Ink to Math, you can turn your doodles into useable elements.

How to Shrink Text to Fit a Cell in Microsoft Excel

Sandy Writtenhouse — Thu, 01 Sep 2022 13:00:37 GMT

Sometimes you want your Excel spreadsheet to have a good appearance in addition to displaying the data. Rather than wrapping text in a cell or adjusting a cell's size to accommodate the text, you can shrink the text to fit.

How to Use the ROUND Functions in Microsoft Excel

Sandy Writtenhouse — Tue, 30 Aug 2022 13:00:08 GMT

When you work with decimal numbers, rounding might be part of your equation. Microsoft Excel offers a few functions to help you quickly and easily round to perfection.

Microsoft Excel Now Has an IMAGE() Function

Corbin Davenport — Mon, 29 Aug 2022 14:32:50 GMT

Microsoft Excel has supported inserting images into spreadsheets for years, but they floated above the sheet instead of appearing in cells. That's finally changing.

How to Convert Almost Any Unit in Microsoft Excel

Sandy Writtenhouse — Mon, 22 Aug 2022 13:00:41 GMT

Unit conversions are commonplace. Whether you need feet to meters, Fahrenheit to Celsius, or teaspoons to tablespoons, you can take advantage of the CONVERT function in Microsoft Excel for a dozen types of conversion.

How to Recover an Unsaved Microsoft Office File

Walter Glenn — Sun, 21 Aug 2022 17:13:00 GMT

You've just closed an Office document and accidentally clicked Don't Save. Or maybe Word crashed or your laptop lost power before you remembered to save what you were working on. We've all felt that pain, but all is not necessarily lost. By default, Office applications automatically save temporary backup copies of your documents as you work and there's a good chance you can recover them.

How to Convert Time to Decimals in Microsoft Excel

Sandy Writtenhouse — Wed, 17 Aug 2022 13:00:05 GMT

While Excel offers many features and functions for working with times, you may want your times formatted as decimals instead. You might need them for use in other formulas, for a timesheet, or for your own preference.

How to Turn Scroll Lock Off (or On) in Microsoft Excel

Mahesh Makvana — Sat, 13 Aug 2022 14:00:37 GMT

Scroll Lock in Microsoft Excel makes your Up, Down, Right, and Left Arrow keys either move between cells or scroll the entire worksheet. We'll show you how to switch between these functionalities on your Windows 10 or 11 PC.

3 Ways to Change Decimal Places in Microsoft Excel

Sandy Writtenhouse — Thu, 11 Aug 2022 13:00:28 GMT

When you work with decimals in Microsoft Excel, you may have a specific number of places you want to use. You can have Excel always use the same number of decimal places or set it for numbers as you go.

How to Send Word, Excel, or PowerPoint Files as a PDF

Sandy Writtenhouse — Wed, 10 Aug 2022 13:00:14 GMT

If you want to send a copy of your Microsoft Office file as a PDF, don't waste time with an export process. You can email it directly as an attachment right from Word, Excel, or PowerPoint.

How to Create an Amortization Schedule Using Excel Templates

Sandy Writtenhouse — Tue, 09 Aug 2022 13:00:58 GMT

If you want an easy way to view the schedule for your loan, you can create an amortization table in Microsoft Excel. We'll show you several templates that make creating this schedule easy so that you can track your loan.

How to Remove a Drop-Down List in Microsoft Excel

Mahesh Makvana — Wed, 03 Aug 2022 15:00:20 GMT

Removing a drop-down list from a Microsoft Excel spreadsheet is as easy as selecting the drop-down cells and choosing an option. This keeps the values that you've chosen while the drop-down was present. We'll show you how to do that.

How to Capitalize Text in Microsoft Excel

Mahesh Makvana — Sun, 31 Jul 2022 14:00:22 GMT

With Microsoft Excel's

How to Circle Invalid Data in Microsoft Excel

Sandy Writtenhouse — Thu, 28 Jul 2022 14:00:29 GMT

You can use data validation in Microsoft Excel to stop incorrect data entries. But there may be times when that validation doesn't work as planned. To help, you can use the Circle Invalid Data feature.

How to Add Months to a Date in Microsoft Excel

Mahesh Makvana — Mon, 25 Jul 2022 14:00:38 GMT

Want to see what date it will be after a certain number of months have passed? Using Microsoft Excel's

What Is the Office Insider Program?

Sandy Writtenhouse — Thu, 21 Jul 2022 13:00:42 GMT

You may have heard about the Office Insider program or read about new Microsoft Office application features available only to Office Insiders. If you're curious and possibly interested in becoming an Insider, here's everything you need to know.

How to AutoFill Dates in Microsoft Excel

Mahesh Makvana — Tue, 19 Jul 2022 14:00:01 GMT

If you want to fill sequential dates in your spreadsheet cells, you don't have to type them manually. Microsoft Excel offers two ways to quickly and automatically fill dates in your chosen cells. We'll show you how to use those methods.

How to Make a Simple Budget in Microsoft Excel

Sandy Writtenhouse — Sat, 16 Jul 2022 11:00:45 GMT

Keeping track of your budget, whether for yourself or your entire household, is key to money management. If you already use Microsoft Excel, you can create a budget easily using a template or making one from scratch.

How to Enable Macros in Microsoft Excel

Mahesh Makvana — Fri, 15 Jul 2022 14:00:52 GMT

Using Microsoft Excel macros, you can run a prerecorded set of steps to automate many of your repetitive tasks. You'll have to turn on the feature before you can use it. We'll show you how to activate macros on a per-spreadsheet basis as well as for all spreadsheets in Excel.

How to Delete a Sheet in Microsoft Excel

Mahesh Makvana — Fri, 15 Jul 2022 13:00:30 GMT

Don't need a specific worksheet in your spreadsheet anymore? If so, Microsoft Excel offers two easy ways to delete sheets from your workbook. We'll show you how to use them, as well as what to do if you can't delete your sheets.

How to Copy a Formula in Microsoft Excel

Mahesh Makvana — Thu, 14 Jul 2022 15:00:05 GMT

If you'd like to use the same formula across multiple cells, copy the formula instead of typing it individually in each cell. You can use both dynamic cell reference and absolute cell reference while doing this, and we'll show you how.

How to Highlight Duplicates in Microsoft Excel

Mahesh Makvana — Wed, 13 Jul 2022 13:00:06 GMT

Do you want to find and optionally delete the duplicate entries in your spreadsheets? If so, use Microsoft Excel's conditional formatting option to highlight duplicates and then select an option to remove those items. We'll show you how.

How to Unprotect a Microsoft Excel Workbook

Mahesh Makvana — Fri, 08 Jul 2022 15:00:05 GMT

Whether you want to make structural changes or modify the content in your Microsoft Excel workbooks, you'll have to unprotect those items first. We'll show you how to do just that.

Microsoft Is Finally Fixing Excel's Data Conversion Problem

Corbin Davenport — Thu, 07 Jul 2022 10:34:05 GMT

Microsoft Excel can automatically detect dates, times, currencies, and more from text and convert them into a parsed format for use in formulas. However, Excel often gets conversions wrong, especially when it comes to dates, which Microsoft is now working to address.

How to Lock Formulas in Microsoft Excel

Mahesh Makvana — Wed, 29 Jun 2022 14:00:43 GMT

To avoid getting your formulas messed up, you can lock the cells that contain formulas while keeping all other cells unlocked in your Microsoft Excel spreadsheets. We'll show you how to do just that.

7 Handy Microsoft Excel Features You May Have Missed

Sandy Writtenhouse — Mon, 27 Jun 2022 11:00:18 GMT

Sometimes when you use applications every day, new features can go unnoticed. So that you're up to speed with useful tools for your spreadsheets, take a look at these Microsoft Excel features you may have missed.

How to Use the Scenario Manager in Microsoft Excel

Sandy Writtenhouse — Mon, 20 Jun 2022 11:00:22 GMT

If you've ever had to decide between two or more financial situations, you may have done some spreadsheet manipulation. You might have entered different numbers to see the varying outcomes. But did you know you can use Excel's Scenario Manager for just that?