Video
How to use relative references - example 2
In this video we show you how relative references work with one of the most useful functions of all time: the SUM function.Read more
Search results
Looking for more? Try chatting with the Exceljet Chatbot.
Video
How to hide and unhide columns and rows in Excel
In this video, we show you how to hide and unhide columns and rows.Read more
Video
What's an absolute reference?
In this video we explain the concept of an absolute cell reference; an extremely important concept in Excel formulas.Read more
Video
How to use absolute references - example 1
In this video we show you how to use an absolute address to fix a reference in a simple example about hours worked at a certain pay rate.Read more
Video
How to use absolute references - example 2
In this video we show you how to use partially absolute references - helpful when you need to fix one part of an address, but let other parts change.Read more
Video
Named ranges as absolute references
In this video we show you how to name a range and use it as an absolute reference. Named ranges make formulas a lot easier to read.Read more
Video
What is a number format in Excel?
In this video we explain what number formats are and how they are used in Excel.Read more
Video
How to apply general formatting in Excel
In this video we show you how the General format works. The General format is Excel's default format...Read more
Video
How to use number formatting in Excel
In this video we show you how to format numbers with the basic number format.Read more
Video
How to use currency formatting in Excel
In this video we show you how to use the currency number format.Read more
Video
How to use accounting formatting in Excel
In this video we show you how to use the Accounting number format.Read more
Video
How to use date formatting in Excel
In this video we show you how to format dates in a variety of ways.Read more
Video
How to use percentage formatting in Excel
In this video we show you how to use the Percentage number format.Read more
Video
How to use time formatting in Excel
In this video we show you how to format times in a variety of ways.Read more
Video
How to use fraction formatting in Excel
In this video we show you how to format numbers as fractions.Read more
Video
How to use scientific formatting in Excel
In this video we show you how to format numbers in scientific notation.Read more
Video
How to use text formatting in Excel
In this video we show you how to format numbers as text. This is useful for part numbers, zip codes, and other numbers that start with zero.Read more
Video
How to use special formatting in Excel
In this video we show you how to use the special number formats built into Excel, including phone numbers, zip codes, and social security numbers.Read more
Video
How to create a custom number format in Excel
In this video we show you how to create your own custom number format.Read more
Video
How Excel stores dates and times
In this video we explain how Excel stores dates and times.Read more
Video
How to create a custom date format
In this video we show you how to create your own custom date format.Read more
Video
How to create a custom time format
In this video we show you how to create your own custom time format.Read more
Video
How to wrap text in cells in Excel
In this video we show you how to enable and disable text wrapping in cells.Read more
Video
How to apply horizontal alignment in Excel
In this video we show you how to apply horizontal alignment.Read more
Video
How to use fill, justify, and distributed in Excel
In this video we show you how the Justify, Fill, and Distributed Alignment options work.Read more
Video
How to align text vertically in Excel
In this video we show you how to align text vertically in cells.Read more
Video
How to indent cell content in Excel
In this video we show you how indents work in Excel, which alignment options they work with, and how to increase and decrease the indent level.Read more
Video
How to align text across cells with merge in Excel
In this video we show you how to use merge to align text across cells. Merge is easy and works well, but be sure to check out Center Across Selection for an option that doesn't interfere with Excel's grid...Read more
Video
How to use Center Across Selection in Excel
In this video we show you how to use a lesser-known alignment option called Center Across Selection to center text without changing the worksheet grid.Read more
Video
How to use Shrink to fit in Excel
In this video, we show you how Shrink to fit works. Shrink to fit is useful in cases where you have a fixed column width and text that varies somewhat in length.Read more