Microsoft Office Excel 2003 Help
Table of contents
-
Startup and Settings
- What's new in Microsoft Office Excel 2003
- What's new in Microsoft Office 2003
-
Getting Help
- Open the Office Readme file
- Get information about your program and computer
- Icons in the Search Results task pane
- Show or hide the Type a question for help box
- Change the appearance of a Help topic
- Print a Help topic
- Troubleshoot Help
- The Office Assistant
-
Other Resources
- About the Office Resource Kit
- About research services
- About getting help while you work
- Add or change research services
- Get Help for Visual Basic for Applications
- Complete an Office Web-based training course
- Look up words in the dictionary
- Get help from Microsoft Product Support services
- Look up words in the thesaurus
- Research search tips
- Reference Encarta Encyclopedia
- Show the Tip of the Day when an Office program starts
- Microsoft Office Online
- Accessibility
-
Installing and Customizing
- Install or remove individual components in Office
- Excel specifications and limits
- What's installed with Excel
- Change Office's appearance
- Customize
- Automatically repair Office programs
- About disabled features
- What happened to the Office Shortcut Bar?
- Troubleshoot installing an Office program
- Stop being prompted to get updates for a document
- Changing What You See on the Screen
-
Changing Defaults and Settings
- About the default working folder
- Customize how Excel starts
- Show or hide actual fonts in the font list
- Change the color palette in a workbook
- Automatically start an Office program when you turn on your computer
- Change the program that starts when you open a file
- Turn off the Office Clipboard
- Show or hide toolbar ScreenTips
- Show or hide shortcut keys in ScreenTips
-
Toolbars and Commands
- About menus and toolbars
- Create a custom toolbar
- Add a button, menu, or command
- Assign a hyperlink to a toolbar button or menu command
- Delete a button or menu command
- Move or copy a button, menu, or menu command
- Assign or change a keyboard accelerator
- Attach a custom toolbar to a workbook
- Group related buttons and menus on a toolbar
- Move a submenu anywhere on the screen
- Rename a button, menu command, or menu
- Delete a toolbar or menu
- Show or hide a toolbar
- Move a toolbar
- Animate menus
- Resize a toolbar
- Add, change, or delete sounds used with buttons and menu commands
- Change a picture on a button
- Change the size of a toolbar button or drop-down list box
- Display an icon, text or both on a menu command or button
- Rename a custom toolbar
- Restore original settings for buttons, commands, or toolbars
- Save more than one toolbar configuration
- Use custom toolbars from earlier Excel versions
- Troubleshoot toolbars and menus
- Components and Add-Ins
- Upgrading Excel
-
Managing Files
- Copy the window or screen contents
- Format a disk
-
Creating and Opening Workbooks
- Move a file
- Copy a file
- Open/Save As
- Create a new workbook
- Open a file
- Open an Office Binder file
- Rename a file
- Select multiple files
- Add an open file to the Favorites folder
- Delete a file
- Connect to a network drive
- Go back to the previous drive, folder, or Internet location
- Troubleshoot opening files
-
Finding Files and Setting Properties
- About finding files
- Find a file
- Tips for finding files
- Change the default working folder
- Add or delete a shortcut from the My Places bar
- Troubleshoot finding files
- Show, hide, or change the list of recently used workbooks on the File menu
- Set or clear read-only status for a workbook file
- Tips for better search results
- View all hidden file types and file name extensions
- File Properties
-
Saving and Closing Files
- About places to save files
- Save a file
- Change the default file format for saving workbooks
- Display the Properties dialog box when saving workbooks
- Save an Office document as a TIFF file
- Troubleshoot saving files
- Save a workbook in another file format
- Save workbooks in an arranged workspace
- Troubleshoot saving and closing files
- About enabling and disabling the AutoRepublish feature
- Templates
- File Recovery
-
Handwriting and Speech
- Show or hide the Language bar
-
Handwriting Recognition
- About handwriting recognition
- About ink features in Office
- Install handwriting recognition
- Use handwriting recognition
- Handwriting recognition toolbars
- Change handwriting recognition options
- Change the handwriting recognition language
- Correct handwriting
- Select ink
- Copy and paste ink
- About using ink in Excel
- Delete ink
- Change color of ink
- Insert ink in a worksheet
- Switch pens
- Change thickness of ink
- Resize ink
- Troubleshoot ink in Excel
- Delete all ink annotations
- Handwriting in East Asian Languages
-
Speech Recognition
- About speech recognition
- Installing and Training
-
Using Speech Recognition
- About speech playback
- Getting started with speech recognition
- Format text by using speech recognition
- Things you can do and say with speech recognition
- Use speech recognition
- How to speak to a computer
- Play back worksheet data
- Turn on or off the speech recognition microphone
- Switch between using Dictation and Voice Command modes
- Turn off speech playback
- Add to or delete from the speech recognition dictionary
- Correct speech recognition errors
- Language bar speech recognition messages
- Speech Recognition Options
- Troubleshoot Handwriting and Speech Recognition
-
Printing
- About printing
- Cancel printing
- Print discussions
- Check the progress of your print job
- Print preview commands
- Troubleshoot printing
- Printer Setup
-
Print Options
- Print a worksheet to fit a paper width or a number of pages
- Select a paper source
- Print in black and white
- Preview a page before printing
- Print landscape or portrait
- Print with or without cell gridlines
- Print more than one copy
- Send a fax
- Set paper size for printing
- Set print resolution and quality
- Set the printing order of pages
- Add, delete, or move page breaks
- Define what part of the worksheet to print
- Set margins for printing
- Print row and column headings or labels on every page
- Replace error values when printing
- Print a workbook to a file
- Print a worksheet with formulas displayed
- Headers and Footers
-
Workbooks and Worksheets
- Troubleshoot workbooks and worksheets
- About Document Workspaces
-
Formatting Worksheets
- Change the color of cell gridlines
- Delete sheets
- Display or hide a workbook or sheet
- Display or hide rows or columns
- Display or hide scroll bars
- Display or hide sheet tabs
- Add color to sheet tabs
- Display or hide the status bar
- Hide cell gridlines
- Insert a new worksheet
- Name cells in a workbook
- Move or copy sheets
- Rename a sheet
- Troubleshoot formatting worksheets
- Page Setup
-
Arranging Windows and Viewing Worksheets
- About viewing workbooks and worksheets
- Change the number of worksheets in a new workbook
- Close workbook windows
- Remove the split from a window or unfreeze a pane
- Reset workbook and worksheet settings
- Switch to full or normal screen view
- View multiple sheets or workbooks at the same time
- View two parts of a sheet by splitting or freezing panes
- Zoom the display
- Minimize a window
- Minimize all program windows on the Windows desktop
- Restore a minimized window
- Compare workbooks side by side
- Saving Display and Print Settings as a View
-
Working with Data
-
Entering Data
- About filling in data based on adjacent cells
- Create, change, or delete a custom fill series
- Change which cell is selected next
- Insert a symbol
- Stop automatically completing file names and URLs
- Turn on or off automatic completion of cell entries
- Turn on or off drag-and-drop editing
- Turn on or off the message about overwriting non-blank cells
- Troubleshoot entering and selecting data
- About single-mapped cells
- Format Cells
- Entering and Editing Data
- Selecting Data
-
Editing Data
- Change the separator for thousands and decimals
- Clear cell formats or contents
- Delete cells, rows, or columns
- Edit cell contents
- Insert blank cells, rows, or columns
- Stop automatic corrections
- Turn on or off Insert Options
- Transpose rows and columns
- Undo or redo an action
- Use a data entry form to edit a range or list
- Troubleshoot editing data
- Troubleshoot automatic corrections
- Troubleshoot data validation
- Add or delete rows or columns to a list
- Create a list
- Find and Replace
- Spell Checking
-
Copying and Moving Data
- About moving and copying data
- Create a consecutive list of dates
- Display or hide the fill handle
- Fill data within a row or column
- Find cells that match a format
- Find text or numbers
- Move or copy cells
- Move rows or columns
- Prevent copied blank cells from replacing data
- Replace text or numbers
- Turn on or off Paste Options
- Paste Special
- Using the Office Clipboard
-
Filtering and Sorting Data
- About filtering
- Filter a range
- Filter by using advanced criteria
- Filter for unique records
- Find a record by using a data form
- Guidelines for entering data on a worksheet
- Remove filters
- Wildcard characters
- Default sort orders
- Sort a range
- When a range contains some numbers stored as text
- Troubleshoot sorting
- Sort
- Using Lists
-
Importing Data
- About importing data
- Import a text file
- Import or connect to data
- Troubleshoot importing data
-
Working with OLAP Data
- About installing OLAP providers
- About OLAP source data in PivotTable and PivotChart reports
- About offline cube files
- Create an offline cube file from an OLAP server database
- Create an OLAP query file to connect to an OLAP database
- Delete an offline cube file
- Include different data in an offline cube file
- Reconnect to an OLAP server
- Refresh an offline cube file
- Work with OLAP data offline
- Troubleshoot OLAP cubes
- Creating and Running Queries
- Setting Up Microsoft Query and Data Sources
-
Working with External Data on a Worksheet
- About OLAP source data in PivotTable and PivotChart reports
- Change how an imported text file looks
- Change the name of an external data range
- Copy formulas when an external data range expands
- Create a report template for importing data
- Customize field names in an external data range
- Delete an external data range
- Find an external data range
- Freeze data in an external data range
- Refresh imported data
- Specify how new data is added to an external data range
-
Formatting Data
- About formatting worksheets and data
- Borders and Shading
- Conditional Formatting
- Cell Size and Text Positioning
-
Number Formats
- Add or remove a currency symbol
- Change the number of decimal places displayed
- Convert numbers stored as text to numbers
- Create or delete a custom number format
- Display minus signs on negative numbers
- Display numbers as dates or times
- Display numbers as fractions or percentages
- Display numbers as postal codes, Social Security numbers, or phone numbers
- Display numbers with scientific notation
- Display or hide all values in a cell
- Display or hide the thousands separator in a number
- Format numbers as text
- Number format codes
- Reset a number format
- Stop rounding numbers
- Styles
- Text and Data
- Validating Cell Entries
-
Analyzing Data
- Summarizing Data in Lists and Tables
-
Performing What-If Analysis on Worksheet Data
- About Goal Seek
- Adjust the value of a cell to get a specific result for another cell
- Data Tables
-
Solver
- About Solver
- Add, change, or delete a constraint in Solver
- Change how Solver finds solutions
- Create a Solver report
- Define and solve a problem by using Solver
- Load a Solver problem model
- Reapply the default Solver settings
- Save a Solver problem model
- Save adjustable cell values in Solver as a scenario
- Step through Solver trial solutions
- Troubleshoot Solver
- Scenarios
-
Forms
- About forms
- About controls: when to use ActiveX or Forms toolbar controls
- About data entry forms
- Add a Forms toolbar control
- Add an ActiveX control
- Change a control
- Create a dialog box
- Create a macro for an ActiveX control
- Create an on-screen, printed, or Web form
- Move or resize a control
- Types of controls and their properties
- Fill out an on-screen form
- Troubleshoot controls
-
Formulas
- Creating Formulas
-
Common Formulas
- Examples of commonly used formulas
- Conditional Formulas
- Date and Time Formulas
-
Math Formulas
- Add numbers
- Calculate a running balance
- Calculate the average of numbers
- Calculate the median of a group of numbers
- Calculate the difference between two numbers as a percentage
- Calculate the smallest or largest number in a range
- Check if a number is greater than or less than another number
- Convert measurements
- Count cells that contain numbers
- Count numbers greater than or less than a number
- Create a multiplication table
- Divide numbers
- Hide error values and error indicators in cells
- Increase or decrease a number by a percentage
- Multiply numbers
- Raise a number to a power
- Round a number
- Subtract numbers
-
Text Formulas
- Change the case of text
- Check if a cell contains text
- Merge or split cells or data
- Combine first and last names
- Combine text and numbers
- Combine text with a date or time
- Compare cell contents
- Count nonblank cells
- Remove characters from text
- Remove spaces from the beginning and end of a cell
- Repeat a character in a cell
- Comparison Formulas
- Financial Formulas
-
Creating Links
- About linking to another workbook or program
- Break links
- Change the source of a link
- Change the way a linked or embedded object is displayed
- Check status of and fix links
- Control the startup prompt for updating links
- Control when links are updated
- Create a link to another cell, workbook, or program
- Create a link using Dynamic Data Exchange (DDE)
- Edit a linked or embedded object
- Find links in a workbook
- Open the source of a link
- Troubleshoot linking with other programs
- Controlling Calculations
-
Correcting Formulas
- About correcting formulas
- Allow or correct a circular reference
- Change which cells a formula refers to
- Display or hide formulas
- Display the relationships between formulas and cells
- Evaluate a nested formula one step at a time
- Find and correct errors in formulas
- Replace a formula with its result
- Remove cells from a Watch Window
- Watch a formula and its result
- Troubleshoot tracing dependent, precedent, and error cells
- Correct a ##### error
- Correct a #DIV/0! error
- Correct a #N/A error
- Correct a #NAME? error
- Correct a #NULL! error
- Correct a #NUM! error
- Correct a #REF! error
- Correct a #VALUE! error
- Working with Euro Currency
-
Charts and Graphics
-
Charts
- Creating Charts
-
Chart Display
- Change colors in a surface chart
- Change fills and lines in charts
- Change number formats in charts
- Change the display size of a chart sheet
- Change the plot area size of a pie-of-pie or bar-of-pie chart
- Change the display of multiple charts
- Change the view of a 3-D chart
- Clear a picture or fill effect from a chart item
- Make chart data easier to read by adding bars or lines
- Move and resize chart items with the mouse
- Move the slices in a doughnut or pie chart
- Place a chart on a worksheet or on its own chart sheet
- Smooth the angles of line charts
- Use a picture in a chart
- View an embedded chart in a separate window
- Vary colors in the same data series
- Chart Axes
-
Data Markers, Data Labels, and Text
- Add a chart title
- Add a legend to a chart
- Add a text box to a chart
- Add data labels to a chart
- Align text in chart titles and text boxes
- Change data labels
- Change data markers in a line, xy (scatter), or radar chart
- Change data series names or legend text
- Change the position of data labels automatically
- Change the font used in a chart
- Change the spacing between data markers in bar and column charts
- Delete data labels, titles, or legends in a chart
- Display or hide a data table in a chart
- Display or hide gridlines in a chart
- Display or hide chart tips
- Edit chart and axis titles
- Link a chart title or text box to a worksheet cell
- Link chart data labels to worksheet cells
- Rotate chart title text or axis text
-
Editing Chart Data
- Add data to a chart
- Change values in a chart
- Change the hole size in a doughnut chart
- Change the plotting order of data series
- Change the way data is shown in a chart
- Change the cell range the chart is based on
- Control the display of hidden worksheet data in a chart
- Delete data from a chart
- Format numbers in a chart like numbers on the worksheet
- Pull out slices in pie and doughnut charts
- Reverse the plotting order of categories, values, or series
-
Error Bars and Trendlines
- About error bars in charts
- About forecasting and showing trends in charts
- Add a trendline to a chart
- Add error bars to a chart
- Change error bar settings
- Change trendline settings
- Delete a trendline
- Delete error bars
- Display the R-squared value for a trendline
- Equations for calculating the error amount
- Equations for calculating trendlines
-
Drawings, Pictures, and Diagrams
- About drawing objects and pictures
- Graphics file types Excel can use
- Show or hide the Drawing toolbar
- Troubleshoot drawing objects and pictures
- About Portable Network Graphics (.png) format
- Save graphics in .png format
-
Shapes, Lines, Freeforms, and Other Drawing Objects
- Copy an object
- Add a shape
- Draw a curve
- Change a shape to another shape
- Draw a freeform shape
- Draw a line or connector
- Add or remove arrowheads
- Create a picture from cells, a chart, or an object
- Delete a picture or shape
- Determine if a picture is a bitmap or a drawn picture
- Display or hide drawing objects or pictures
- Change the shape of a freeform or curve
- Create a mirror image of an object
-
Formatting Drawing Objects
- About resizing or cropping a picture
- Copy all formatting from one object to another
- Add or format an object border
- Add or remove a shadow
- Remove an object border
- Reduce the file size of your pictures
- Add, change, or remove a fill
- Add, change, or remove the 3-D effect from a shape
- Reshape a shape
- Change font in a shape or text box
- Change the color of a shadow
- Create transparent areas in a picture
- Undo all changes to a picture
- Change the contrast or brightness of a picture
- Format a line or connector
- Apply the same height and width to different objects
- Change the margins around text in a shape or text box
- Crop a picture
- Change the color of a 3-D effect
- Change the position of a shadow
- About reducing a picture's file size
- Resize a picture or shape
- Restore a picture to its original size
- Resize a shape or text box to fit its text
- Symbols for drawing object manipulation
- Troubleshoot adding borders, fills, shadows, and 3-D effects
- Adding Special Text Effects
-
Grouping, Aligning, and Moving Drawing Objects
- Align objects
- Select objects
- Group, ungroup, or regroup objects
- Move a text box
- Move an object
- Arrange objects equal distances from each other
- Move an object in increments
- Move or reroute a connector
- Prevent objects from moving and sizing with cells
- Flip an object
- Move an object forward or backward
- Rotate an object
-
Importing Pictures and Clip Art
- About finding clips
- About the Clip Organizer
- Find a clip
- Find similar clips
- Preview a clip
- Add a clip to the Clip Organizer
- Insert a clip
- Open Clip Organizer from an Office program
- View clip properties
- Tips for finding clips
- Insert a picture from a file
- Insert a scanned or digital picture
- Troubleshoot clips
- Troubleshoot scanners and digital cameras
- Diagrams and Organization Charts
-
PivotTable and PivotChart Reports
- About PivotChart reports
- About PivotTable reports
- PivotTable terminology demystified
- What's different after you export a PivotTable list from a Web page to Excel
- Troubleshoot PivotChart reports
- Troubleshoot PivotTable reports
- PivotTable and PivotChart Wizard
-
Creating and Deleting
- About PivotTable and PivotChart source data
- Change a PivotChart report to a static chart
- Create a chart from data in a PivotTable report
- Create a PivotChart report
- Create a PivotTable report
- Select different source data for a PivotTable or PivotChart report
- Convert an Excel 4.0 crosstab table to a PivotTable report
- Delete a PivotTable report
-
Customizing the Appearance and Layout
- Ways to customize PivotTable reports
- Select data in a PivotTable report
- Change the layout of a PivotChart report
- Change the layout of a PivotTable report
- Format a PivotTable report
- Show or hide field buttons in a PivotChart report
- Sort a PivotTable or PivotChart report
- Change the amount of detail displayed in a PivotChart report
- Change the amount of detail displayed in a PivotTable report
- Display a different page in a PivotTable or PivotChart page field
- Display or hide items in a PivotTable or PivotChart field
- Group items in a PivotTable or PivotChart field
- Rename a PivotTable field or item
- Rename a field or item in a PivotChart report
- Printing
-
Summarizing with Totals and Formulas
- About calculations and formulas in PivotTable and PivotChart reports
- Display or hide totals in a PivotTable report
- Change how PivotTable or PivotChart data is summarized
- Create your own formula in a PivotTable or PivotChart report
- Edit a PivotTable or PivotChart formula
- Delete a PivotTable or PivotChart formula
- Use PivotTable data in a formula outside the PivotTable report
- Summary functions for data analysis
- Custom calculations for PivotTable and PivotChart data fields
-
Retrieving and Refreshing Data
- About OLAP source data in PivotTable and PivotChart reports
- About retrieving PivotTable or PivotChart data one page field item at a time
- Refresh data in a PivotTable or PivotChart report
- Retrieve PivotTable or PivotChart page field data for each item or for all items
- Query data for a PivotTable or PivotChart report in the background or while you wait
- Troubleshoot Charts and Graphics
-
Charts
-
Function Reference
- A bibliography of financial, statistical, and engineering methods
- Worksheet functions listed by category
- Database Functions
- Date and Time Functions
-
Engineering Functions
- Engineering functions
- BESSELI
- BESSELJ
- BESSELK
- BESSELY
- BIN2DEC
- BIN2HEX
- BIN2OCT
- COMPLEX
- CONVERT
- DEC2BIN
- DEC2HEX
- DEC2OCT
- DELTA
- ERF
- ERFC
- GESTEP
- HEX2BIN
- HEX2DEC
- HEX2OCT
- IMABS
- IMAGINARY
- IMARGUMENT
- IMCONJUGATE
- IMCOS
- IMDIV
- IMEXP
- IMLN
- IMLOG10
- IMLOG2
- IMPOWER
- IMPRODUCT
- IMREAL
- IMSIN
- IMSQRT
- IMSUB
- IMSUM
- OCT2BIN
- OCT2DEC
- OCT2HEX
-
Financial Functions
- Financial functions
- ACCRINT
- ACCRINTM
- AMORDEGRC
- AMORLINC
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- COUPNCD
- COUPNUM
- COUPPCD
- CUMIPMT
- CUMPRINC
- DB
- DDB
- DISC
- DOLLARDE
- DOLLARFR
- DURATION
- EFFECT
- FV
- FVSCHEDULE
- INTRATE
- IPMT
- IRR
- ISPMT
- MDURATION
- MIRR
- NOMINAL
- NPER
- NPV
- ODDFPRICE
- ODDFYIELD
- ODDLPRICE
- ODDLYIELD
- PMT
- PPMT
- PRICE
- PRICEDISC
- PRICEMAT
- PV
- RATE
- RECEIVED
- SLN
- SYD
- TBILLEQ
- TBILLPRICE
- TBILLYIELD
- VDB
- XIRR
- XNPV
- YIELD
- YIELDDISC
- YIELDMAT
- Information Functions
- Logical Functions
- Lookup Functions
-
Math Functions
- Math and Trigonometry functions
- ABS
- ACOS
- ACOSH
- ASIN
- ASINH
- ATAN
- ATAN2
- ATANH
- CEILING
- COMBIN
- COS
- COSH
- COUNTIF
- DEGREES
- EVEN
- EXP
- FACT
- FACTDOUBLE
- FLOOR
- GCD
- INT
- LCM
- LN
- LOG
- LOG10
- MDETERM
- MINVERSE
- MMULT
- MOD
- MROUND
- MULTINOMIAL
- ODD
- PI
- POWER
- PRODUCT
- QUOTIENT
- RADIANS
- RAND
- RANDBETWEEN
- ROMAN
- ROUND
- ROUNDDOWN
- ROUNDUP
- SERIESSUM
- SIGN
- SIN
- SINH
- SQRT
- SQRTPI
- SUBTOTAL
- SUM
- SUMIF
- SUMPRODUCT
- SUMSQ
- SUMX2MY2
- SUMX2PY2
- SUMXMY2
- TAN
- TANH
- TRUNC
- External Functions
-
Statistical Functions
- Statistical functions
- AVEDEV
- AVERAGE
- AVERAGEA
- BETADIST
- BETAINV
- BINOMDIST
- CHIDIST
- CHIINV
- CHITEST
- CONFIDENCE
- CORREL
- COUNT
- COUNTA
- COVAR
- CRITBINOM
- DEVSQ
- EXPONDIST
- FDIST
- FINV
- FISHER
- FISHERINV
- FORECAST
- FREQUENCY
- FTEST
- GAMMADIST
- GAMMAINV
- GAMMALN
- GEOMEAN
- GROWTH
- HARMEAN
- HYPGEOMDIST
- INTERCEPT
- KURT
- LARGE
- LINEST
- LOGEST
- LOGINV
- LOGNORMDIST
- MAX
- MAXA
- MEDIAN
- MIN
- MINA
- MODE
- NEGBINOMDIST
- NORMDIST
- NORMINV
- NORMSDIST
- NORMSINV
- PEARSON
- PERCENTILE
- PERCENTRANK
- PERMUT
- POISSON
- PROB
- QUARTILE
- RANK
- RSQ
- SKEW
- SLOPE
- SMALL
- STANDARDIZE
- STDEV
- STDEVA
- STDEVP
- STDEVPA
- STEYX
- TDIST
- TINV
- TREND
- TRIMMEAN
- TTEST
- VAR
- VARA
- VARP
- VARPA
- WEIBULL
- ZTEST
- Text and Data Functions
- Smart Tags
-
Working with XML
- About XML maps
- Add an XML map to a workbook
- Change the XML expansion pack attached to a smart document
- Import an XML document into an existing mapping
- Open an XML data file
- Save or export XML data
- About exporting XML data
- About The XML Source Task Pane
- About XML data bindings
- About XML lists
- Layout limitations of XML lists
- Map XML elements to a worksheet
- Unsupported XML schema constructs
- Features and limitations of XML Spreadsheet format
- XML Schema Definition (XSD) data type support
- Working with Smart Documents
-
Entering Data
- Security and Privacy
-
Excel and the Web
- Troubleshoot Excel and the Web
- About connections
- More about Office data connection and data retrieval service connection files
- Synchronize list with SharePoint site
- Use the Spreadsheet Web Part
-
Put Excel Data on the Web
- About changing data on a Web page
- Insert Hyperlink
- About putting Excel data on the Web
- About supporting Web files and hyperlinks
- About single file Web pages (MHTML)
- Change and save data on a Web page
- Guidelines and limitations for saving or publishing Web pages
- Preview a Web page
- Put Excel data on a Web page
- Set an alternative text description for a picture or shape on a Web page
- Optimize Web pages for a specific browser
-
Get and Analyze Data from the Web
- About getting data from a Web page
- Speed up downloading Web pages by using Vector Markup Language
- About XML and Excel
- Change a Web query
- Copy data from a Web page
- Make a Web page redirect queries
- Query for data from a Web page
- Refresh a Web query
- Save a Web query for use in other workbooks
- About using Microsoft Query to retrieve external data
- More about data sources
-
Hyperlinks and Web Folders
- About hyperlinks
- Create a hyperlink
- Change a hyperlink
- Copy or move a hyperlink
- Insert a formula link to worksheet data on your intranet or the Internet
- Remove a hyperlink
- Turn Microsoft Office Online featured links on or off
- Select a cell that has a hyperlink in it
- Set the base address for the hyperlinks in a workbook
- Language-specific names for Web page supporting folders
- Language-specific names for Web page supporting folders
-
Automate Web Pages
- About Java applet support
- About Web scripts
- Copy or move a Java applet
- Create a Web script on a Web page
- Remove a Java applet from a Web page
- Set the language encoding for a Web page
- View or edit a Web script
- Copy or move a Web script
- Change the default script language
- Remove Web scripts from a Web page
- Show or hide script anchors on a Web page
- Troubleshoot Web scripts
-
Work with Files on FTP Sites
- Add or remove an FTP site from the list of Internet sites
- View your Web start page
- Change the logon name or password for an FTP site
- Change your Web start page
- Change your Web search page
- Cancel the display of a Web page or hyperlink
- Refresh the display of the active file or Web page
- Show only Web toolbar buttons
- Automatically update this list from the Web
-
Sharing Information
-
With Other People
- About shared workspaces
- About Information Rights Management
- About Instant Messaging
- About Office Communities
- Create content with restricted permission
- Send an instant message
- View content with restricted permission
- About Microsoft Office Document Imaging
- Remove restricted permission from content
- Fax a workbook
- Create a Document Workspace
- Delete a Document Workspace
- Keep a Document Workspace document up to date
- Troubleshoot shared workspaces
-
Shared Workbooks
- About shared workbooks
- About resolving conflicting changes in shared workbooks
- Edit a shared workbook
- Features that are unavailable in shared workbooks
- Prepare workbooks to be reviewed and merged
- Remove a user from a shared workbook
- Resolve conflicting changes to a shared workbook
- Send a review request
- Share a workbook
- Stop sharing a workbook
- Troubleshoot shared workbooks
- Sending Data for Review
- Tracking Changes
- Marking and Reviewing Changes
- Merging Workbooks
- Comments
-
Discussions
- About receiving notification of changes to a file or discussion
- About Web Discussions
- About system requirements for discussions and subscriptions
- Subscribe to be notified of changes to a file or discussion
- Cancel subscription to a file or discussion
- Select a discussion server
- Read a discussion
- Reply to, edit, or delete a discussion comment
- Close a discussion
- Discuss a Web page or document
- Permissions for discussions and subscriptions
- Filter discussions
- Show or hide discussions
- Troubleshoot discussions and subscriptions
-
Online Meetings
- About online meetings
- Start an unscheduled online meeting
- Accept a request for an online meeting
- Schedule an online meeting
- View a list of participants in an online meeting
- Add a participant to an online meeting
- Remove a participant from an online meeting
- Open Chat in an online meeting
- Change a file in an online meeting
- End an online meeting
- Send a file to participants in an online meeting
- Troubleshoot online meetings
- Open the Whiteboard in an online meeting
-
With Other Programs
- Move or copy information between programs
- Office programs you can use to create an online or printed form
- Office programs you can use to create a table
- Exchanging Data between Excel, Word, and PowerPoint
- Exchanging Data between Excel and Access
- Using Excel and Outlook Together
-
Converting from Other Programs
- About linking Lotus 1-2-3 and Microsoft Excel worksheets
- Calculation differences between Microsoft Excel and Lotus 1-2-3 formulas
- Enter and evaluate formulas with Lotus 1-2-3 rules
- File format converters supplied with Excel
- Formatting and features that are not transferred in Excel file format conversions
- Lotus 1-2-3 keyboard equivalents
- Move around a worksheet by using Lotus 1-2-3 keystrokes
- About converting worksheets between Excel and Lotus 1-2-3
- About opening and saving files from other programs
- Create a formula to calculate data on a Lotus 1-2-3 worksheet
- Differences between Microsoft Excel and Lotus 1-2-3
- Move Excel files between Windows and the Macintosh
- Troubleshoot converting file formats
- Excel and Lotus Notes
- Troubleshoot Sharing Information
-
With Other People
- Automating Tasks and Programmability
-
Language-Specific Features
-
Language Setup
- About Microsoft Proofing Tools
- About finding and replacing characters in Indic, South Asian, or right-to-left languages
- About the global interface and Microsoft Office Multilingual User Interface Pack
- About translation services
- Check spelling in a different language
- Install system support for multiple languages
- Requirements for specific languages
- Macro language support is disabled
- Enable editing of multiple languages in Office programs
- Format cells using a different locale
- Locale identification numbers for language-specific files
- Remove commands and controls for languages you don't use
- Change the default country/region
- Change the default language setting
- Use a keyboard layout for a specific language
- Troubleshoot working in a different language
- Change the language of the user interface or Help in Office programs
- Translate text
- Automatic Language Detection
- Encoded Text Files and Unicode
- Indic
- South Asian
- East Asian
-
Right-to-Left
- About right-to-left features in Office
- About bidirectional fonts
- About code page and text layout support for right-to-left HTML Web page files
- About differences between right-to-left and left-to-right worksheets
- About global text direction
- About printing and previewing data on right-to-left worksheets
- About right-to-left language features
- Select diacritics or ligated characters
- Change global text direction settings
- Convert bidirectional text files to and from ANSI
- Create a repeating series on a right-to-left worksheet
- Display or hide control characters
- Format dates using alternate calendars
- Enter formulas containing right-to-left text in worksheets
- About right-to-left sort order
- Set a column width on a right-to-left worksheet
- Set insertion point behavior
- Set the direction for worksheets and charts
- Set the direction of a Web page or Web page controls
- Set the text direction for cells
- Switch between entering right-to-left and left-to-right text in a cell
- European
- Arabic
- Hebrew
- Vietnamese
-
Language Setup