Excel Basics

[Fixed!] Print Preview Not Available in Excel

Solution 1 - Editing Page Layout Tab Options Steps: Go to the Page Layout tab from the Ribbon. Select Margins from the Page Setup group. ...

How to Print Borders at Page Break in Excel (2 Quick Methods)

If your dataset has only outside borders and doesn't contain borders in every row then you won't get borders at the page breaks after printing. So it ...

How to Clear Print Area in Excel (2 Easy Ways)

A print area is a set of cells that will be printed out in full. Set a print area to only contain your selection if you don't want to print the ...

How to Make a Title in Excel (3 Suitable Methods)

Suppose we have a dataset containing some months and the temperature in degrees in two locations. The dataset has no titles. Let's add some. ...

How to Hide Gridlines in Excel When Printing (4 Quick Tricks)

In this tutorial, I am going to show you 4 quick tricks on how to hide gridlines in Excel when printing a worksheet. Although Excel hides the ...

How to Change Orientation of Text to 22 Degrees in Excel (3 Ways)

While working with Microsoft Excel, sometimes we have to change the orientation of some data. We may need to arrange the texts in the most accessible ...

How to Add Same Header to All Sheets in Excel (5 Easy Methods)

Method 1 - Using the Page Setup Option to Add Same Header to All Sheets in Excel Select Page Setup sheet >> right-click on it. From the ...

How to Remove Quick Access Toolbar in Excel (4 Easy Ways)

The Quick Access Toolbar is a small customizable icon on the worksheet's upper-left side. It contains several commonly used commands. Removing the ...

How to Insert Border in Excel (3 Effective Methods)

Inserting borders in Excel refers to the process of adding lines or boundaries around cells, ranges, or tables to enhance the visual appearance of ...

How to Multiply Time by Money in Excel (with Easy Steps)

The managers in a company often find it difficult to multiply time by the rate of money to get the total daily payment. This can be easily done in ...

How to Hide Extra Columns in Excel – 4 Methods

This is the sample dataset. Method 1 - Utilizing Keyboard Shortcuts to Hide Extra Columns in Excel YStep 1: Select an entire column after ...

How to Create Table of Contents Automatically in Excel: 4 Creative Methods

Method 1 - Utilizing Keyboard Shortcut to Create Table of Contents Steps: Type in the name of the worksheet. In this case, the name of our ...

How to Put a Negative Number in Excel Formula (4 Easy Methods)

We’ll use a sample dataset with random numbers in one column and will then convert them to negative numbers in the other one by applying negative ...

Excel Formula to Return Zero If Negative Value is Found

Suppose we have a dataset of the amounts of two items and the Differences between them. There are some negative numeric values. Let's change each ...

How to Show Negative Numbers in Excel (5 Ways)

Method 1 - Using Parenthesis STEPS: Select the data range containing negative numbers. Click on the Number Format icon in the Number group. ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo