Site Map
Page 1 of 4 : Next Page
Pages
Posts
- Category: Charts
- Category: Customization
- Change the number of the default worksheets
- Change the number of the recently used workbooks
- How to change Excel default file location
- How to change Excel default font
- How to change worksheet tab color
- How to create a custom toolbar
- How to create, display and delete custom views
- How to hide rows based on a cell value
- How to install and load the Analysis Toolpak
- How to set a background for a worksheet
- How to view multiple worksheets at the same time
- Category: Data
- Autofill, formulas and cells references
- Automatically fill data in adjacent cells (Autofill)
- Count how often a value occurs - multiple criteria
- Count how often a value occurs within a range
- Count numbers greater than or less than a number
- How to apply a cell format to other cells
- How to collect and paste multiple items
- How to convert columns to rows, or rows to columns
- How to count blank or empty cells in a range
- How to count cells that contain data
- How to count cells that contain numbers or dates
- How to create a custom list to use in Autofill
- How to filter and count unique values among duplicates
- How to find cells that have conditional formats
- How to Find cells that have data validation
- How to format a cell based on its value (conditional formatting)
- How to format a cell based on the value of another cell (conditional formatting)
- How to hide rows based on a cell value
- How to link to values in another worksheet / workbook
- How to perform autofill without dragging the fill handle
- How to print part of a worksheet
- How to search for a text in a formula or a comment
- How to sum values based on multiple criteria
- How to summarize data using a pivot table
- How to summarize data using subtotals
- How to use Autofill with formulas
Page 1 of 4 : Next Page
Plugin by dagondesign.com
