HomeApplicationOffice information

How to cross cells in Excel

You're making a table in Excel and have a blank data cell and you want to cross that box but don't know how to do it. Let TipsMake.com help you through the article How to cross cells in Excel offline!

How to cross cells in Excel Picture 1

Step 1 : You open the Excel file to perform. Select the cell you want to cross out -> Right-click and select Format Cell .

How to cross cells in Excel Picture 2

Step 2 : Then, in the Format Cells window, select to the Border section.

Here you choose how to slash (1) or (2).

Or choose a line style (3).

Then select OK to finish.

How to cross cells in Excel Picture 3

Step 3 : Then to perform the information writing in the cell you use spaces (Space) and press Alt + Enter to enter the line in the cell to align the text accordingly.

How to cross cells in Excel Picture 4

Thank you for following the article. I wish you successful implementation!

4 ★ | 1 Vote

You should read it

May be interested

  • How to merge cells in Excel - Instructions to merge cells in Excel 2010, 2013, 2016How to merge cells in Excel - Instructions to merge cells in Excel 2010, 2013, 2016
    how to merge cells in excel - instructions to merge cells in excel 2010, 2013, 2016. while working with excel, sometimes you want to combine cells together to make the cell larger in size and better suited to the content. than. but you do not know how to combine cells in exc
  • Instructions on how to create diagonal lines in Excel boxInstructions on how to create diagonal lines in Excel box
    manipulating 1 cell into 2 diagonal triangles with a line on excel is a very basic operation and is often performed during the process of creating tables on excel.
  • How to split 1 cell into 2 cells in Excel - Split cells in ExcelHow to split 1 cell into 2 cells in Excel - Split cells in Excel
    how to split 1 cell into 2 cells in excel - split cells in excel. depending on different purposes, you want to split a cell into two cells to enter two different data in one cell and still be able to calculate normally as other cells.
  • How to Sort Cells Alphabetically in ExcelHow to Sort Cells Alphabetically in Excel
    excel is a powerful spreadsheet tool used to store and manage text or figures. alphabetical sorting is one of excel's useful features with the ability to help you sort, access and reference data quickly. to sort cells in excel alphabetically, simply double-click by highlighting the range of cells to sort, then click the 'az sort' or 'za sort' icon in the bar. standard tool. to sort cells alphabetically in excel using the advanced sort option, highlight the entire worksheet, click the 'sort' option from the 'data' menu. , then select the column and order you want to sort in the dialog box that appears.
  • How to merge cells in Excel 2003 2007How to merge cells in Excel 2003 2007
    you have 1 form, and you need to combine several cells into 1 cell in excel to be able to follow that form.
  • How to delete cells in ExcelHow to delete cells in Excel
    do you need to delete a content, format, or just want to delete the comment of a cell in excel? today dexterity software will guide you how to delete cells in excel offline.
  • How to indent the line in ExcelHow to indent the line in Excel
    when you enter data into a spreadsheet, excel automatically aligns with cells containing numbers to the right of the cell, and text input cells are automatically located to the left of the cell.
  • How to combine 2 or more cells in Excel without losing dataHow to combine 2 or more cells in Excel without losing data
    how to combine 2 or more cells in excel without losing data. when merging cells containing data into 1 cell, excel retains the data in the first cell only, data in the remaining cells are deleted. so to retain all data in the cells you need to merge, you cannot use the feature
  • Introducing how to use the CONVERT function in Excel in the most detailIntroducing how to use the CONVERT function in Excel in the most detail
    when working in excel, you may encounter a situation where your spreadsheet has many blank cells and need to fill in values ​​in those cells. don't worry, read the article below which will introduce the convert function in excel to learn how to quickly fill in values ​​into blank cells in excel spreadsheets.
  • How to Alphabetize Cells in ExcelHow to Alphabetize Cells in Excel
    excel is a powerful spreadsheet tool used to store and manage text and numbers, and alphabetizing is one of the many benefits of using excel since it allows you to quickly organize, access, and reference data. to alphabetize cells in excel...

Office information