팁과 요령

엑셀과 구글 스프레드시트 활용하는 방법

100여 개의 무료 튜토리얼을 통해 엑셀 활용법을 배워보세요.

영어 튜토리얼 페이지를 방문하면 더 많은 튜토리얼을 보실 수 있습니다.

Excel "How To" Tips & Tricks
AutoFillyes
AutoFill Custom and Alphabetic Lists
AutoFill Dates or Months
AutoFill Numbers
AutoFill Numbers Without Dragging
Auto-Number Rows in a Column
Fill Column With the Same Value
Make a List of Numbers
Turn Off AutoFill
Turn On AutoFill
Use Fill Handle
Use Flash Fill to Fill a Range
AutoSaveyes
Recover a Deleted File
Recover a File That Was Not Saved
Set Up AutoSave Location and Time
Turn On or Off AutoSave and AutoRecover
Calculationyes
Add Values to Cells and Columns
Anchor a Cell
Change the Signs of Values
Divide Cells and Columns
Imaginary Numbers
Keep Variable Cell Constant
Lock Cell in Formula
Multiply Cells and Columns
Stop Auto Calculation
Subtract Cells and Columns
Commentsyes
Copy Comments
Delete All Comments
Edit Comments
Insert a Comment or Note to a Cell
Show or Hide All Comments
Compareyes
Compare Two Columns and Highlight Differences
Compare Two Columns for Matches
Compare Two Files for Differences
Compare Two Rows
Compare Two Sheets for Differences
Conditional Formattingyes
Apply Conditional Formatting Based on Adjacent Cell
Apply Conditional Formatting Multiple Sheets
Apply Conditional Formatting to Dates
Apply Conditional Formatting to Entire Column
Apply Conditional Formatting to Multiple Rows
Conditional Format Greater Than Or Less Than
Conditional Formatting Based on Another Cell
Conditional Formatting Based on Cell Value
Conditional Formatting Based on Date
Conditional Formatting Based on Formula
Conditional Formatting Dates Overdue
Conditional Formatting Formulas Not Working
Conditional Formatting Grayed Out
Conditional Formatting If Between Two Numbers
Conditional Formatting If Cell Contains Any Text
Conditional Formatting Not Equal
Conditional Formatting Tips
Conditional Formatting With Multiple Conditions
Copy Conditional Formatting
Edit Conditional Formatting
Formatting If Cell Contains Specific Text
Highlight a Cell if Specific Value Exists in Another Column
Highlight Blank Cells
Highlight Cells If
Highlight Cells That Begin or End With
Highlight Duplicate Rows
Highlight Duplicate Values
Highlight Entire Row
Highlight Every Other Line In Excel
Highlight Rows If
Highlight Rows That Contain
Highlight the Highest Value
If Formula to Set Cell Color
Insert Harvey Balls
Remove Conditional Formatting
Use Comparison Icon Sets
Use Conditional Formatting With Checkbox
Use Custom Icon Sets
Copy & Pasteyes
Copy a Cell From Another Sheet
Copy a Page
Copy and Paste a Range or Object as a Picture
Copy and Paste an Exact Formula
Copy and Paste as Text or Value
Copy and Paste Cells
Copy and Paste Columns
Copy and Paste Formulas Between Excel and Google Sheets
Copy and Paste Hyperlinks
Copy and Paste Merged Cells
Copy and Paste With Skip Blanks
Copy and Paste Without Borders
Copy and Paste Without Changing the Format
Copy Cell Formatting
Copy Data From One Cell to Another Automatically
Copy Every Other Row
Copy Formula Down to Entire Column
Copy Number Not Formula
Copy Value to Another Cell With Formula
Drag and Drop
Duplicate Rows
Freeze Random Numbers
Paste and Match Destination Formatting
Paste Horizontal Data Vertically
Paste Into Filtered Cells
Rearrange Columns
Replace Formula With Value
Swap Cells
Swap or Move Columns
Transpose Rows to Columns
Data Validationyes
10 Data Validation Rules and Techniques
Add a ToolTip
Change Data Validation
Clear Data Validation
Copy Data Validation
Create an Input Message
Data Validation Based on Another Cell
Date and Time Data Validation Formats
Enable Error Alert
Find Restricted Values
Ignore Blanks in Data Validation
Restrict Cell Values
Set a Character Limit
Validate Phone Number Format
Databaseyes
Clean Up Data
Create a Searchable Database
Drop-Down Listyes
Add Drop-Down List With Color Formatting
Alphabetize a Drop-Down List
AutoComplete With Data Validation
Change a Drop-Down List
Create a Cascading Drop-Down List
Create a Default Value for a Drop-Down List
Create a Drop-Down List
Create a Drop-Down List Filter
Create a Yes or No Drop Down
Create Drop Down Data Entry Form
Create Dynamic Drop Down From Table
Data Validation Unique Values
Drop Down Populates Another Cell
Drop-Down List With If Statement
Make Drop-Down Categories and Subcategories
Remove a Drop-Down List
Update a Drop-Down List
Duplicatesyes
Clear Duplicate Cells
Combine Duplicate Rows
Count Duplicate Values Only Once
Distinct (Unique) Values
Duplicates
Find Duplicate Values
Merge Lists Without Duplicates
Paste Unique Values
Prevent Duplicate Entries
Remove Both Duplicates
Remove Duplicate Rows
Remove Unique Values
Show Only Duplicates
Emailyes
Copy Email Addresses to Outlook
Email a Spreadsheet
Email Address Format Validation
Embed a File
Send Email With Formula
Send Mass Email From a List
Filtersyes
Advanced Filter
Apply Multiple Filters
Clear All Filters
Copy Filtered Data
Delete Filtered Rows
Filter by Color
Filter by Date
Filter Duplicate Values
Filter Merged Cells
Filter Rows
Filter Unique Values
Hide Blank Rows
Hide Rows Based on Cell Value
Horizontal Filter
Remove Filters
Save Filtered Data
Show or Hide AutoFilter Arrows
Show Rows With Specific Text
Use Custom AutoFilters
Find & Selectyes
Deselect Cells
Fill Blank Cells With Value Above
Find and Delete Words
Find and Highlight
Find and Replace Multiple Values
Find and Replace With Wildcards
Find and Select Specific Cells
Find Blank Cells
Find Errors
Find Merged Cells
Find Unique Values
Highlight Blank Cells
Remove Asterisks
Replace Blank Cells With Zeros
Replace Space With Underscore
Search All Sheets
Select All Cells With Values
Select Every Other Row
Select Multiple Cells
Select Non-Adjacent Cells or Columns
Use Go To Special
Use the Go To Command to Jump to a Cell
Forecastyes
Add Goal Seek to Google Sheets
Automatically Vary the Contents of a Cell
Calculate the Break-Even Analysis Point
Calculate Total Revenue
Do a Sensitivity Analysis
Enable Solver Add-In
Insert Line and Column Sparklines
Install the Data Analysis Toolpak for PC and Mac
Quick Analysis Tool
Remove Solver
Solve for a Variable
Format Cellsyes
Add Border Lines
Alternate Row Color
Apply and Change Themes
Apply Cell Styles
Apply the Calculation Style
AutoFit Columns
Automatic Formatting
Cell Margins
Change Gridline or Cell Border Color
Change the Cell Background Color
Clear All Formatting
Copy Cell Color
Copy Column Widths
Copy Row Height
Highlight Columns
Highlight Rows
Make All Rows and Columns the Same Height and Width
Make Merged Cells the Same Size
Merge and Center Cells
Merge Multiple Cells
Outline Cells
Remove Fill Color
Resize Cells to Default Row Height
Resize Multiple Rows or Columns at Once
Split a Cell Diagonally
Unmerge Cells
Use Format Painter for Multiple Cells
Format Textyes
Add and Remove Strikethrough
Bold Lines
Center Across Selection
Change Alignment
Create a Bulleted List
Create Barcodes
Go Down to the Next Line
Hide Overflow Text in a Cell
Increase Indent
Line Spacing
Make Cells Bigger to Fit Text
Make Subscripts and Superscripts
Rotate Text in a Cell
Shrink to Make Text Fit
Two Lines in One Cell
Underline Text
Word Wrap
Write Paragraphs
Write Text Vertically
X Out a Cell
Formula Auditingyes
Allow Circular References
Camera Tool
Find a Circular Reference Error
Formula View Mode
Hide All Dependency Tracer Arrows at Once
Hide Precedent Tracer Arrows
Ignore All Errors
Insert Functions With Dialog Box
Show Dependent Tracer Arrows
Show Precedent Tracer Arrows
Use Formula AutoComplete
Use the Error Checking Command
Watch Window
Insert & Deleteyes
Clear Cell Contents
Delete Blank Columns
Delete Blank Rows
Delete Cells and Shift Cells Left
Delete Cells and Shift Cells Up
Delete Every Other Column
Delete Every Other Row
Delete Hidden Rows and Columns
Delete Highlighted Cells
Delete Infinite Rows or Columns
Delete Multiple Cells
Delete Multiple Rows or Columns
Delete Rows if Cell Contains Specific Text
Delete Rows With Blank Cells
Insert Blank Row
Insert Blank Row After Every Other Row
Insert Cells and Shift Cells Down
Insert Cells and Shift Cells Right
Insert Multiple Rows and Columns
Reset the Last Cell
Linksyes
Break All Links
Create a Hyperlink
Cross-Reference
Find External Links
Hyperlink to Another Sheet or Workbook
Link Files
Mirror Cells by Linking
Update Links Automatically
Miscellaneousyes
32-Bit Versus 64-Bit Office
Change Author Property
Change Cell Size in Pixels or Inches
Change Document Properties
Clear the Cache
Customize the Ribbon
Delete a File
Find the Last Saved Date
Find What Version of Excel You Have
Generate All Permutations
Insert Timestamp
Make a File Smaller
Open Files in New Windows
Show the Formula Bar
Show the Toolbar
Take a Screenshot
What is the Formula Bar?
Name Manageryes
Create Range Names From Selection
Delete Named Range
Dynamic Named Range Based on Cell
Edit Named Ranges
Find the Location of a Named Range
Use the Name Box
What are Name Manager and Name Box?
Number Formatsyes
Add a Plus Sign for Positive
Add More Decimal Places
Add Percentage Style to a Number
Add Units to Numbers
Apply Accounting Number Format
Convert Date to Month and Year
Convert Decimal to Fraction
Display Fraction Without Reducing
Format Phone Numbers With Dashes
Format Time to Milliseconds
Get Rid of the Dollar Sign
Hide Zeros
Insert Dates
Limit Decimal Places
Make Negative Numbers Red
Mask Data Input
Move Decimal Places
Number Format in Millions
Number Format in Thousands
Pad Numbers With Leading Zeros
Prevent Rounding
Remove Decimals
Remove Scientific Notation
Round Numbers Without a Formula
Stop Changing Numbers to Dates
Use Scientific Notation
Objectsyes
Add and Group Radio Buttons
Add Gradient Fill to Shapes or Cells
Change the Color of an ActiveX Control Button
Circle Something
Create a Shape With Drawing Tools
Create a Slider Bar
Delete a Checkbox
Draw Lines
Insert a Digital Signature
Insert a Drop-Down Calendar With Date Picker Control
Insert a Shape
Insert a SmartArt Graphic
Insert a Text Box
Insert an Arrow
Insert Multiple Checkboxes
Insert Multiple Hyperlinks in One Cell
Insert Toggle Button
Link a Text Box
Make a Combo Box
Make a Number Line
Select Objects
Organize Sheetsyes
Add Multiple Worksheets
Copy a Spreadsheet
Copy Multiple Sheets to a New Workbook
Count Number of Worksheets
Delete Multiple Tabs
Delete Worksheets
Group and Ungroup Worksheets
Hide and Unhide Worksheets
Insert a New Tab
Merge Multiple Workbooks Into One
Merge Two Spreadsheets Into One
Move Sheets
Pull Data From Multiple Sheets and Consolidate
Rename a Worksheet
Select Multiple Sheets
Separate Sheets
View a List of Worksheet Tabs
Outlineyes
Collapse an Outline to Show Just the Subtotals
Create an Outline
Create Auto Outline
Expand or Collapse Rows or Columns
Group Cells
Page Layoutyes
Add Element to Display Current Date in the Header
Change Orientation to Landscape
Create Cover Page
Define Print Titles on Every Page
Format the Header and Footer
Insert or Remove Headers and Footers
Make a Header Only on the First Page
Make a Sheet Fit on One Page
Scale to Fit Page Size
Set Custom Page Size
What is the Page Setup Function?
Picturesyes
Drag and Drop Pictures
Insert a Background Image
Insert a Picture Into a Cell
Insert a Picture Into a Cell Automatically
Insert a Picture Into the Header
Insert Pictures
Make a Picture Transparent
Remove All Pictures From a Workbook
Show a MouseOver Picture
Pivot Tableyes
Add Calculated Field to Pivot Table
Advanced Pivot Table Techniques
Change Pivot Table Data Source
Count Unique Values With Pivot Table
Create Pivot Table
Delete Pivot Table
Filter Pivot Table Values
Get a Count in Pivot Table
Group Pivot Table by Date
Keep Pivot Table Formatting
Make a Pivot Table Chart
Pivot Table Slicers
Pivot Table Sorting Guide
Refresh a Pivot Table
Remove Field From Pivot Table
Power Queryyes
Export Folder and Subfolder Structure
Import an HTML Table
Import XML Files
Set Up Automatic Currency Conversion
Printyes
Add a Page Border
Add a Watermark
Center Worksheets Horizontally and Vertically
Change Print Area
Clear Print Area
Delete Unwanted or Blank Pages
Display and Print Formulas
Hide Page Breaks
Insert a Page Number
Insert and Remove Page Breaks
Make Graph Paper
Print
Print a Background Image
Print a Chart or Graph
Print All Tabs in a Workbook
Print Comments
Print Gridlines on a Blank Sheet
Print Multiple Sheets
Print Only Selected Cells
Print Preview
Print Row Numbers and Column Headings
Print Selected Worksheets on One Page
Print Selected Worksheets Without Print Preview
Print Two Sheets on One Page
Remove Watermarks
Set the Print Area
Show Print Area
Proofingyes
Check Spelling
Disable Automatic Hyperlinks
Remove Hyperlinks
Stop AutoCorrect
Turn On or Change AutoCorrect
Protectyes
Change a Read Only File
Hide Formulas
Lock a Sheet for Viewing
Lock Cells
Lock Column Width and Row Height
Lock Formatting
Mark a Workbook as Final
Password Protect a File
Protect Workbook Structure
Protected View: Turn Off and Enable Editing
Remove a Password From a File
Unlock Cells
Unprotect Workbook
Save Asyes
Change the Default Directory
Convert a CSV File to XLSX
Convert a Spreadsheet to a Delimited Text File
Convert an Excel File to Google Sheets
Convert to a Pipe Delimited Text File
Copy Entire Workbook
Create a Word Document
Embed Tables Into HTML
Export a File to PDF
Import a Word Document
Open a Text File
Open Old XLS Files
Recover Deleted Sheet
Rename a File
Save a File as CSV
Save a File as CSV With UTF-8 Encoding
Save a File to the Old Format
Save a Macro-Enabled Workbook
Save a Table as an Image
Save File as Read-Only
Save Just One Sheet
Save Multiple Sheets as a PDF
Save Workbook as PDF
What is the Difference Between CSV Files and Excel Files?
Share Filesyes
Make a Shared Spreadsheet for Multiple Users
Track Changes
Unshare a Workbook
Use Document Inspector
Shortcutsyes
Go To Cell, Row, or Column Shortcuts
Sort Datayes
Advanced Sorting
Keep Rows Together During Sort
Put Things in Alphabetical Order
Random Sort
Reverse the Order of Data
Sort and Ignore Blanks
Sort by Last Name
Sort By Month
Sort By Number
Sort Data
Sort Dates in Chronological Order
Sort Highlighted Cells by Color
Sort IP Addresses
Sort Multiple Columns
Sort Multiple Rows Horizontally
Sort Subtotals
Sort With a Custom List
Sort Without Duplicates
Undo a Sort
Symbolsyes
Add Bullet Points
Division Sign
Escape Double Quotes
Find and Replace Question Marks and Asterisks
Insert a Check Mark
Insert Bitcoin Symbol
Insert Cent Symbol
Insert Cross Text Symbol
Insert Delta Symbol
Insert Euro Symbol
Insert Plus or Minus Symbol
Insert Pound Symbol
Insert Rupee Symbol
Insert Signs and Symbols
Insert Sum Symbol
Insert Yen Symbol
Star Symbol
What Do the Symbols Mean in Formulas?
Tablesyes
Add a Column and Extend a Table
Add a Total or Subtotal Row to a Table
Add Rows to Table
Center Table
Change Table Style
Compare Two Tables
Convert a Table to a Normal Range
Convert Data to Table
Copy and Paste Table
Copy Table From Word
Copy to Word and Fit Page
Create Floating Table
Create Lookup Table
Create Table
Display Data With Banded Rows
Flip a Table
Link Tables
Make Columns Sortable
Move Table
Paste Excel Table Into Gmail
Remove a Table or Table Formatting
Rename a Table
Rotate Data Tables
Table Tools
Types of Tables
Text to Columnsyes
Convert String to Date
Paste CSV Data Into Columns
Separate Numbers
Split a Cell Into Two or More Columns
Split a Text Cell to Two or More Rows
Use a Line Break in Text to Columns
Use Text to Columns to Parse Data
Troubleshootingyes
#REF Error
Advance Filter Not Working
All the Merged Cells Need to Be the Same Size
Command Cannot be Used on Multiple Selections
Data Validation Not Working
Excel Borders Not Printing
Excel Cannot Open or Save Any More Documents
Excel Cannot Paste the Data Error
Excel Not Sorting Numbers Correctly
Fill Series Not Working
Find Broken Links
Fix Excel Find Not Working
Fix the #NAME? Error
Formula Won't Calculate
Get Rid of Green Triangle
Get Rid of the Red Triangle in Google Sheets
Loading Solver Not Working
Printing Problems
Printing Too Small
Resolve a Name Conflict for a Named Range
Solver Encountered Error Value
The Pivot Table Field Name Is Not Valid
There Isn't Enough Memory to Complete This Action
Unlock a File Locked for Editing by Me
Waiting for OLE Action Error
What to Do When Excel Keeps Crashing or Freezing
Why is AutoSave Not Working or Grayed Out?
Viewyes
Close Header and Footer
Dark Mode
Enable and Disable Smart Tags
Freeze and Unfreeze Panes
Get Rid of Dashed Print Area Lines
Hide and Unhide Rows and Columns
Hide and Unhide Workbooks
Hide Column and Row Headings
Hide Unused Cells
Hide Vertical and Horizontal Scroll Bars
Lock Columns
Lock the Top Row When Scrolling
Remove Page Number in Preview Mode
Return to Normal View
Show and Hide Gridlines
Show or Hide ScreenTips
Show the Ruler
Use Split Screen
View Full Screen
View Header
View Two Sheets at Once
Zoom In or Out

AI Formula Generator

무료로 체험하기