Excel University Blog
Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.
Features
The Data Validation feature allows you to control what a user can type into a cell. This post digs into the details of the data validation alert style options. Data Validation Primer First, a quick overview of the Data Validation feature. Data Validation has been in Excel for a long time, and it is one of…
Did you know that Excel has two levels of hidden worksheets? Excel has “hidden” worksheets, and, “very hidden” worksheets. This post walks through the differences, and how to hide worksheets at each level. By default, all new worksheets are visible. A visible worksheet’s tab appears in the bottom of the Excel window, enabling the user…
Often, we use Excel to summarize detail that comes from some other program or accounting system. There are essentially three ways that I am aware of to get data from another program into a destination Excel worksheet, I’ll nickname them: Copy/Paste Pull Push Copy/Paste The Copy/Paste method is probably the most common. It is when…
Have you ever worked in a workbook with only a few worksheets…say three or four sheets? Navigating to the correct sheet is fast and easy, and you spend very little time getting to the spot you need to be to do your work. Have you ever worked in a workbook with more sheets? Say, 10,…
Overview Starting with Excel 2007, Microsoft enhanced the Excel Cell Styles feature providing great built-in choices and flexibility. The purpose of this post is to briefly discuss the styles feature and demonstrate how it can be used in conjunction with worksheet protection. Cell Styles Think of a cell style as a comprehensive set of cell…
- « Previous
- 1
- …
- 25
- 26
- 27