![how to do strikethrough in excel 2010 how to do strikethrough in excel 2010](https://www.lifewire.com/thmb/fUo-lIhAxgSPTXXf95Cg0Ycxi6k=/3500x1969/smart/filters:no_upscale()/strikethrough-in-excel-e8c6e825243648f8bb836783acffc2b9.jpg)
This article is a guide to Formatting in Excel. This way, it can help them view what is most important on the page and where they should begin. Readers may quickly scan the column and row headings to get a sense of how the information on the worksheet is organized. Next, we should enlarge the column and row heads and put them in a second color. While data formatting in Excel, we must make the title stand out, good and bold, it ensures it conveys the content we are showing.
![how to do strikethrough in excel 2010 how to do strikethrough in excel 2010](https://4.bp.blogspot.com/-BAdQDqzh1GU/VxNHtTpHRHI/AAAAAAAARnQ/CCrYod8z7kA8CfT73eqIPGPJ8oktmRutQCLcB/s320/How%2BTo%2BDo%2BA%2BStrikethrough%2BIn%2BExcel%2B%2528Excel%2B2016%2529%2B%2B%25E0%25B8%2581%25E0%25B8%25B2%25E0%25B8%25A3%25E0%25B8%2582%25E0%25B8%25B5%25E0%25B8%2594%25E0%25B8%2586%25E0%25B9%2588%25E0%25B8%25B2%25E0%25B8%2595%25E0%25B8%25B1%25E0%25B8%25A7%25E0%25B8%25AD%25E0%25B8%25B1%25E0%25B8%2581%25E0%25B8%25A9%25E0%25B8%25A3%25E0%25B8%2594%25E0%25B9%2589%25E0%25B8%25A7%25E0%25B8%25A2%2BExcel%2B2016.png)
![how to do strikethrough in excel 2010 how to do strikethrough in excel 2010](https://ik.imagekit.io/ag/wp-content/uploads/2017/07/strikethrough_in_excel_2003_03-185x150.png)
We can also use the “Format” contextual tab for formatting the shape using various commands such as “Shape Outline,” “Shape Fill,” “Text Fill,” “Text Outline,” etc. Then, add the text on the shape by right-clicking on the shapes and choosing “Edit Text.” We must choose an appropriate shape from the “Shapes” command available in the “Illustration” group in the “Insert” tab to insert the shape.Ĭreate the shape according to the requirement and with the same color as the heads of the column. So, we will select the row by “Shift+Spacebar” and then insert two rows by pressing “Ctrl+’+” twice. Set st = Nothing Set st = Rw.Find(What:="*", LookIn:=xlValues, SearchFormat:=True)Īpplication.We will be creating the label for the report by using “Shapes.” To make the shape above the table, we need to add two new rows. Font.Strikethrough = True End With With Sheets("Sheet1") Cells(i, j).Characters(k, 1).Font.Strikethrough ThenīFound = True End If If bFound Then Exit For Next kĭim a As Variant Dim Rw As Range, st As Range
HOW TO DO STRIKETHROUGH IN EXCEL 2010 MANUAL
Seemed slow but I guess still much faster than any manual method!ĭim a As Variant Dim i As Long, j As Long, k As Long, rws As Long, cols As Long
HOW TO DO STRIKETHROUGH IN EXCEL 2010 CODE
My test data for this only had 3 or 4 characters per cell, with a single character somewhere randomly placed in 1 in 10 rows with strikethrough & the code took about 48 seconds to complete. If it may be that only part of a cell is strikethrough, then try the following code.Ī) This requires a lot more checking so will be considerably slower, see my further comments below.ī) The longer the text is in the cells, the slower the code.Ĭ) The earlier a cell is found with strikethrough in the row, the faster the code.ĭ) The earlier any strikethrough is found within a cell's text, the faster the code. Resize(, cols).Copy Destination:=Sheets("Sheet2").Range("A2")Īpplication.ScreenUpdating = True End SubĢ. Columns(cols + 1).SpecialCells(xlConstants, xlNumbers).EntireRow Sort Key1:=.Columns(cols + 1), Order1:=xlAscending, Header:=xlNo, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal Dim a As Variant Dim i As Long, j As Long, rws As Long, cols As LongĪpplication.ScreenUpdating = False With Sheets("Sheet2").UsedRange.Offset(1)