How-to guides and tutorials to help you perform specific tasks and use the Microsoft Excel 2013 application.
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
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
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
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
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)
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
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)
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
Fill consecutive numbers in Excel 2013 by dragging the fill handle, using Home, Fill, Series, or a ROW formula for numbers that update. Continue Reading How to Fill Cells With Consecutive Numbers in Excel 2013
Format money without a dollar sign in Excel 2013: use Comma Style, or Format Cells > Accounting with Symbol set to None. Plus removing typed $ signs. Continue Reading How to Format Money Without a Dollar Sign in Excel 2013
Print without cell borders in Excel 2013: turn off printed gridlines, remove borders with No Border, clear table styles, and check lines in Print Preview. Continue Reading How to Print Without Cell Borders in Excel 2013
Keep UPC codes at 12 digits in Excel with a custom format of twelve zeros. Stops lost leading zeros and scientific notation. Continue Reading How to Format UPC Codes in Excel
Remove the underline from a link in Excel 2013 with Ctrl+U or by modifying the Hyperlink cell style for all links, change link color, or remove links entirely. Continue Reading How to Remove the Underline From a Link in Excel 2013
Making cell selections in spreadsheet applications like Google Sheets or Microsoft Excel can be as easy as simply clicking on the cell you want. Maybe… Continue Reading How to Select Cells in Excel 2013
Change the default font in Excel 2013 under File, Options, General, then restart Excel. Also covers the Normal style for existing workbooks. Continue Reading How to Change the Default Font in Excel 2013
Set the print area in Excel 2013 from Page Layout > Print Area, add to it, print multiple areas, fit it on one page, and clear it. Continue Reading How to Set the Print Area in Excel 2013
Crop a picture in Excel with the Picture Format tab: trim edges, crop to a circle or aspect ratio, reset a crop and delete cropped areas. Continue Reading How to Crop a Picture in Excel (Shapes, Ratios and More)
Remove strikethrough in Excel with Ctrl + 5 or Format Cells, clear it from part of a cell, and fix strikethrough added by conditional formatting. Continue Reading How to Remove Strikethrough in Excel 2013 (and Newer)
The print settings for an Excel spreadsheet are frequently an afterthought for Excel users, as the focus is on ensuring that the data in the… Continue Reading How to Print Excel Sheet in A4 Size in Excel 2013
Remove percentage formatting in Excel 2013 and later: switch to General, turn 35% into 35 with Paste Special Multiply, and strip % signs stored as text. Continue Reading How to Remove Percentage Formatting in Excel 2013 (and Keep the Number)
Print Excel sheets without column letters and row numbers by unchecking Headings > Print in Page Layout. Works in Excel 2013 through Microsoft 365. Continue Reading How to Print Without Column Letters and Row Numbers in Excel
Not everyone knows every formula in Microsoft Excel, and determining not only the correct formula, but the way to use it, can be difficult. Excel… Continue Reading How to Turn Off Formula AutoComplete in Excel 2013
Print a blank grid in Excel 2013: set a print area over empty cells and tick Gridlines > Print, or add All Borders for darker lines. Continue Reading How to Print an Empty Grid in Excel 2013
Adding a line for signatures to a Microsoft Excel document can be accomplished a couple of different ways. The first option that many will use… Continue Reading How to Add a Signature Line in Excel 2013
Excel shows two decimals because of the cell format, not the stored value. Use Increase Decimal or Format Cells to show more digits. Continue Reading Why Is Excel Only Showing Two Decimal Places?
When you print a large spreadsheet in Microsoft Excel 2013, the default behavior is for the data to print down, then over. This means that… Continue Reading How to Change Page Order in Excel 2013
Keeping track of which data goes in which columns is often a problem for people reading printed Excel spreadsheets. The columns can start to look… Continue Reading How to Print Headings in Excel 2013
Set Page Layout as the default view in Excel 2013: File > Options > General > Default view for new sheets > Page Layout View. Plus switching views. Continue Reading How to Set Page Layout as the Default View in Excel 2013
The row of buttons and tabs at the top of your Excel window is called the ribbon, and it offers an efficient way for you… Continue Reading How to Hide a Tab on the Ribbon in Excel 2013
A file in Microsoft Excel is called a workbook, and that workbook can include a number of different spreadsheets called worksheets. Organizing large amounts of… Continue Reading How to Change the Default Number of Worksheets in an Excel 2013 Workbook
Hiding data in an Excel spreadsheet is a common practice when there is data that isn’t necessary to view, but that you either need for… Continue Reading How to Unhide a Worksheet Tab in Excel 2013
Having very wide or very skinny columns in Excel can make it difficult to work with the rest of the data in your spreadsheet. Whether… Continue Reading How to Make All Columns the Same Width in Excel 2013
Excel 2013’s Split feature divides a worksheet window into independently scrollable panes. If you accidentally create a split or no longer need to compare distant… Continue Reading How to Remove a Split Screen in Excel 2013
Stop Excel 2013 from recalculating formulas automatically: Formulas, Calculation Options, Manual. Press F9 to recalculate when you are ready. Continue Reading How to Disable Formula Updates in Excel 2013
It’s not uncommon for someone to have more than one Web browser on their computer. Windows 7 includes Internet Explorer by default, but you may… Continue Reading How to Set the Default Browser for Excel 2013 Links
Add a gradient fill in Excel 2013: select cells, press Ctrl + 1, go to Fill > Fill Effects, pick two colors and a style. Plus shapes and charts. Continue Reading How to Use a Gradient Fill Effect in Excel 2013
Is there a lot of information that you are trying to include in a cell in your worksheet, and you would like to make sure… Continue Reading How to Elongate a Cell in Excel 2013
Shrink text to fit inside a cell in Excel with Format Cells > Alignment > Shrink to fit, and learn when to use Wrap text or AutoFit instead. Continue Reading How to Shrink Text to Fit Inside a Cell in Excel