Help Center
Getting Started
Using Lark
More Resources
AI Assistant
Log In
General functions
Getting started
Introduction to Lark Docs
Get started with Lark Docs
Use templates in Lark Docs
Personalization and basic settings
Modify preference settings in Lark Docs
Set document icons
Switch accounts in Lark Docs
Set the default method for opening documents
Overview of browser and extensions compatibility
Managing files and storage
Create documents or folders
Quick create documents
Create a folder
Add a document shortcut
Use the sub-page list
Upload local files and folders
Import local files as Lark documents
Import Shimo documents as Lark documents
View, update, restore, or delete file versions
Download documents or folders to your device
Docs local record FAQs
Make a copy in Lark Docs
Move documents or folders
Delete documents or folders
Size and format requirements for uploading or previewing files
View and manage Lark Docs storage
Free up personal storage space
Docs storage, import, and trash limits FAQs
Use sub-page list (version 1.0)
Print Lark documents
Sharing and collaboration
Introduction to document and folder collaborators
Add a user group or dynamic group as collaborators
Add external email addresses as collaborators
View the creator, owner, and collaborators of a document
Check document information and configure privacy settings
Share documents
Share your document through a link
Share folders
Share folders with a link
Share documents or folders with external users
Password protect documents and folders for sharing
Turn off sharing of documents and folders
Use custom templates
Managing permissions
Definitions of Docs permissions
Lark Docs permissions overview
Guide to folder permissions
Set security levels for documents
Transfer ownership of documents and folders
Transfer document ownership in bulk
Set share, copy, download, and comment permissions for documents
Hide the profile pictures of users who visited and liked Docs
Request document permission for you or others
Restrict others from copying and downloading documents
Why do collaborators and permissions change after a document is moved?
Why can't I copy content, make a copy, print, download, or export?
What should I do if I can't delete a document or folder?
Why can't I move documents and folders?
What to do if you're notified a document contains sensitive information
Lark Docs permissions FAQs
Set share, copy, download, and comment permissions for folders
Docs
Getting started
Get started with Docs
Switch to view mode in Docs
Change page width in Docs
Use Docs in landscape mode on the mobile app
Docs limits FAQs
Docs FAQs
Introduction to keyboard shortcuts in Docs
Editing and formatting
Add and edit covers in Docs
Optimize the display of covers in Docs
Show document details in Docs
Supported slash commands in Docs
Find and replace content in Docs
Use headings and table of contents in Docs
Use blocks in Docs
Add hyperlinks in Docs
Indent and align content in Docs
Use toolbars in Docs
Use quotes in Docs
Use Markdown in Docs
Use numbered and bulleted lists in Docs
Use anchor links in Docs
Make documents available offline on the mobile app
Use columns in Docs
Format text in Docs
Comments and interactions
Post private comments in Docs
Use the @ feature in Docs
Use comments in Docs
View, reopen, and delete archived comments
Edit anonymously in Docs
Use suggestion mode in Docs
Follow updates in Lark Docs
Use Current notifications in Docs
View and restore edit history in Docs
Use the translation function in Docs
Use Lingo in Docs
Use Presentation Mode in Docs
Use bi-directional links in Docs
Use version management in Docs
Use block templates
Install and use Lark Clip
Post a document to Subscriptions
Inserting content
Embed Minutes videos in Docs
Edit tables in Docs
Reference data from Sheets in Docs
Use synced blocks in Docs
Insert equations in Docs
Insert mind maps in Docs
Insert flowcharts and UML diagrams in Docs
Insert code blocks in Docs
Create and manage tasks in Docs
Insert polls in Docs
Insert images in Docs
Insert videos, audio, and files in Docs
Insert callouts in Docs
Insert web links in Docs
Insert event cards in Docs
Embed videos in Docs
Embed Figma in Docs
Embed CodePen in Docs
Embed Airtable in Docs
Embed maps in Docs
Supported equation functions in Docs
Insert OKRs in Docs
Insert timers in Docs
Insert a sheet in Docs
Embed Lark Forms in Docs
Board
Create or insert a board
Configure the basic settings for a board
Introduction to board templates
Edit a board
Use shapes on a board
Batch edit shapes in a board
Use icon and image resources on a board
Add images to a board
Use lines on a board
Use sections on a board
Insert sticky notes to a board
Insert mind maps to a board
Use swimlane diagrams on a board
Upgrade flowcharts or UML diagrams to boards
Use the drawing tool on a board
Translate content on a board
Export content from a board
Import content onto a board
Search for and replace text on a board
Comment and collaborate on a board
Board FAQs
Edit boards on the mobile app
Add-ons
Overview of add-ons
Use the table of contents add-on
Use the timeline add-on
Use the Mermaid add-on
Use the batch formatter add-on
Use the typesetter add-on
Sheets
Basics
Get started with Sheets
Import and convert Excel or CSV files into Sheets
Download Lark spreadsheets
Use the toolbar in Sheets
Set clipboard permissions for Sheets
Use edit history in Sheets
Insert or delete rows, columns, and cells in Sheets
Remove duplicate values in Sheets
Use Paste Special in Sheets
Custom sort data in Sheets
Check cell edit history in Sheets
Use version management in Sheets
Sheets limits FAQs
Tag data using your organization's tag galleries
Adjust row height and column width in Sheets
Charts and graphs
Overview of the chart types in Sheets
Edit the x-axis and y-axis of charts
Paste Sheets charts into a document
Use column charts in Sheets
Use line charts in Sheets
Use pie charts in Sheets
Use bar charts in Sheets
Use area charts in Sheets
Use scatter charts in Sheets
Use bubble charts in Sheets
Create a radar chart in Sheets
Use word clouds in Sheets
Use funnel charts in Sheets
Use Pareto charts in Sheets
Use waterfall charts in Sheets
Use sparklines in Sheets
Use combo charts in Sheets
Editing and formatting
Use data validation in Sheets
Use conditional formatting in Sheets
Use autofill in Sheets
Format a portion of the content in a cell
Customize number format in Sheets
Modify font and cell formatting in Sheets
Use text wrap and line breaks in Sheets
Align text in Sheets
Change the number format in Sheets
Hide sheets, rows, and columns in Sheets
Use text to columns in Sheets
Group rows and columns in Sheets
Transpose rows and columns in Sheets
Add cell borders in Sheets
Use cases for custom formulas for conditional formatting
Use percent and percentile for conditional formatting
Inserting content
Use checkboxes in Sheets
Use dropdown lists in Sheets
Use date reminder in Sheets
Insert images in Sheets
Use links in Sheets
Use attachments in Sheets
Post a comment in Sheets
Data and functions
Getting started
Use functions in Sheets
Use data reference in Sheets
Filter data in Sheets
Use filter view in Sheets
Regex
Green triangles in cells of Sheets FAQs
Date functions
DATE function for Sheets
DATEDIF function for Sheets
DATEVALUE function for Sheets
DAY function for Sheets
DAYS function for Sheets
DAYS360 function for Sheets
EDATE function for Sheets
EOMONTH function for Sheets
HOUR function for Sheets
MINUTE function for Sheets
MONTH function for Sheets
NETWORKDAYS function for Sheets
NETWORKDAYS.INTL function for Sheets
NOW function for Sheets
SECOND function for Sheets
TIME function for Sheets
TIMEVALUE function for Sheets
TODAY function for Sheets
WEEKDAY function for Sheets
WEEKNUM function for Sheets
WORKDAY function for Sheets
WORKDAY.INTL function for Sheets
YEAR function for Sheets
YEARFRAC function for Sheets
Info functions
CELL function for Sheets
ERROR.TYPE function for Sheets
IS functions for Sheets
NA function for Sheets
TYPE function for Sheets
Logical functions
AND function for Sheets
FALSE function for Sheets
IFS function for Sheets
IF function for Sheets
IFERROR function for Sheets
IFNA function for Sheets
NOT function for Sheets
OR function for Sheets
SWITCH function for Sheets
TRUE function for Sheets
Search functions
ADDRESS function for Sheets
AREAS function for Sheets
COLUMN function for Sheets
CHOOSE function for Sheets
GETPIVOTDATA function for Sheets
FILTER function for Sheets
FORMULATEXT function for Sheets
HLOOKUP function for Sheets
INDEX function for Sheets
OFFSET function for Sheets
REGEX functions for Sheets
LOOKUP function for Sheets
MATCH function for Sheets
ROWS function for Sheets
ROW function for Sheets
SORT function for Sheets
TRANSPOSE function for Sheets
VLOOKUP function for Sheets
Why can't I find the results I need by using the VLOOKUP function
IMPORTRANGE function for Sheets
Use search functions in Sheets
INDIRECT function for Sheets
Math functions
COMBIN function for Sheets
COUNTBBLANK function for Sheets
LOG10 function for Sheets
SUM function for Sheets
SUMIF function for Sheets
SUMIFS function for Sheets
Operator functions
CONCAT function for Sheets
CONCATENATE function for Sheets
Statistical functions
AVEDEV function for Sheets
AVERAGE function for Sheets
AVERAGEIFS function for Sheets
BETA.DIST function for Sheets
BETA.INV function for Sheets
COUNT function for Sheets
COUNTA function for Sheets
COUNTIF function for Sheets
COUNTIFS function for Sheets
CONVERT function for Sheets
GAMMADIST function for Sheets
GAMMAINV function for Sheets
GAMMALN function for Sheets
GAMMALN.PRECISE function for Sheets
INTERCEPT function for Sheets
LARGE function for Sheets
MAX function for Sheets
MAXA function for Sheets
MIN function for Sheets
MINA function for Sheets
MEDIAN function for Sheets
MODE function for Sheets
MODE.MULT function for Sheets
MODE.SNGL function for Sheets
NORM.S.DIST function for Sheets
NORM.S.INV function for Sheets
PERCENTRANK function for Sheets
PERCENTILE function for Sheets
QUARTILE function for Sheets
RANK.AVG function for Sheets
RANK.EQ function for Sheets
SMALL function for Sheets
TRIMMEAN function for Sheets
AVERAGEIF function for Sheets
Text functions
ASC function for Sheets
CHAR function for Sheets
CLEAN function for Sheets
EXACT function for Sheets
FIND function for Sheets
FIXED function for Sheets
LEN function for Sheets
Left function for Sheets
LOWER function for Sheets
MID function for Sheets
PROPER function for Sheets
REPLACE function for Sheets
REPT function for Sheets
RIGHT function for Sheets
SEARCH function for Sheets
SPLIT function for Sheets
SUBSTITUTE function for Sheets
TEXTJOIN function for Sheets
TRIM function for Sheets
UPPER function for Sheets
VALUE function for Sheets
Financial functions
ACCRINTM function for Sheets
COUPDAYBS function for Sheets
COUPDAYS function for Sheets
COUPDAYSNC function for Sheets
COUPNCD function for Sheets
COUPNUM function for Sheets
COUPPCD function for Sheets
CUMPRINC function for Sheets
DISC function for Sheets
EFFECT function for Sheets
FV function for Sheets
FVSCHEDULE function for Sheets
IPMT function for Sheets
IRR function for Sheets
MIRR function for Sheets
NOMINAL function for Sheets
NPER function for Sheets
NPV function for Sheets
PMT function for Sheets
PPMT function for Sheets
PV function for Sheets
RATE function for Sheets
XIRR function for Sheets
XNPV function for Sheets
Engineering functions
BIN2DEC function for Sheets
BIN2HEX function for Sheets
BIN2OCT function for Sheets
COMPLEX function for Sheets
DEC2BIN function for Sheets
DEC2HEX function for Sheets
DEC2OCT function for Sheets
DELTA function for Sheets
ERF function for Sheets
ERF.PRECISE function for Sheets
GESTEP function for Sheets
IMABS function for Sheets
IMAGINARY function for Sheets
IMARGUMENT function for Sheets
IMCONJUGATE function for Sheets
IMCOS function for Sheets
IMEXP function for Sheets
IMLOG10 function for Sheets
IMLOG2 function for Sheets
IMPRODUCT function for Sheets
IMSUB function for Sheets
IMSUM function for Sheets
IMDIV function for Sheets
Practical functions
ARRAYFORMULA function for Sheets
ARRAY_CONSTRAIN function for Sheets
QUERY function for Sheets
UNIQUE function for Sheets
XLOOKUP function for Sheets
Web functions
Use IMAGE and IMPORT functions for Sheets
Pivot tables
Create and use pivot tables
Use fields in pivot tables
Use value summary and display options in pivot tables
Use calculated fields in pivot tables
Group in pivot tables
Change the display settings of pivot tables
Sort and filter in pivot tables
Pivot table use case: Sales analysis
Mobile features
Use Smart Edge Screenshot in Sheets on the mobile app
Use card view of sheets on mobile
Make spreadsheets available offline on the mobile app
More features
Configure the protected range in Sheets
Convert Sheets into a Base view
Use shortcuts in Sheets
Freeze columns or rows in Sheets
Use crosshair highlighting in Sheets
Copy a sheet as a picture
Zoom in and out in Sheets
How to hide gridlines in Sheets
Slides
Getting started
Get started with Slides
Convert PPTX files into Slides files
View edit history in Slides
Give presentations
Add, edit, and organize slides
Set the slide master and layout
Use animations in Slides
Insert content and format content
Format objects on slides
Add text to slides
Add shapes or icons to slides
Add audio or video files to slides
Add charts to slides
Add tables to slides
Add boards to slides
Add images to slides
Editing functions and tools
Keyboard shortcuts in Slides
Lines guides in Slides
FAQs
Why can't the font size in the slides be displayed correctly in the browser?
Slides FAQs
MindNotes
Create and edit mindnotes
Add, zoom in/out, and delete images in MindNotes
Switch views and edit nodes in MindNotes
Use edit history in MindNotes
Use MindNotes in landscape mode on the mobile app
Use comments in MindNotes
Wiki
Getting started
Get started with Wiki
Create a wiki space
Overview of wiki space permissions
Wiki and wiki space administrator FAQs
Wiki space role permissions
Wiki limits FAQs
Admin guides
Wiki administrator guide
Access wiki space data overviews
Configure a wiki space to be public
Modify wiki space security settings
Add users from trusted parties as wiki space members
Migrate Confluence data to Lark Wiki
Add wiki space administrators and members
Member guides
Wiki user guide
Add pages to a wiki space
Move documents to Wiki
Share a wiki space with external users
Share wiki pages with external users
Move or remove pages from a wiki space
Follow wiki space updates
Create a sub-doc
Batch actions for wiki space pages
Delete and restore wiki space pages
Docs
Sheets
Sheets
• Basics
• Charts and graphs
• Editing and formatting
• Inserting content
• Data and functions
• Pivot tables
• Mobile features
• More features
00:00
Click and hold to drag
Have questions about using Lark?
Ask the AI Assistant!