excel - search results

We show you multiple ways to freeze and lock the rows and columns in an Excel sheet using the ribbon interface.

We show you how to allow macros in Excel for specific or all spreadsheets and how you can lock and password protect Excel spreadsheets.

We show you how to use drop down lists in Excel - creating, applying, updating and extending them.

We show you how to hide and unhide rows and columns in Excel using the mouse, hotkeys, the toolbar and how you can deal with hidden rows on the top of your table.

We show you how to compress Excel files using Binary Format for saving, removing unneded data, compressing images, clearing pivot cache and using ZIP-files to store your spreadsheets.

We show you how to use the SUM formula in Excel, how to use the AutoSum feature and how simple additions with the plus sign work.

We show how to use the Replace Feature, the TRIM funcion, and the SUBSTITUTE function to seamlessly eliminate unwanted spaces in Excel.

Master Excel division with our guide. Learn basic to advanced functions, handle errors, and optimize calculations for maximum efficiency.

Microsoft Excel offers a plethora of features to organize, analyze, and present data. One such feature is the ability to format data as tables....

We explain the different types of password protection in Excel, how they work, and how secure they are.

Excel is a powerful tool for collecting, analyzing and presenting data. However, to make the most of Excel's features, you need to structure your...

We show you how to print labels from Excel using the mail merge feature and Microsoft Word.

Microsoft Forms now syncs data with Excel for real-time updates, making analysis easier for educators and businesses.

Microsoft brings powerful data analysis to iPads with PivotTables. Users can now create, edit, and customize PivotTables directly on their tablets

Gamer hacks Excel, builds playable Tetris! Forget spreadsheets, get ready for falling blocks.

Microsoft's web versions of Word and PowerPoint are getting an update. The improved Catch Up feature now alerts you to new comments and edits

We show you how to change the date format in Excel to other local formats and using a custom format.

Microsoft's collaborative app Loop now lets users export tables directly to Excel spreadsheets, streamlining data management and analysis.

The chatbot now enables users to create tables that can be easily imported into and edited within the web version of Excel.

Microsoft Excel's new Web Connector tool makes importing data from websites easier and more efficient, with automated updates