Video
How to use the Quick Access Toolbar
In this video, we show you how to add your own commands to the Quick Access Toolbar.Read more
Search results
Looking for more? Try chatting with the Exceljet Chatbot.
Video
How to insert and delete worksheets
In this video we show you how to insert new worksheets to a workbook, and how to remove existing worksheets from a workbook.Read more
Video
How to name and format worksheet tabs
In this video we show you how to rename worksheet tabs, and how to format them with color.Read more
Video
How to move and copy worksheets in Excel
In this video we show you how to move and copy worksheets in the same workbook.Read more
Video
How to move and copy worksheets to other workbooks
In this video we show you how to move and copy worksheets to other workbooks.Read more
Video
How to hide and unhide worksheets
In this video we show you how to hide and unhide worksheets which is useful when you want to simplify your workbooks.Read more
Video
How to freeze columns or rows in a list
In this video we show you how to freeze columns and rows in a big list so that they don't scroll off the screen...Read more
Video
What is conditional formatting?
In this lesson we show you what conditional formatting is by applying a simple rule to a set of sales numbers.Read more
Video
How to create a conditional formatting rule
In this video we show you how to create a basic conditional formatting rule.Read more
Video
How to highlight duplicates in a list
In this video we show you a way to highlight duplicate rows in a table that has many duplicate values.Read more
Video
How to revise a conditional formatting rule
In this lesson we show you how to easily change a basic conditional formatting rule.Read more
Video
Anatomy of an Excel chart
In this video we walk you through a sample chart and give you the names that Excel uses for each object in the chart.Read more
Video
How to add additional conditional formatting rules
In this video we show you how to add more conditional formatting rules to your worksheet, and how to set the order that they are applied.Read more
Video
How to create a basic chart
In this video we show you how to create a basic chart in Excel.Read more
Video
How to add a conditional formatting key
In this lecture, we show you how to add a key to the worksheet that shows the rules used to apply conditional formatting.Read more
Video
How to move and resize a chart in Excel
In this video we show you how to move a chart to different locations on your worksheet, and how to resize a chart by dragging size handles, and by entering measurements.Read more
Video
How to delete conditional formatting rules
In this video we show you how to delete a conditional formatting rule, and how to clear all rules at once.Read more
Video
How to create a standalone chart
In this video we show you how to convert an embedded chart to a standalone chart, and back again. Standalone charts have a worksheet all to themselves and print on their own page.Read more
Video
How to highlight top and bottom values
In this lecture, we show you how to create a conditional formatting rule to highlight the top and bottom numbers in a set of data.Read more
Video
How to edit and add to chart data
In this video we show you how to keep a chart up to date with new data, and how to add new data to an existing chart.Read more
Video
How to highlight above and below average values
In this lecture, we show you how to create a conditional formatting rule to highlight numbers that are above or below average in a set of data.Read more
Video
How to add a title and legend to a chart
In this video we show you how to add a title and a legend to a chart. We also show you how to move these elements around on a chart.Read more
Video
How to use data bars with conditional formatting
In this lecture, we show you how to create a conditional formatting rule that uses data bars to visualize numbers.Read more
Video
How to use a formula with conditional formatting
In this video, we show you how to create a conditional formatting rule that uses a formula to highlight cells that meet specific conditions not included in Excel's presets...Read more
Video
How to use color scales with conditional formatting
In this lecture, we show you how to create a conditional formatting rule that uses color scales to visualize numbers.Read more
Video
How to show duplicate values with conditional formatting
In this video, we show you how to create a conditional formatting rule highlights duplicate values in a set of data.Read more
Video
How to use Icon sets with conditional formatting
In this video, we show you how to create a conditional formatting rule that uses icons to visualize numbers.Read more
Video
How to highlight text values with conditional formatting
In this video, we show you how to create a conditional formatting rule highlights cells that contain specific text values.Read more
Keyboard shortcut
Display AutoComplete list
This shortcut allows you to display various lists within Excel without using a mouse.
With Alt + down arrow, you can access lists in 3 different contexts:
(1) Access autocomplete items when doing repetitive data entry in a column – previously entered values in cells above will be...Read more
Video
How to find and replace a value
In this video we'll look at how to replace what you've found. Find and replace is a powerful tool when making global changes to worksheets...Read more