Excel
Excel is the spreadsheet program that can handle anything you throw at it. Learn the tips and tricks you need to use it like a pro.
Latest Tech News
![Copilot running in Microsoft Excel](https://www.lifewire.com/thmb/CIHxLb4LgWLrFEixJoCvSq_e4fI=/540x405/filters:no_upscale():max_bytes(150000):strip_icc()/Copilot-in-Excel-demo-f054e2679c5a4f94b11853286e6026d4.jpg)
How to Use Copilot in Excel
![Image of a woman using a spreadsheet](https://www.lifewire.com/thmb/cCRHnPzVy0Y6Qhuq6G7oBlZP5R0=/540x405/filters:no_upscale():max_bytes(150000):strip_icc()/how-to-split-cells-in-excel-5221271-15-0a4746c56c0f44f5818480949e028d05.jpg)
How to Split Cells in Excel
![Someone working on an Excel spreadsheet on a laptop computer.](https://www.lifewire.com/thmb/A_PPJAoDHTClk_nTfqdEDi-xxQA=/540x405/filters:no_upscale():max_bytes(150000):strip_icc()/5365Womanworkingonlaptop-910466acc2db47d2a992197805c8942b.jpg)
INDEX-MATCH vs. VLOOKUP in Excel
![A windows laptop sitting on a window sill, displaying Microsoft Excel.](https://www.lifewire.com/thmb/j6x6x1uGo3sFwV29r-ZJ81Ca1h0=/540x405/filters:no_upscale():max_bytes(150000):strip_icc()/dean-pugh-C8NDn4xk9zs-unsplash-f0dd8299f92842af80b9013007ab8630.jpg)
How to Combine Two Columns in Excel
![Insert multiple rows in Excel on Windows](https://www.lifewire.com/thmb/XTTqokJimfUMLGhDDnpTqVZLY-Y=/540x405/filters:no_upscale():max_bytes(150000):strip_icc()/Insert-Multiple-Rows-Excel-Windows-5097656-d37ddd9d301f40db931fd3a0ac9bd0da.jpg)
How To Insert Multiple Rows in Excel
![A windows laptop sitting on a window sill, displaying Microsoft Excel.](https://www.lifewire.com/thmb/IhV8_MVo5avrYsQGifbCDrmNxnQ=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/dean-pugh-C8NDn4xk9zs-unsplash-f0dd8299f92842af80b9013007ab8630.jpg)
How to Combine Two Columns in Excel
![Insert multiple rows in Excel on Windows](https://www.lifewire.com/thmb/hGV2Mg94-PI05yZLWZIUG3hp9DM=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/Insert-Multiple-Rows-Excel-Windows-5097656-d37ddd9d301f40db931fd3a0ac9bd0da.jpg)
How To Insert Multiple Rows in Excel
![Someone working in Microsoft Excel on a Windows laptop.](https://www.lifewire.com/thmb/Jo064tqUGmEbTIVl8bMFuP3idj0=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/2503129WomanusingPClaptop1-3cd2b6f0037949c2b3334d10442005b3.jpg)
How to Remove Blank Rows in Excel
![Someone working on an Excel spreadsheet on a laptop computer.](https://www.lifewire.com/thmb/UTWtA5v_ww9IfL7BZcuJvAzQq28=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/5365Womanworkingonlaptop-910466acc2db47d2a992197805c8942b.jpg)
How to Move Columns in Excel
![A person working on a spreadsheet on a desktop computer.](https://www.lifewire.com/thmb/BEF1rZKybckJ5dEy_XDGZ_APeAk=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/GettyImages-1273037989-d598e1c6755d489ab3114614c182caee.jpg)
How to Use the EDATE Function in Excel
![Person making labels with Excel](https://www.lifewire.com/thmb/TlyQKTdncOQ-OCiYvBLkYD0YuTk=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/make-labels-with-excel-4157653-2dc7206a7e8d4bab87552c8ae2ab8f28.png)
How to Print Labels From Excel
![Illustration of a person using Excel to combine Round and Sum functions](https://www.lifewire.com/thmb/-Ne5-_dq8Fm4NZB7j8ACbkdwkWU=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/combine-round-and-sum-functions-in-excel-4178187-f6952bd3bc9f477bbb57c063acc5225c.png)
How to Combine the ROUND and SUM Functions in Excel
![Illustration of a person moving between worksheets in Excel](https://www.lifewire.com/thmb/PsU5QJ9Ntp9mjiC6-rePCPC8hM0=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/moving-between-worksheets-in-excel-3124024-4291208b5fb44d39b0d3cf8321159724.png)
How to Move Around and Between Worksheet Tabs in Excel
![Image of a financial report](https://www.lifewire.com/thmb/ONjgIOpaqZZy_wmA-pGxtzaZxdM=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/how-to-create-a-report-in-excel-4691111-16-3853f1db18a042c890b57fd26a53cd04.png)
How to Create a Report in Excel
![Using the ROUNDUP function in Excel saves time.](https://www.lifewire.com/thmb/h6ggSxgmavE_WAWYdgTIU7EBOBM=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/rawpixel-659481-unsplash-5bdf4ee246e0fb002685d25b.jpg)
How to Create a Database in Excel
![Excel Spreadsheets printed hardcopy](https://www.lifewire.com/thmb/m--Ru5vtV6fCdUw75JlGtUEojdo=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/GettyImages-nigelcarse-f0b7b9b9db6b440a9dbc7a7a2eae64b1.jpg)
How to Delete a Page in Excel
![Woman using spreadsheet on a laptop](https://www.lifewire.com/thmb/iKv1tjFZlmN0h4RnwRGgmo2kKHg=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/2503129WomanusingPClaptop-5efff17fb645458ba96e9c3d38ed0e8b.jpg)
How to Define and Edit a Named Range in Excel
![Binary code](https://www.lifewire.com/thmb/DYLHOXBvIIbYtMOnhp_qNy2Tv7U=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/binary-code-713783917-5be0f3cbc9e77c00516e59f9.jpg)
How to Use Boolean Values (Logical Values) in Excel
![Find the Type of Data in a Cell with the Excel TYPE Function](https://www.lifewire.com/thmb/5Z-_8YqJyCYPV5nx2SMAG43gcbQ=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/excel-type-function-d717fb183ca84185b7c4262edef4cae0.jpg)
Use Excel's TYPE Function to Check the Type of Data in a Cell
![Businessperson using laptop in office meeting](https://www.lifewire.com/thmb/04iO7XOO8xpOE9_LgGyli-xEaZQ=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/GettyImages-597316723-5bd1e322c9e77c00518457c7.jpg)
How to Create an Excel Lookup Formula With Multiple Criteria
![](https://www.lifewire.com/thmb/Xfsodnkjdz4fAd73146-24x06ZE=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/the-windows-10-notification-center-what-it-is-and-how-to-use-it-4150756-2691e67d378e45f4875c059230b007d7.png)
Learn How to Show or Hide Chart Axes in Excel
![Two parking garage meters blocking the entrance and exit](https://www.lifewire.com/thmb/zRq9tQQ-nlG--AImCJrEDVD1SNk=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/boom-barriers-in-car-park-654602221-5be0e45846e0fb002613ef69.jpg)
How to Create a Drop-Down List in Excel to Restrict Data
![Graph neon tubes with numbers](https://www.lifewire.com/thmb/EL0ioZfH-Nl5R4gjt-2WCIJ_DQ8=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/GettyImages-631786761-e646ca3b2f264651aec22457032bd564.jpg)
Round Numbers to the Nearest 5 or 10 in Google Sheets
![Two young women sitting at a table having a discussion.](https://www.lifewire.com/thmb/KMsKKL0JDAPSWzQd8h3KX2SBso0=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/two-young-women-having-a-discussion-in-a-business-607477463-5a32f91aec2f640037522ed6.jpg)
How to Change the Cursor Movement Direction in Excel
![Two people using spreadsheets](https://www.lifewire.com/thmb/1gdNGgLU9w_egiOg3nqHGPCFi0c=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/helloquence-61189-unsplash-5c7c93d646e0fb00018bd82e-43558c37009b4b41bcffef0dbfc2d441.jpg)
Hide/Unhide Scroll Bars and Reset the Vertical Slider Range in Excel
![A man working on laptop.](https://www.lifewire.com/thmb/ACHUp6OcerasW0eGiDPklusTLzw=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/serious-businessman-working-on-laptop-875590436-5bf5e0dc46e0fb00265ce59b.jpg)
How to Use Undo, Redo, and Repeat in Excel
![Summary of trigonometric functions.](https://www.lifewire.com/thmb/NMuSA66PcGXGuP_HGuiYZO7L50A=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/1280px-Circle-trig6.svg-5c850cc346e0fb0001a0be76.png)
How to Convert Angles From Radians to Degrees in Excel
![A laptop running a spreadsheet program.](https://www.lifewire.com/thmb/QNjxinby1_ADDsfcAUhWBJ0hh2w=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/rawpixel-659481-unsplash-5bb19274c9e77c00519ab8ac.jpg)
How to Create a Macro In Excel
How to Add and Delete Rows and Columns in Excel
![Close-Up Of Protractor Over White Background](https://www.lifewire.com/thmb/YFQ6my1ZlUFEBH-Q3hGNOzQ1JWE=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/close-up-of-protractor-over-white-background-760304201-5be3761ec9e77c005154ac44.jpg)
How to Convert Angles From Degrees to Radians in Excel
![young accountant counting financial figures on office desk](https://www.lifewire.com/thmb/_2TsQ3JQrdkELnnXMJMDixq6C14=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/GettyImages-1134059911-f45a545f0d104bdcb43bb80e7c274391.jpg)
How to Add up Columns or Rows of Numbers in Open Office Calc
![A compass for measuring angles](https://www.lifewire.com/thmb/dZwMEgeUqTdNtde3S-HnkS_MiBA=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/use-tan-function-to-find-tangent-angle-in-excel-4582479-7-aa8e417e85554ebd8a0396a59bc95892.png)
Excel TAN Function: How to Find the Tangent Angle
![A person working on a spreadsheet using a laptop.](https://www.lifewire.com/thmb/YQ3OaumaRsIwzjJGj1qsIklMp_w=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/simon-hattinga-verschure-5085-89f30b90dd4849f3a548fa0ae6612547.jpg)
How to Copy a Sheet in Excel
![Illustration of an Excel spreadsheet on a computer calculating age in a room with birthday cards and presents](https://www.lifewire.com/thmb/3JktamAkPMAUpbbeAh_78USzTo4=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/calculate-current-age-with-excel-datedif-function-4178612-8d76b37429ac4505ac0fce62ecb36e9a.png)
Calculate Your Current Age With the Excel DATEDIF Function
Find the Largest Negative or Positive Number in Excel
![Uppercase and lowercase Cyrillic letter Ye. Times New Roman font.](https://www.lifewire.com/thmb/-PeKq3U3RpXvUiVff4yLyrkp_Bk=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/Cyrillic_letter_Ye_-_uppercase_and_lowercase.svg-57d3a3d43df78c58334a2529.png)
How to Convert Text to Upper, Lower, or Proper Case in Excel
![Mature businessman sitting at desk in office looking at smartwatch](https://www.lifewire.com/thmb/zIg-twuyKHPiqSz7KQz19DbqsDU=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/mature-businessman-sitting-at-desk-in-office-looking-at-smartwatch-951529850-5b1abded8023b900366f9472.jpg)
How to Create a Chart in Excel Using Shortcut Keys
![Colored file folders arranged alphabetically.](https://www.lifewire.com/thmb/EpE--ZfFzboYSRPoeTWt2-LWVlc=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/GettyImages-115875502-5c795f3e46e0fb0001d83d0f.jpg)
How to Change Worksheet Tab Colors in Excel
![Image showing a spreadsheet with comparisons](https://www.lifewire.com/thmb/CGct1lRMcKRFxfD3nfr_2GglcZo=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/GettyImages-471153607-5be9792846e0fb0051d2624e.jpg)
How to Use Comparison Operators I=in Excel
![A spreadsheet with numbers on it](https://www.lifewire.com/thmb/2MVcgbsk3lb5rv22Ai6JK-TOx0M=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/GettyImages-142040274-58f268b43df78cd3fcc0f352-dd4429912200475291a987d99673c4b8.jpg)
How to Create, Edit, and View Microsoft Excel Documents for Free
![A workgroup using a laptop and collaborating on a spreadsheet](https://www.lifewire.com/thmb/O2hOnF_Hkybskaz2KK4k8J4v_Ao=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/GettyImages-1225000107-a3c6a5200701464eaabcedb36ee038cb.jpg)
How to Use Track Changes in Excel
![Image of someone using a computer keyboard](https://www.lifewire.com/thmb/7e4y6xwzvfTd5DZVWHzPMue3VtM=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/how-to-fix-it-when-arrow-keys-are-not-working-in-excel-5069418-2-98df52703213455b93992ff597896656.jpg)
How to Fix It When Arrow Keys Are Not Working in Excel
![DATE function in Excel](https://www.lifewire.com/thmb/Vgw0DT7-NI_mKpGFwPGyFQRdxyE=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/date-function-example-e60abfc348994855bbc30338e26b5cad.png)
How to Use the Excel DATE Function
![Microsoft Excel on a computer screen.](https://www.lifewire.com/thmb/lzBUQyNGHRQCxl9aeJb_BEKZZnU=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/spreadsheetcloseup-1bc9f80f02f843f4aa5d53b1c8fc891b.jpg)
How to Use the Excel INDEX Function
![ISBLANK Conditional Formatting](https://www.lifewire.com/thmb/sDJpmTvmh2trz-0yzJyddbUDMG8=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/isblank04-a3b18feb35e94e1ca02d0d2adc9b8505.jpg)
How to Use the ISBLANK Function in Excel
![The months and days of the year on calendar paper](https://www.lifewire.com/thmb/z9CDCGdAaY75WkHuPtyPacllkCQ=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/GettyImages-157335060-7980324c95184c0cb5801d405caa4a7f.jpg)
How to Use the MONTH Formula in Excel
![Magnifying glass on a spreadsheet](https://www.lifewire.com/thmb/Pk8xT-tr2o_AlbXCZxEOiQldCfs=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/GettyImages-109160768-0665f88e1a2542afbf3fea93f97e8cbb.jpg)
How to Use Excel's HLOOKUP Function
![Microsoft Excel data export displayed on a laptop computer sitting on a desk.](https://www.lifewire.com/thmb/-B_3oZoIx41dOwWmOnE3Plk1en8=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/rawpixel-com-395556-85bb3a75e3344a6592283988c3394350.jpg)
How to Export Data to Excel
![Microsoft Excel's MID function helps you extract text from a cell.](https://www.lifewire.com/thmb/snnvP1uXeGu7V0jgNLaWL0SS41s=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/how-to-use-the-excel-mid-function-4796632-1-2875da6df5c9435a87dc951b1948ece3.jpg)
How to Use the Excel MID Function
![Woman using a laptop creating a bar chart in Excel.](https://www.lifewire.com/thmb/TEIhVH30H_lTkvci71toMGTgpAU=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/2503129WomanusingPClaptop-eebedb6fc0134b08a0ef9fb0e4bb7b57.jpg)
How to Make a Bar Graph in Excel
![Illustration of a computer running Microsoft Excel.](https://www.lifewire.com/thmb/nFdZQijJmrwP-N5hPmH3U1PSaUg=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/how-to-highlight-in-excel-013da92dc1b34edea9009d8c63c1d1a7.jpg)
How to Highlight in Excel
![Calculator and Spreadsheet](https://www.lifewire.com/thmb/CtqOpkPcrsi-PEL7rMqBg7mbwH0=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/GettyImages-182400303-d96fb6b257454adaa4cfa487a7275e29.jpg)
How to Use the Round Function in Excel
![INDEX MATCH Excel function example](https://www.lifewire.com/thmb/CC3SdZSpJjU--m3mW41p-78IImA=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/index-match-combined-f335f7c14de94f27bc0e5c37af3971e0.png)
How to Use the INDEX and MATCH Function in Excel
![LOOKUP function Excel examples](https://www.lifewire.com/thmb/K4mDYja-lGKrChiUcO85ONrK6uQ=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/lookup-function-example-e52c32a8ff5e41b49af6cf2e5ff34f38.png)
How to Use the LOOKUP Function in Excel
![VLOOKUP Excel function examples](https://www.lifewire.com/thmb/v2j_iH0qOh_UL1iWLKR_A1UBbMY=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/vlookup-excel-examples-19fed9b244494950bae33e044a30370b.png)
How to Use the VLOOKUP Function in Excel
![IF function examples in Excel](https://www.lifewire.com/thmb/XQjndgXA-UMIk6Nlb50XZlCGIhI=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/if-function-examples-30b57ba8a8004a49ae13203f1d40a76b.png)
How to Use the IF Function in Excel
![DATEVALUE Excel function examples](https://www.lifewire.com/thmb/85qjcXKQRqzbc2hBJG3qtereq0M=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/datevalue-excel-examples-bcf1d9c7d32349199da55a0aebd02236.png)
How to Use the Excel DATEVALUE Function
![Excel FIND function examples](https://www.lifewire.com/thmb/QgzzyAYwXleaMv0V69e4gA0cFw8=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/excel-find-function-examples-31f501d19ef84d7faa9a651eab500e5e.png)
How to Use the Excel FIND Function
![A PC on a desk displaying Excel.](https://www.lifewire.com/thmb/_nAxP1nmak8M-2vC4kimILTvPJQ=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/PConwhitedesk-a54058c0fe054b60ab61920e39641f5b.jpg)
How to Use the Indirect Function in Excel
![Charts Graphs spreadsheet paper](https://www.lifewire.com/thmb/hKb5VQB9nqGC8zOCgTNaL690SZk=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/GettyImages-1146192032-1541e624d44e4cea9b04cd93b9243bef.jpg)
How to Use the Excel Subtotal Function
![COUNTIFS Function in Excel](https://www.lifewire.com/thmb/rydIV11slxxEe9Gd2lUpbCzGosU=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/countifs03-8e3481f03ba34868aacfec439ad4ce58.jpg)
How to Use the COUNTIFS Function in Excel
![COUNTIF Function in Excel](https://www.lifewire.com/thmb/GeLhlMG3EeTg9q7BLxFXPMEZFks=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/countif01-7ae29fe96ed042658a4cc01e00c5b171.jpg)
How to Use the COUNTIF Function in Excel
![A red and green rope knotted together.](https://www.lifewire.com/thmb/sKvaKZRL023575o-ugWpsQdsHmU=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/GettyImages-944712288-5bd0d54bc9e77c00518377c7.jpg)
How to use the Excel CONCATENATE Function to Combine Cells
![Calendar with date circled in red](https://www.lifewire.com/thmb/IpbQJew5A7ykZ0DUVSnMTshpE0k=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/calendar-date-87322096-5bdb18db46e0fb002d667479-9e108be6f1b44641a349cb1203119dc7.jpg)
How to Use the TODAY Function in Excel
![Formula Examples in Excel](https://www.lifewire.com/thmb/yjS8tDqHHNaNs3xVghGkTFxjWjY=/400x300/filters:no_upscale():max_bytes(150000):strip_icc()/excel-formulas-examples-571b87563df78c5640fff4be.jpg)
What Are Formulas in Excel and How Do I Use Them?