The Cursor Keys are Not Working in Excel – 8 Solutions

This is an overview of the problem:   What Are Cursor Keys? Keyboard keys: the Up, Down, Left, Right, Home, End, PageUp, and PageDown ...

How to Adjust the Scroll Bar in Excel (5 Methods)

  Method 1 – Clearing Unnecessary Data Outside the Used Range Steps: Select the whole row after the last row of the data table. Press ...

Excel VBA: Save and Close Workbook (5 Suitable Examples)

For this tutorial, we have taken a dataset consisting of 3 columns: “Name”, “Born”, and “Latest Work”. This dataset represents 6 people’s birth year ...

How to Save Multiple Sheets in Excel to CSV (6 Easy Methods)

  Method 1 - Using Save As Command There are three worksheets in our Excel workbook. Sheet1 is the first worksheet, and its data is shown in ...

[Solved!] Vertical Scroll Not Working in Excel (9 Quick Solutions)

Reasons Behind Vertical Scroll Not Working in Excel This may happen because of the Freeze Pans command. If you see that the Show vertical ...

How to Create an Excel Theme (Step by Step Guide)

An Excel theme is a certain look of a worksheet combining specific Color Palettes, Fonts, and Effects. Excel has some built-in themes that can be ...

How to Change Autosave Time in Excel (With Quick Steps)

Sometimes, due to many unavoidable circumstances, our Excel file may shut down suddenly. This results in the loss of the changes made in the Excel ...

Round Down to Nearest 10 in Excel (3 Effective Ways)

Excel is the most widely used tool when it comes to dealing with huge datasets. We can perform myriads of tasks of multiple dimensions in Excel. ...

How to Undo a Save in Excel (4 Quick Methods)

If you are finding ways how to undo a save in Excel, this is the right place for you. Sometimes, we save work and then need to undo that in the ...

How to Save Excel as PDF Fit to Page (5 Easy Ways)

The sample dataset contains information on 21 employees in the range of cells B4:H25. Saving this dataset as a PDF will break the table over two ...

The Scroll Bar is Not Working in Excel – 5 Solutions

The following dataset represents best-sellers and their prices. Solution 1 - Unfreeze Panes If the Freeze Panes feature is enabled, no ...

How to Insert Scroll Bar in Excel (2 Suitable Methods)

Here is an overview of how to insert a scroll bar in the Excel worksheet using the Developer tab. 2 Ways to Insert Scroll Bar in Excel ...

How to See Where Excel Autosave Files Are Stored (5 Easy Ways)

We will use a workbook that contains some information about the projects of a company. Using the workbook, we will try to see where Excel AutoSave ...

How to Send Email Automatically When Condition Met in Excel

Method 1 - Use VBA Macro to Send Email Automatically Based on a Cell Value We have the following dataset of some customer details of a super shop. ...

How to Save Excel as PDF (6 Useful Ways)

Just converting an Excel to a PDF isn’t something troublesome, but making it a neat, presentable & printable PDF document is a bit tricky. I'll ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo