documentation
.HELP!
Microsoft Datasheet View Documentation
Me
Microsoft Datasheet View
previous page
next page
Me
Returns the current user name.
Syntax
Me
Remarks
The Me function can only be used with default values; you cannot use the Me function in a calculated column.
previous page
start
next page
Menu
Homepage
Table of contents
Startup and Settings
About Datasheet view
About software requirements for Datasheet view
Get help in Datasheet view
Display product and computer information in Datasheet view
Troubleshoot Datasheet view
Customizing Datasheet Views
About customizing Datasheet view in FrontPage
About applying a theme to a Datasheet view
Make Datasheet view the default view
Show, hide, or resize the task pane
Accessibility
Keyboard shortcuts for working in Datasheet view
Performance
About improving Datasheet view performance
Working with Data
How does Datasheet view retrieve and update data?
Select a cell, row, column, or list in Datasheet view
Working with Rows and Columns
Add a row or column in Datasheet view
Modify a column in Datasheet view
Rearrange columns in Datasheet view
Troubleshoot dragging and dropping data
Show or hide a column in Datasheet view
Delete a row or column in Datasheet view
Change column width in Datasheet view
Change row height in Datasheet view
Editing Data
About data types
Troubleshoot data types
Specify a default value for a column in Datasheet view
Add, edit, or delete cell contents in Datasheet view
Edit a hyperlink in Datasheet view
Enter data in a cell by selecting from a list of values in Datasheet view
Undo changes in Datasheet view
Validate data
Get notified when contents of a list are modified
Formatting Data
Format data in Datasheet view
Turn on or off text wrapping for a column in Datasheet view
Troubleshoot formatting data in Datasheet view
Filtering and Sorting
About filtering data in Datasheet view
Apply a filter in Datasheet view
Sort rows in Datasheet view
Remove a filter or sort order in Datasheet view
Troubleshoot sorting and filtering in Datasheet view
Bulk-editing Data
About moving, copying, and pasting cell contents in Datasheet view
Troubleshoot moving, copying, and pasting cell contents in Datasheet view
Automatically fill cells with data
Troubleshoot automatically filling cells with data
Displaying Real-time User Status (Presence Information)
About displaying real-time status (presence information) in Datasheet view
View presence information in Datasheet view
Troubleshoot displaying presence information in Datasheet view
Working with Lists Requiring Content Approval
Submitting data changes to a list manager for approval in Datasheet view
Approve or reject pending items in Datasheet view
Working with Document Libraries and Attachments
About working with document libraries in Datasheet view
Open a folder or document in Datasheet view
Edit a document in Datasheet view
Delete a folder or document in Datasheet view
Check in or out a document in Datasheet view
Add, view, or remove documents attached to a row in Datasheet view
View versions of a document in Datasheet view
Make a document available for discussions in Datasheet view
Troubleshoot document libraries in Datasheet view
Resolving Conflicts and Errors
About resolving conflicting changes in Datasheet view
When do conflicts occur?
About resolving errors in Datasheet view
Resolve conflicting changes and errors in Datasheet view
Working with Other Programs
Exporting Datasheet Views
About exporting a Datasheet view
Export contact or event information
Export and link a Datasheet view to Excel
Export or link a Datasheet view to Access
Troubleshoot exporting Datasheet views
Working with Access
Create an Access report with a Datasheet view
Working with Excel
Create an Excel chart with a Datasheet view
Create an Excel PivotTable with a Datasheet view
Print a Datasheet view with Excel
Totals and Calculated Values
About displaying totals and calculated values in Datasheet view
About formulas
About calculation operators
About constants in formulas
About column references in a formula
Examples of common formulas
Show or hide aggregate values in Datasheet view
Troubleshoot totals and calculated values in Datasheet view
Edit a formula in Datasheet view
Functions
About functions
Add or edit a calculated column in Datasheet view
Change the type of total value displayed in a column in Datasheet view
Function Reference
A-D
Date and Time
DATE
DATEDIF
DATEVALUE
DAY
DAYS360
HOUR
MINUTE
MONTH
SECOND
TIME
TIMEVALUE
TODAY
WEEKDAY
YEAR
E-K
Financial
DDB
FV
IPMT
ISPMT
NPER
NPV
PMT
PPMT
PV
RATE
SLN
SYD
Information
IS
Me
L-O
Logical
FALSE
IF
NOT
OR
TRUE
AND
P-R
Lookup and Reference
CHOOSE
S-U
Math and Trigonometry
ABS
ACOS
ACOSH
ASIN
ASINH
ATAN
ATAN2
ATANH
CEILING
COS
COSH
DEGREES
EVEN
EXP
FACT
FLOOR
INT
LN
LOG
LOG10
MOD
ODD
PI
POWER
PRODUCT
RADIANS
ROMAN
ROUND
ROUNDDOWN
ROUNDUP
SIGN
SIN
SINH
SQRT
SUM
SUMSQ
TAN
TANH
TRUNC
V-Z
Statistical
AVEDEV
AVERAGE
AVERAGEA
BETADIST
BETAINV
BINOMDIST
CHIDIST
CHIINV
CONFIDENCE
COUNT
COUNTA
CRITBINOM
DEVSQ
EXPONDIST
FDIST
FINV
FISHER
FISHERINV
GAMMADIST
GAMMAINV
GAMMALN
GEOMEAN
HARMEAN
HYPGEOMDIST
KURT
LOGINV
LOGNORMDIST
MAX
MAXA
MEDIAN
MIN
MINA
MODE
NEGBINOMDIST
NORMDIST
NORMINV
NORMSDIST
NORMSINV
POISSON
SKEW
STANDARDIZE
STDEV
STDEVA
STDEVP
STDEVPA
TDIST
TINV
VAR
VARA
VARP
VARPA
WEIBULL
Text and Data
ASC
CHAR
CLEAN
CODE
CONCATENATE
DOLLAR
EXACT
FIND
FIXED
LEFT
LEN
LOWER
MID
PROPER
REPLACE
REPT
RIGHT
SEARCH
T
TEXT
TRIM
UPPER
USDOLLAR
VALUE
Troubleshooting
Troubleshoot data types
Troubleshoot moving, copying, and pasting cell contents in Datasheet view
Troubleshoot displaying presence information in Datasheet view
Troubleshoot formatting data in Datasheet view
Troubleshoot international support
Troubleshoot automatically filling cells with data
Troubleshoot dragging and dropping data
Troubleshoot Datasheet view
Troubleshoot exporting Datasheet views
Troubleshoot sorting and filtering in Datasheet view
Troubleshoot totals and calculated values in Datasheet view
Troubleshoot document libraries in Datasheet view
Error Messages
I get the message 'Leaving or refreshing the list with pending changes'
I get the message 'List structure has changed'
I get the message 'Stop submitting changes'
I get the message 'Submit pending changes'
I get the message 'Unable to retrieve data'
Status Bar Notifications
Status bar displays 'Pending changes'
Status bar displays 'Read-only' or 'This view is read-only'
Status bar displays 'Retrieving data'
International Support
About international support
Reconvert a determined character string in Datasheet view
Troubleshoot international support
Get in touch
Submit feedback about this site to:
[email protected]