Excel Basics

How to Reverse Order of Columns Horizontally in Excel

Reversing the order simply means swapping the column values. Therefore indicates the very last item in the column should be the first value in the ...

How to Insert Symbol in Excel Header (4 Ideal Methods)

The article will show you some methods to insert symbol in the Excel Header. We need to use symbols to separate words or names and also we mean ...

How to Save Multiple Excel Sheets as One File (5 Methods)

  Method 1 - Using the Save As Command Steps: Select all of the spreadsheets you want to save in one file. Hold Ctrl and left-click ...

How to Track Attendance in Excel (with Detailed Steps)

  Elements of an Attendance Tracker To make an attendance tracker in Excel, you will need the following: Month Holidays Types ...

How to Save a Worksheet in Excel to a Separate File (3 Handy Methods)

Method 1 - Save an Excel Worksheet to a Separate File with the ‘Move or Copy‘ Command Steps Click on the worksheet tab/name that you want to ...

[Fixed!] Document Not Saved Excel Network Drive (5 Solutions)

You may find difficulties in saving the Excel file in the shared network drive. They often show the message Document not saved. If this problem ...

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 ...

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 ...

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 ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo