Excel Basics

How to Print Labels in Excel (With Easy Steps)

In this article, we will learn about how to print labels in Excel. Labeling is essential in terms of marketing a product, the address of a person to ...

How to Center the Print Area in Excel – 4 Methods

The dataset contains the salary statements of the sales representatives. Method 1 - Using Keyboard Shortcuts to Center the Print Area in ...

How to Turn Off AutoFill in Excel (3 Quick Ways)

We may use Excel's AutoFill tool to fill a list of similar values or a sequence of consecutive entries. It's generally shown at the bottom-right ...

How to Set Print Area in Excel (5 Methods)

In the sample dataset we only want to print a portion of the content.     Method 1 - Set Print Area From Page Layout Tab ...

Hide Rows in Excel Using Shortcuts, Commands and VBA

Method 1 - Use Format Menu to Hide Rows Click on the row number of a row >> Drag down the cursor or hold the SHIFT key to select ...

How to Remove Excel Add-In (3 Quick Ways)

Excel add-ins are used to work with additional functionality in Excel. By default, add-ins are not promptly available in Excel. We need to install it ...

How to Apply Custom Freeze Panes in Excel (3 Easy Ways)

In this article, we will demonstrate how to use custom freeze panes in Excel. We can easily lock the first row or column from the ‘Freeze Panes’ ...

How to Increase Row Height in Excel (Top 4 Methods)

A worksheet in Excel has cells that are cleanly arranged into rows and columns, where the default row height is 15 points and the default column ...

How to Sort by Name in Excel (3 Examples)

Example 1 - Use Sort & Filter Group to Sort Columns by Name To sort names alphabetically. 1.1 Sort a Column by Name Step 1: Select the ...

How to Fix If Flash Fill Not Recognizing a Pattern in Excel

  Excel Flash Fill Excel Flash Fill is a feature or tool that analyzes entries when users enter them and fills the data after recognizing a ...

How to Color Alternate Rows in Excel (8 Ways)

For decorating a dataset, you can color alternate rows in Excel. In this article, you will get to know several easiest and shortest methods to do ...

How to Move Rows in Excel (4 Simple & Quick Methods)

A lot of times, we have to move the rows in Excel datasheets to meet certain requirements. This article will show you the simple methods to Move Rows ...

How to Unmerge Cells in Excel (7 Easy Methods)

In this article, we will show you different methods to unmerge cells in Excel. To make our work easy we often merge two or more cells. Merging does ...

How to Fix Hidden Rows in Excel (4 Effective Solutions)

Dataset Overview Let’s delve into various solutions to address the issue of being unable to unhide rows in Excel. For our demonstration, we’ll work ...

How to Print Gridlines in Excel (2 Ways)

By default gridlines of a worksheet do not appear when we print it. But gridlines, rows, and column headings could be very useful to go through the ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo