How to Apply Strikethrough to a Cell in Excel 2013
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.
excel 2013
How-to guides and tutorials to help you perform specific tasks and use the Microsoft Excel 2013 application.
How to Change the Excel Ruler From Inches to Centimeters
Switch Excel ruler units to centimeters in File > Options > Advanced > Display, and view the ruler in Page Layout view.
How to Copy as a Picture in Excel 2013
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 …
How to Change the First Page Number 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 …
How to Disable Automatic Hyperlinks in Excel 2013
Stop Excel 2013 turning addresses into links: File, Options, Proofing, AutoCorrect Options, AutoFormat As You Type, uncheck the hyperlink option.
How to Stop Showing Recent Documents 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 …
How to Hide Formulas 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 …
How to Display a Formula Result in a Text Box 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.
How to Hide Scroll Bar Excel 2013 Guide
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 …
Where Is the Formula Bar in Excel? (Show, Hide, Expand)
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.
How to Add a Hyperlink to a Picture in Excel
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.
How to Make Text Uppercase in Excel 2013
Make text uppercase in Excel 2013 and later with the UPPER function or Flash Fill, replace the original text, and use LOWER and PROPER.
How to Delete a Text Box in Excel 2013 (and Newer)
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.
How to Include a Title at the Top of Every Page 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.
How to Hide Rows and Columns 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.
How to Remove All Page Breaks in Excel 2013 (and Newer)
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.
The Complete Guide to Printing in Excel 2013
Print Excel 2013 sheets cleanly: set a print area, use landscape and narrow margins, scale to fit, repeat headers, and preview. Checklist and fixes.
How to Fill a Cell With Color 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.
How to Disable Excel Live Preview
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 …
How to Print Part of a Spreadsheet in Excel
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.
How to Fill Cells With Consecutive Numbers in Excel 2013
Fill consecutive numbers in Excel 2013 by dragging the fill handle, using Home, Fill, Series, or a ROW formula for numbers that update.
How to Format Money Without a Dollar Sign 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.
How to Print Without Cell Borders 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.
How to Format UPC Codes in Excel
Keep UPC codes at 12 digits in Excel with a custom format of twelve zeros. Stops lost leading zeros and scientific notation.
How to Remove the Underline From a Link in Excel 2013
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.
How to Select Cells 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 …
How to Change the Default Font 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.
How to Set the Print Area 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.
How to Crop a Picture in Excel (Shapes, Ratios and More)
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.
How to Remove Strikethrough in Excel 2013 (and Newer)
Remove strikethrough in Excel with Ctrl + 5 or Format Cells, clear it from part of a cell, and fix strikethrough added by conditional formatting.
How to Print Excel Sheet in A4 Size in Excel 2013
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 …
How to Remove Percentage Formatting in Excel 2013 (and Keep the Number)
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.
How to Print Without Column Letters and Row Numbers in Excel
Print Excel sheets without column letters and row numbers by unchecking Headings > Print in Page Layout. Works in Excel 2013 through Microsoft 365.
How to Turn Off Formula AutoComplete in Excel 2013
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 …
How to Print an Empty Grid 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.
How to Add a Signature Line 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 …
Why Is Excel Only Showing Two Decimal Places?
Excel shows two decimals because of the cell format, not the stored value. Use Increase Decimal or Format Cells to show more digits.
How to Change Page Order in Excel 2013
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 …
How to Print Headings 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 …
How to Set Page Layout as the Default View 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.
How to Hide a Tab on the Ribbon 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 …
How to Change the Default Number of Worksheets in an Excel 2013 Workbook
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 …
How to Unhide a Worksheet Tab in Excel 2013
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 …
How to Make All Columns the Same Width 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 …
How to Remove a Split Screen 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 …
How to Disable Formula Updates in Excel 2013
Stop Excel 2013 from recalculating formulas automatically: Formulas, Calculation Options, Manual. Press F9 to recalculate when you are ready.
How to Set the Default Browser for Excel 2013 Links
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 …
How to Use a Gradient Fill Effect in Excel 2013
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.
How to Elongate a Cell 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 …
How to Shrink Text to Fit Inside a Cell in Excel
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.