EXCEL - Microsoft Office - Help - Microsoft Office Excel

Excel Dev
Excel help in Portuguese
Excel specifications and limits
Using Clip Organizer with earlier versions of other products
Label options
KURT
Open Clip Organizer outside of Office
Use Page Layout view to fine-tune pages before printing
Save Model and Load Model
Repeat a character in a cell
CRITBINOM
Use the Document Recovery task pane to recover your files
Cancel printing
Shadow options
CUBEVALUE
Save options
DB
FIND, FINDB
Print comments
Print
Print with landscape orientation
Proofing options
PROB
PRODUCT
PROPER
Print landscape or portrait
Print a Help topic
DDB
Change collection properties
Default sort orders
Select chart elements
OR
Overview of Excel tables
Save As
SECOND
NEGBINOMDIST
N
Send a clip in e-mail
DISC
Create an organization chart
Overview of charting
Correct a #DIV/0! error
Replace a shape
Move a shape
Diagram Conversion
Set the default printer
Use the Ribbon
UPPER
Create a new workbook
Error Bar options
EOMONTH
Fill options
FINV
Insert the current date and time in a cell
Edit a macro
Edit Series
DOLLARDE
XML for the uninitiated
Mimic a watermark in Excel
Combine text and numbers
Select different source data for a PivotTable report
Series options
Select specific cells or ranges
Move the Quick Access Toolbar
Copy or move a hyperlink
CORREL
Move or resize the Text pane
DSTDEV
Available number formats
Apply or change a Quick Style for shapes
AMORDEGRC
Add times
Use custom dictionaries to add words to the spelling checker
Change the default country/region
Format text as strikethrough
Format Text Effects (3D Format pane)
Minimize the Ribbon
MINA
DSTDEVP
Format Cells
Convert measurements
CONVERT
Display or hide chart gridlines
Display numbers as dates or times
Display numbers as fractions
INTERCEPT
Change the layout or style of a chart
FREQUENCY
Overview of macro security
Create or remove a hyperlink
Convert dates stored as text to dates
Translate text
Add, remove, or view a trusted publisher
Types of media files you can add
FACTDOUBLE
Print a worksheet or workbook
Look up words in the thesaurus
Use Formula AutoComplete
Use titles on a chart
Macro Error
Clear a data table
CHOOSE
Available chart types
AVEDEV
CEILING
CALL
DSUM
PERCENTILE
Use Microsoft Query to retrieve external data
NETWORKDAYS
Move or copy rows and columns
ASCII character chart
AMORLINC
Hide or display rows and columns
Correct a #N/A error
Correct a ##### error
Correct a #NAME? error
Correct a #NULL! error
Correct a #NUM! error
Correct a #REF! error
Correct a #VALUE! error
COUNTBLANK
Excel table issues
EVEN
RIGHT, RIGHTB
Wildcard characters
WEEKDAY
WEEKNUM
image_manifest
COSH
COS
Create or change a cell reference
Divide numbers
Hide or display formulas
HLOOKUP
Excel Services Options
Look up words in the dictionary
Count how often a value occurs
Add numbers
Advanced options
Show or hide ScreenTips
IS Functions
INT
Calculate a running total
DURATION
INTRATE
Calculate the difference between two dates
Calculation operators and precedence
Create a new collection
Add or change a caption for a clip
SUMPRODUCT
NA
DMIN
CELL
RANDBETWEEN
RAND
Count days before a date
ROUNDDOWN
COUPDAYBS
DVARP
Count unique values among duplicates
COUPDAYSNC
COUPDAYS
Create a chart
Change a hyperlink
EDATE
Copy a file
Convert times
Change the color of text
Check if a cell contains text (case-sensitive)
Combine text with a date or time
Compatibility Checker
COMBIN
CONCATENATE
Display or hide zero values
DMAX
Replace a formula with its result
Rename a file
SQL.REQUEST
STANDARDIZE
Use Office Excel with earlier versions of Excel
Create or delete a formula
TBILLPRICE
SYD
Create, apply, or remove a chart template
CUBESET
Add-ins
ADDRESS
WEIBULL
VALUE
DATEVALUE
EXACT
EXP
HYPERLINK
Remove subtotals
SQRT
DAVERAGE
DAYS360
DCOUNTA
CUBEKPIMEMBER
CUBEMEMBER
CUBEMEMBERPROPERTY
CUBERANKEDMEMBER
CUBESETCOUNT
EFFECT
Customization issues
CUMIPMT
CUMPRINC
Data Table options
ERFC
IFERROR
MINVERSE
MROUND
NPER
SIGN
TINV
TREND
What happened to Detect and Repair?
XIRR
YIELD
YEAR
A bibliography of statistical methods and algorithms
BINOMDIST
BESSELK
BESSELY
BETADIST
DAY
DCOUNT
BIN2HEX
BIN2OCT
CHAR
Copy the window or screen contents
DEC2HEX
DEC2OCT
DEGREES
DEVSQ
ERROR.TYPE
NORMSDIST
ERF
Go To
HEX2DEC
HEX2OCT
Total the data in an Excel table
HOUR
IMCOS
IMDIV
IMEXP
IMLN
IMLOG10
IMLOG2
IMPOWER
IMREAL
IMSIN
EUROCONVERT
Information functions
IMSUB
IMSUM
INDEX
OCT2DEC
OCT2HEX
ODD
ACCRINTM
ACOSH
AND
COUPNCD
COUPNUM
COUPPCD
COVAR
Customize the Quick Access Toolbar
DEC2BIN
DELTA
DOLLARFR
DOLLAR
DPRODUCT
DVAR
FACT
GAMMAINV
IPMT
IRR
ISEVEN
JIS
LOG
MMULT
IMARGUMENT
IMCONJUGATE
IMPRODUCT
NORMDIST
NPV
OCT2BIN
POISSON
PRICE
PRICEMAT
PV
QUARTILE
RECEIVED
REPT
IMSQRT
INDIRECT
SLOPE
Symbol
TDIST
VLOOKUP
XNPV
YEARFRAC
YIELDMAT
ZTEST
CHIDIST
LEFT, LEFTB
ISPMT
Find a clip
NOMINAL
NORMINV
VARA
Apply, create, or remove a cell style
Create a Document Workspace site
FDIST
Create a macro
IMABS
IF
NOW
PEARSON
TRUNC
Look up values in a list of data
AREAS
ASC
CLEAN
COLUMNS
COMPLEX
INFO
Insert Function
LOWER
MDURATION
Open
ROWS
GAMMADIST
Run a macro
SINH
WORKDAY
MAXA
MAX
ACCRINT
Add dates
MID, MIDB
ACOS
ATAN2
ASIN
AVERAGEA
ATAN
ATANH
ODDFYIELD
ODDLPRICE
ODDLYIELD
Open a file
CHIINV
COUNTA
COUNT
COUNTIF
Print a file
DGET
EXPONDIST
Field settings
FORECAST
GEOMEAN
ISODD
LEN, LENB
LOG10
Logical functions
TBILLYIELD
Terms of use
LOGEST
MEDIAN
MIRR
MODE
MONTH
NORMSINV
OFFSET
Insert or delete a worksheet
PMT
Examples of commonly used formulas
PPMT
QUOTIENT
RADIANS
LARGE
REGISTER.ID
RANK
ROUND
ROUNDUP
ROW
SIN
LOGNORMDIST
Solver Options
SQRTPI
Statistical functions
SUM
SUMIF
SUMIFS
SUMSQ
SUMX2MY2
TANH
SUMX2PY2
SUMXMY2
TBILLEQ
TAN
TTEST
AVERAGE
AVERAGEIF
BETAINV
BIN2DEC
Clip properties
HYPGEOMDIST
CHITEST
CODE
COUNTIFS
Count nonblank cells
Count the number of words in a cell or range
DATE
FALSE
FISHERINV
Format an Excel table
Trendline options
FTEST
FV
GAMMALN
GCD
GESTEP
HARMEAN
HEX2BIN
LCM
LINEST
LN
LOOKUP
MDETERM
Merge cells or split merged cells
MINUTE
MIN
MOD
Number options
NOT
PERCENTRANK
PHONETIC
POWER
Raise a number to a power
RATE
RTD
Financial functions
SLN
SMALL
STDEVA
STDEVPA
STDEV
STEYX
STDEVP
SUBTOTAL
TEXT
TODAY
TRIM
TRUE
TYPE
VARPA
VAR
VDB
VARP
Multiply numbers
ASINH
BESSELI
Clip Organizer can't find my clip
COLUMN
Excel shortcut and function keys
FLOOR
Legend options
Rename a collection
LOGINV
MATCH
PERMUT
RSQ
PI
Show dates as days of the week
Round a number
TIMEVALUE
T
TRIMMEAN
View my privacy options
Find and correct errors in formulas
Find a printer
FISHER
Add or delete WordArt
Text functions
Filter data in a range or table
Recolor a picture from the Clip Organizer
Sorting and filtering issues
Add, change, or delete keywords for a clip
SEARCH, SEARCHB
SUBSTITUTE
Find the content you need in the Help window
Convert Arabic to Roman numerals
AVERAGEIFS
Axis Labels
Marker options
ROMAN
Calculate a running balance
Inspect workbooks for hidden data and personal information
SKEW
Connect to (import) an OLAP database
Convert an Excel table to a range of data
Remove characters from text
Create a new file
Change data markers in a line, xy (scatter), or radar chart
TIME
Cube functions
GROWTH
Export data to a SharePoint list
Overview of formulas
Date and time functions
FIXED
Text Import Wizard
FVSCHEDULE
3D Format options
GETPIVOTDATA
Create a new folder
Preview worksheet pages before printing
Insert Julian dates
I have an error in my formula
Line Color options
Create, edit, or delete a PivotTable or PivotChart formula
Rename a field or item in a PivotTable or PivotChart report
Marker Fill options
File formats that are supported in Excel
Use Windows to make your Office experience accessible
Import or export text files
3D Rotation options
ODDFPRICE
Overview of sharing and collaborating on Excel data
PivotTable issues
Create, remove, or change a trusted location for your files
Play sound and motion clips
Work with Office safe modes
Worksheet issues
Create an external reference (link) to a cell range in another workbook
Select Data Source
Select one or multiple worksheets
Select multiple files
Move a SmartArt graphic
Subtract numbers
Combine first and last names
REPLACE, REPLACEB
Save a file
Rename a PivotTable or PivotChart report
Display numbers as currency
How Office helps protect you from phishing schemes
Filter for unique values or remove duplicate values
Use a shared workbook to collaborate
Wrap text in a cell
Check a workbook for compatibility with earlier versions of Excel
TRANSPOSE
Create, edit, or remove a calculated column in an Excel table
Summary functions available in PivotTable reports
About this dialog box
CONFIDENCE
Switch between relative, absolute, and mixed references
Format chart elements
Customize the list of recently used files
Load or unload add-in programs
Copy a clip into another collection
Connect to (Import) external data
Create a SmartArt graphic
Resize a shape or an entire SmartArt graphic
Alignment options
Select data in a PivotTable report
Switch the layout or type of a SmartArt graphic
Find and Replace
Formula issues
Split names by using the Convert Text to Columns Wizard
Calculate percentages
Data Analysis
Data sources that you can access
Prompt to open a file as read-only
Define workbook parameters for use in Office Excel Web Access
PivotTable options
Popular options
PRICEDISC
YIELDDISC
ABS
Repairing a corrupted workbook
Group items in a PivotTable
IMAGINARY
You talk, we listen and respond
Change the color, style, or weight of a line
Create conditional formulas
Display only the last four digits of identification numbers
Change the screen resolution
Database functions
Prevent changes to a final version of a document
Check a file in or out of a SharePoint library
Change formula recalculation, iteration, or precision
Change the scale of the horizontal (category) axis in a chart
Change the scale of the vertical (value) axis in a chart
Check spelling and grammar
Add or remove data labels in a chart
BAHTTEXT
Print an Excel table
Fill data automatically in worksheet cells
Add or remove Excel table rows and columns
Enable or disable add-ins in Office programs
Paste Special when copying from Excel
Digitally sign an Office document
Keyboard shortcuts for SmartArt graphics
Publish a workbook to Excel Services
Apply or customize a document theme
View my security settings in the Trust Center
Collaboration issues
Prevent invalid data entry in a worksheet
Disclaimer: Use of Fictitious Names
Hidden and Empty Cell Settings
What happened to Excel lists?
Publish as PDF or XPS
Axis options
Delete a custom theme
Display hidden data and empty cells in a chart
Remove spaces and nonprinting characters from text
Preview a page before printing
SERIESSUM
Line Style options
View or change the properties for an Office document
I can't see a command on the Ribbon
How to tell if a digital signature is trustworthy
BESSELJ
Calculate the factorial or permutation of a number
Enable or disable security alerts on the Message Bar
Enable or disable macros in Office documents
Remove languages and fonts that you don't use
Engineering functions
Filter by using advanced criteria
Enable support for other file formats, such as PDF and XPS
Set or rename a default working folder
Enable Windows to support typing text in another language
View the Privacy Statement
Allow, remove, or correct a circular reference
Create scenarios for what-if analyses
Count all of the cells in a range
Working with different PivotTable formats in Office Excel
Delete a clip from a collection
Correct common errors in formulas
Align or center text
Delete a file
Connection properties
Edit cell contents
Select a paper source
Modify clip art
Select all cells on a worksheet
Add a clip to your document
Delete a collection of clips
Load the Solver Add-in
Move a file
Load the Analysis ToolPak
Lookup and reference functions
Show Trial Solution and Save Scenario
Show or hide the Text pane
Move a clip from one collection to another
I get an MStore.mgc is corrupt error message
Change the display of chart axes
Enable entering text in another language in Office
Restore the default layout and color
Enable or disable ActiveX controls in Office documents
Add or remove a sheet background
About organizing clips
Add a picture to a SmartArt graphic
Add a shape to a SmartArt graphic
Link to a Business Contact Manager for Outlook record
Activate Microsoft Office programs
Add, delete, or move page breaks
Open or edit a file in a SharePoint library
Keyboard shortcuts for Microsoft Clip Organizer
Set up a new printer
Project values in a series
Undo, redo, or repeat an action
Add or delete arrowheads
Register for online services on Office Online
Using the CALL and REGISTER Functions
Command-line switches for Excel
Move a PivotTable report
My Office program did not open a recovered file
Learn more about SmartArt graphics
Naming files and attachments
MULTINOMIAL
Create or delete an Excel table
Delete a shape from a SmartArt graphic
Solver Parameters
Consolidate data in multiple worksheets
Format Object (Line Color pane)
Design the layout and format of a PivotTable report
Insert a symbol, fraction, or special character
Add clips to Clip Organizer
Add or remove a secondary axis in a chart
Edit titles or data labels in a chart
Format Text Effects (Outline Style pane)
Format Text Effects (Text Outline pane)
Formula calculation, performance, and error handling options
Format Text Effects (Shadow pane)
Format Text Effects (Text Fill pane)
Save a file in PDF format
Move or copy a formula
Resize the formula or name box in the formula bar
Save a file in XPS format
Manage conditional formatting rule precedence
Use automatic formatting as you type
Solver Results
Rotate or flip a SmartArt graphic shape
Format Object (Fill pane)
My animated GIF won't play
My deleted clips keep coming back
Format Object (3D Rotation pane)
Descriptions of SmartArt graphics
Format Object (Line Style pane)
Format Object (Shadow pane)
Apply or remove cell borders on a worksheet
Format Object (Text Box pane)
Change the case of text
Format text as bold, italic, or underlined
Save a workbook in another file format
Add or delete a fill, outline, or effect for text or WordArt
Add bullets to a shape
Add, change, or clear conditional formats
Combine or split the contents of cells
Conditional formatting issues
Read the Microsoft Software License Terms
Diagnose and repair crashing Office programs by using Office Diagnostics
Format Object (3D Format pane)
Overview of the Text pane used with SmartArt graphics
Create a multiplication table
Check if a cell contains text (case-insensitive)
Outline a list of data in a worksheet
Save a SmartArt graphic
Use exclusion dictionaries to specify a preferred spelling for a word
Refresh connected (imported) data
List of worksheet functions (by category)
Math and trigonometry functions
About adding clips to Clip Organizer
About Clip Organizer collections
Sort data in a range or table
Turn Excel table headers on or off
Import data from a SharePoint list
Sort data in a PivotTable report or a PivotChart report
Split text among columns by using functions
Insert or delete cells, rows, and columns
Plot data series from worksheet rows or columns
Get featured links from Office Online
Use the keyboard to work with Ribbon programs
Control when external references (links) are updated
Use names to clarify formulas
Draw or delete a line, connector, or freeform shape
Find cells that have conditional formats
Convert numbers stored as text to numbers
Protect worksheet or workbook elements
Scan and insert an image in Clip Organizer
Hide error values and error indicators in cells
Spelling or grammar checker flags text I don't want or expect it to flag
Block or unblock external content in Office documents
Setup command-line switches for the Office system
Locale identification numbers for language-specific files
Select a hyperlink without activating the link
Turn automatic completion of cell entries on or off
Using structured references with Excel tables
View additional information and hidden content that has been signed
Format Object or Format Background (Picture pane)
Check if a number is greater than or less than another number
Filter data in a PivotTable report or PivotChart report
Add, edit, or delete a comment
Add or delete a shape fill or shape effect
What happened to the File menu?
Print row and column headings or labels on every page
Print with or without cell gridlines
Work with the Help window
Evaluate a nested formula one step at a time
Choose a SmartArt graphic
Enter data manually in worksheet cells
I see a blank thumbnail when I add clips
I see a red X instead of my clip
What happened to the Office Assistant?
What's new in Microsoft Office Excel
Create a desktop shortcut for an Office program
Define and solve a problem by using Solver
Graphics, object, and ActiveX control issues
Insert subtotals in a list of data in a worksheet
Undo check-out and discard changes in a SharePoint library
Change the font or font size in Excel
Add-in and Automation functions
Move or scroll through a worksheet
Count cells that contain numbers
Add or change page headers and footers
Apply or remove cell shading
Automatically correct capitalization
Format text as superscript or subscript
Copy a macro module to another workbook
Digitally sign a macro project
Display numbers as percentages
Show the Developer tab or run in developer mode
Nest a function within a function
What and where is the Microsoft Office Button?
Create or delete a PivotTable or PivotChart report
Format Text Effects (Picture pane)
Use access keys from Office 2003 in Ribbon programs
Calculate a compound annual growth rate (CAGR)
Subtotal and total fields in a PivotTable report
Watch a formula and its result by using the Watch Window
Format Text Effects (Text box pane)
Ribbon, Help, and other Microsoft Office keyboard shortcuts
Change the scale of the depth (series) axis in a chart
Do you want to view recovered files again?
Format Text Effects (3D Rotation pane)
Change the appearance of a Help topic
Check the progress of your print job
Calculate the difference between two times
Calculate the median of a group of numbers
Calculate multiple results with a data table
Calculate the mode of a group of numbers
Change a data consolidation of multiple worksheets
Calculate the smallest or largest number in a range
Create an offline cube file from an OLAP server database
Convert PivotTable cells to worksheet formulas
Freeze or lock rows and columns
Choose how spelling and grammar checking work
Compact the main Clip Organizer catalog
Introduction to new file name extensions and Office XML Formats
Remove the data connection from an external data range
Workbook contains a user form or class module
Create a connection to a shared network folder
Open the Organization Chart Add-in for Microsoft Office Programs
Convert numbers to different number systems
Look up words in the English Assistant
Add, change, or delete shapes
My recovered file or item does not contain my changes
Create a drop-down list from a range of cells
Make a shape invisible in a SmartArt graphic
Locate the Product ID for your Office program
Excel formatting and features that are not transferred to other file formats
Exchange (copy, import, export) data between Excel and Access
Overview of PivotTable reports and PivotChart reports
Overview of security and protection in Excel
Where can I find Microsoft Office Organization Chart?
Add Constraint and Change Constraint
Accessibility tips when working with a SmartArt graphic
Insert the current Excel file name, path, or worksheet in a cell
Select cells and their contents on a worksheet
Move or copy cells and cell contents
Custom calculations for PivotTable data fields
Get or create your own digital ID
Change the column width and row height
Allow cells to be edited in a protected worksheet
Calculate the average of a group of numbers
Get help from Microsoft Support Services
Get targeted help on a program or feature
Get online Help, templates, training, and additional content
Where can I find the Readme or Known issues list?
Organize quick file access by using the My Places bar
Overview of finding and replacing characters in Indic, Southeast Asian, and right-to-left languages
Participate in the Customer Experience Improvement Program
Differences between using a workbook in Excel and Excel Services
Get Help on developing solutions using Visual Basic for Applications
I get a missing or corrupt graphics filter or media player error message?
Change the date system, format, or two-digit year interpretation
Avoid losing work when an Office program closes abnormally
Digitally sign an Office document with a stamp
Open an Office Excel workbook in an earlier version of Excel
Save a file to a SharePoint library or another Web location
I can't find a previously available catalog
Display the relationships between formulas and cells
What happened to the Options command on the Tools menu?
Show or hide the thousands separator
Roadmap for publishing an Excel workbook as "one version of the truth"
Install or remove individual Office programs and components
Change the chart type of an existing chart
Keep your computer updated by using Microsoft Update
Identify which program to use to create an organization chart
Remove a digital signature from an Office document
Open or change source workbooks of external references (links)
Edit or remove a workbook from Excel Services
Remove hidden data and personal information from Office documents
Reapply a filter and sort, or clear a filter
I get a file conversion error when I try to open a document
What happened to the Type a question for help box?
Send a document in an e-mail message
Get the result you want by adjusting a value by using Goal Seek
What uses of photos, clip art, and font images are prohibited?
What happened to the PivotTable and PivotChart Report command?
Why am I getting a message that says to troubleshoot my Internet connection?
Work with a Document Workspace site from an Office program
Promote your business with Marketing Campaigns in Business Contact Manager
Perform statistical and engineering analysis with the Analysis ToolPak
Go back to the previous folder, drive, or Internet location
Restrict permission to confidential information in Office files
Enable or disable security alerts about links to and files from suspicious Web sites
I can't find the advanced settings I used in earlier versions of Office
Get the latest online content while working in the release
Get the version number for your Office program and information about your computer
Change the border of a shape in a SmartArt graphic
Clear a PivotTable report or PivotChart report
A bibliography of financial, statistical, and engineering methods
About installing clip files and clip collections
Automatically correct spelling and insert text and symbols by using words in a list
Activate or renew your Microsoft Office subscription from Office Live
Add formatting to your document by using the Mini toolbar
Add or delete a fill or effect in your SmartArt graphic
Anything above marked with a red X will not appear in this SmartArt graphic and will not be saved message
Change the color of a shape, shape border, or entire SmartArt graphic
Combine two or more columns by using a function
Change the summary function or custom calculation for a field in a PivotTable report
Count numbers greater than or less than a number
Copy and paste multiple items by using the Office Clipboard
Create a 3D reference to the same cell range on multiple worksheets
Create and change the field layout in a PivotTable or PivotChart report
Set a password to open or modify a document, workbook, or presentation
Create, edit, and manage connections to external data
Enable another language in the interface of Office programs
Expand or collapse details in a PivotTable report or PivotChart report
Use a report filter in a PivotTable report or PivotChart report
Enable Windows XP support for certain languages (East Asian, Southeast Asian, Indic, and right-to-left languages)
I cannot link to a record in Business Contact Manager from a program in an Office suite
Make your SmartArt graphic look like an example in the SmartArt graphics dialog box
The spelling or grammar checker isn't checking words in another language correctly