How-to guides and tutorials to help you perform specific tasks and use the Microsoft Excel spreadsheet application.
Force quit a frozen Excel on Windows with Task Manager, Alt+F4 or taskkill, recover unsaved work with AutoRecover, and stop Excel from freezing again. Continue Reading How to Force Quit Excel on Windows (and Recover Your Work)
Type ñ on a laptop without a number pad: use Windows + period, Insert Symbol or =CHAR(241) in Excel, AutoCorrect, the touch keyboard or US-International. Continue Reading How to Type Ñ on a Laptop in Windows 10 and Excel (8 Ways)
Change Excel from lakhs to millions by setting Windows digit grouping to 123,456,789, use custom number formats, or convert lakh values with a formula. Continue Reading How to Change Lakhs to Millions in Excel on Windows 10
Switch Excel dates to dd/mm/yyyy with Ctrl + 1 > Date and a day-first locale or a custom format. Convert text dates first with Text to Columns. Continue Reading How to Change Excel Dates From mm/dd/yyyy to dd/mm/yyyy
Update Excel on Windows 10: File > Account > Update Options > Update Now. Plus Microsoft Store, Windows Update and repair options. Continue Reading How to Update Excel on Windows 10
Remove a drop-down list in Excel by selecting the cells and choosing Data, Data Validation, Clear All. Your cell values stay in place. Continue Reading How to Remove a Drop-Down List in Excel on Windows 10
Find out why an Excel file opens read-only and fix it: Enable Editing, Read-only recommended, file properties, locks, and sheet protection. Continue Reading How to Remove Read-Only From an Excel File
Count a word in Excel with COUNTIF for matching cells, wildcards for partial matches, and LEN and SUBSTITUTE to count every occurrence. Continue Reading How to Count a Word in Excel (COUNTIF and More)
Search for a word in Excel with Ctrl + F and Find All, search the whole workbook, use wildcards, replace text, filter rows or use SEARCH in formulas. Continue Reading How to Search for a Word in Excel (Find, Filter and Formulas)
Count a word in Excel with COUNTIF for exact or partial matches, or SUMPRODUCT to count every occurrence, including repeats in one cell. Continue Reading How to Count How Many Times a Word Appears in Excel
Enable macros in Excel on Windows 11 with Enable Content, Trust Center macro settings, unblocking downloaded files, or trusted locations, and stay safe. Continue Reading How to Enable Macros in Excel on Windows 11: A Step-by-Step Guide
Learn how to fix “This Value Doesn’t Match” errors in Excel with our step-by-step solutions for data validation issues. Continue Reading Fixing Data Validation Errors in Excel: ‘This Value Doesn’t Match’ Solutions
Learn the quick and easy way to access the Format Cells dialog box launcher in Excel and take control of your spreadsheet formatting. Continue Reading Navigating Excel: How to Access the Format Cells Dialog Box Launcher
Improve your Excel workflow by removing temporary views. Follow these easy steps to declutter your spreadsheet and increase efficiency. Continue Reading How to Remove Temporary Views in Excel for a Better Workflow
Learn how to easily select multiple items from a dropdown list in Excel with our step-by-step guide. Save time and boost productivity! Continue Reading How to Select Multiple Items from a Dropdown List in Excel
Make a line graph in Excel from your data with Insert > Line Chart, add titles and multiple lines, and fix common problems like years plotted as data. Continue Reading How to Make a Line Graph in Excel
Master the art of creating an S Curve in Excel with our easy-to-follow guide. Learn to visualize project progress with this essential tool. Continue Reading How to Create an S Curve Excel: A Step-by-Step Guide
Struggling to remove unwanted buttons in Excel? Follow our step-by-step guide to declutter your spreadsheet with ease. Continue Reading How to Delete a Button in Excel: A Step-by-Step Guide
Learn how to format Excel cells like a pro with our step-by-step guide. From text alignment to number formatting, we’ve got you covered. Continue Reading How to Format Excel Cells: A Step-by-Step Guide
Select the cell and press Ctrl + 5, or use Ctrl + 1 > Font > Strikethrough. How to cross out part of a cell, add a button, and auto-strike done tasks. Continue Reading How to Apply Strikethrough to a Cell in Excel 2013
Setting a date and time in Microsoft Excel can be accomplished by entering the date or time into a cell and then formatting the cell… Continue Reading How to Set a Date and Time in Microsoft Excel: A Step-by-Step Guide
Turn on Excel’s Solver add-in, set the objective, variable cells and constraints, pick a solving method, and read the reports, with a full example. Continue Reading How to Use Solver in Excel (With a Worked Example)
Switch Excel ruler units to centimeters in File > Options > Advanced > Display, and view the ruler in Page Layout view. Continue Reading How to Change the Excel Ruler From Inches to Centimeters
Expand all rows in Excel for Office 365: open grouped rows with outline numbers, unhide hidden rows, AutoFit row height, and clear filters. Continue Reading How to Expand All Rows in Excel for Office 365
Excel’s Office Clipboard can hold multiple copied items, while the normal Windows clipboard typically supplies the most recent item to Paste. If copied-cell outlines or… Continue Reading How to Clear the Clipboard in Excel for Office 365
The first time you try and print a large spreadsheet in Microsoft Excel, there’s a good chance that something will go wrong. There won’t be… Continue Reading How to Prevent Extra Pages from Printing in Excel 2010
When you have information in a spreadsheet that you want to use in a document or a slideshow, then you might just copy and paste… Continue Reading How to Copy as a Picture in Excel 2013
While many page numbering tasks will only involve one document, you might be combining your spreadsheet with something else for a project. This could mean… Continue Reading How to Change the First Page Number in Excel 2013
Stop Excel 2013 turning addresses into links: File, Options, Proofing, AutoCorrect Options, AutoFormat As You Type, uncheck the hyperlink option. Continue Reading How to Disable Automatic Hyperlinks in Excel 2013
Microsoft Excel will show you some of the files that you have been working on recently when you click the File tab at the top-left… Continue Reading How to Stop Showing Recent Documents in Excel 2013
Excel 2011 for Mac is a legacy Office release. It included a preference that controlled how many recently opened workbooks appeared in the File menu,… Continue Reading How to Change the Number of Recent Documents in Excel 2011
Looking at the formulas you type into a Microsoft Excel spreadsheet can help you troubleshoot issues that might arise if the formula isn’t working or… Continue Reading How to Hide Formulas in Excel 2013
Fix Excel showing formulas instead of results: turn off Show Formulas, change Text cells to General, remove leading spaces, and set calculation to Automatic. Continue Reading Why Is Excel Showing Formulas Instead of Results?
Show a formula result in an Excel 2013 text box: put the formula in a cell, select the text box border, and type = plus the cell address. Continue Reading How to Display a Formula Result in a Text Box in Excel 2013
Excel 2013 can hide the horizontal and vertical scroll bars for an individual workbook. This can create a cleaner worksheet view, but it also removes… Continue Reading How to Hide Scroll Bar Excel 2013 Guide
Find the formula bar in Excel, show or hide it from the View tab on Windows, Mac, and the web, expand it for long formulas, and fix a missing formula bar. Continue Reading Where Is the Formula Bar in Excel? (Show, Hide, Expand)
Add a hyperlink to a picture in Excel with Ctrl+K: link to a web page, another sheet, a file or an email, add a ScreenTip, and edit or remove the link. Continue Reading How to Add a Hyperlink to a Picture in Excel
Make text uppercase in Excel 2013 and later with the UPPER function or Flash Fill, replace the original text, and use LOWER and PROPER. Continue Reading How to Make Text Uppercase in Excel 2013
Delete a text box in Excel 2013 by selecting its border, remove several or all objects at once, and use the Selection Pane for hidden boxes. Continue Reading How to Delete a Text Box in Excel 2013 (and Newer)
Remove the fill color from an Excel 2013 text box: select its border, open Format, Shape Fill and choose No Fill. Remove the outline too if needed. Continue Reading How to Remove Fill Color From a Text Box in Excel 2013
Print a title on every page in Excel 2013 with Print Titles and Rows to repeat at top, or add it to the header, plus fixes when Print Titles is grayed out. Continue Reading How to Include a Title at the Top of Every Page in Excel 2013
Hide rows and columns in Excel 2013 with right-click, the Format menu, or Ctrl + 9 and Ctrl + 0, unhide them again, and hide individual cell contents. Continue Reading How to Hide Rows and Columns in Excel 2013
Save an Excel chart as an image with Save as Picture on Windows or Mac, choose PNG, JPG, or SVG, and use copy-paste or screenshots in Excel for the web. Continue Reading How to Save an Excel Chart as an Image (PNG, JPG, or SVG)
Print the top row on every page in Excel 2016 with Page Layout > Print Titles, repeat columns on the left, and fix a grayed-out Print Titles button. Continue Reading How to Print the Top Row on Every Page in Excel 2016
Remove all page breaks in Excel with Reset All Page Breaks, delete single breaks in Page Break Preview, hide dotted lines, and control breaks with scaling. Continue Reading How to Remove All Page Breaks in Excel 2013 (and Newer)
Go to Page Layout, open Page Setup, and on the Margins tab check Horizontally and Vertically under Center on page. How to preview and apply to many sheets. Continue Reading How to Center a Worksheet Horizontally and Vertically in Excel 2010
Print Excel 2013 sheets cleanly: set a print area, use landscape and narrow margins, scale to fit, repeat headers, and preview. Checklist and fixes. Continue Reading The Complete Guide to Printing in Excel 2013
Fill cells with color in Excel 2013 using the Fill Color button, Format Cells, or conditional formatting, and remove shading with No Fill. Continue Reading How to Fill a Cell With Color in Excel 2013
Excel’s Live Preview shows how certain formatting choices will look when you point to them before you actually apply the change. If you find the… Continue Reading How to Disable Excel Live Preview
Print only part of an Excel spreadsheet with Print Selection or a saved print area, print separate ranges, and fit the selection on one page. Continue Reading How to Print Part of a Spreadsheet in Excel