Excel Basics Archives - Page 98 of 124

How to Keep a Cell Fixed in Excel Formula (4 Easy Ways)

Jul 6, 2024

Method 1 - Use the F4 Key in Excel Formula to Keep a Cell Fixed We have a dataset of fruits with their weight, unit price, and total price. Sellers ...

How to Keep a Cell Fixed in Excel Formula (4 Easy Ways)

Excel Timesheet Formula with Lunch Break (3 Examples)

Jul 5, 2024

In this article, we will apply timesheet formulas in different time formats that take different kinds of lunch breaks into account. Example 1 ...

Excel Timesheet Formula with Lunch Break (3 Examples)

How to Delete Unused Rows in Excel (8 Methods)

Jul 15, 2024

Dataset Overview We have a dataset where users input Product Sale data. Somehow users leave unused or blank rows while entering data in the dataset ...

How to Delete Unused Rows in Excel (8 Methods)

How to Format a Cell in Excel with VBA (12 Ways)

Jul 4, 2024

Method 1 - Format Cell Horizontally or Vertically with VBA Excel’s CellFormat. The AddIndent property sets a Variable type value that indicates ...

How to Format a Cell in Excel with VBA (12 Ways)

How to Adjust Column Width in Excel (7 Ways)

Jun 16, 2024

The column width in Excel does not automatically change if the data you enter in the cell is too large to fit in the column. Either it will overlap ...

How to Adjust Column Width in Excel (7 Ways)

Applications of Excel Fill Series: 12 Easy Methods

May 29, 2024

Method 1 - Fill a Linear Series in Excel in a Column Select cell D5. Drag the Fill Handle tool to cell D10. From the dropdown of the ...

Applications of Excel Fill Series: 12 Easy Methods

How to Fix If Break Links Aren’t Working in Excel (7 Solutions)

May 26, 2024

To see if the Break Links aren't working, go to the Data tab. From the Queries & Connections group, click on Edit Links. You will ...

How to Fix If Break Links Aren’t Working in Excel (7 Solutions)

Shortcut for Merge and Center in Excel (3 Examples)

May 29, 2024

To illustrate, we have a data table with two columns and the title of the table in a single cell. Example 1 - Shortcut for Merge & ...

Shortcut for Merge and Center in Excel (3 Examples)

Create GST Invoice Format in Excel: 4 Methods

Jul 5, 2024

Method 01 - Making an Outline of GST Invoice Format 1. We need to have the basic inputs such as the Product Details in the product sheet and the ...

Create GST Invoice Format in Excel: 4 Methods

How to Use COUNTIF for Unique Text (8 Easiest Ways)

Jul 6, 2024

We'll use a sample dataset of sales information. The dataset contains two columns: Sales Person and Sales. Let's extract the unique values. ...

How to Use COUNTIF for Unique Text (8 Easiest Ways)

How to Apply Custom Format Cells in Excel (17 Examples)

Jun 27, 2024

To apply a custom format in Excel: Select the cell or range you want to format. Press Ctrl + 1 to open the Format Cells dialog box. In the ...

How to Apply Custom Format Cells in Excel (17 Examples)

How to Use Cell References in Excel Formula (All Possible Ways)

Jul 7, 2024

Method 1 - Use of Relative Cell Reference in Formila in Excel Steps: In cell F5, write the following formula to calculate the Price as a ...

How to Use Cell References in Excel Formula (All Possible Ways)

How to Use AutoFit Shortcut in Excel (3 Suitable Methods)

Jul 6, 2024

Method 1 - Apply the Keyboard Shortcuts to AutoFit in Excel In our dataset, we can apply AutoFit by using the keyboard shortcuts in two ways. The ...

How to Use AutoFit Shortcut in Excel (3 Suitable Methods)

How to Compare and Merge Excel Workbooks (3 Steps)

Jul 8, 2024

Why Do We Need to Compare and Merge Workbooks? Take a look at the following dataset: This is the Master file. Or you can see the main file. ...

How to Compare and Merge Excel Workbooks (3 Steps)

Absolute Cell Reference Shortcut in Excel – 4 Examples

Aug 9, 2024

This is an the overview. Shortcut Cell Reference Description Press F4 Single Cell or Cell Range Changes neither the column nor ...