Hi Bob, Thank you for your answer. You are correct that rows and columns cannot be deleted but they can be hidden. My problem was that I wanted to hide rows 12 to 1 million, or however many rows exist beyond 12, and same for the columns. I just wanted to retain a tiny bit of visible data.
In Excel 2003, I have a large file that includes the csv information and 3 pivot tables, all on different tabs. After I revise the csv information (always deleting rows, never adding any) and refresh the pivot tables, there are several (sometimes thousands) blank rows under the pivot table.
Comments tend to moved around, especially if you add/delete rows/columns. Yu can always fix them back to a stand format by a macro. For example: Sub CommentFixer () Dim r As Range, rr As Range Set rr = ActiveSheet.UsedRange.SpecialCells (xlComments) For Each r In rr topp = r.Offset (1, 1).Top leftt = r.Offset (1, 1).Left r.Comment.Shape.Select Selection.ShapeRange.Top = topp Selection ...
Maria Flores1 Created on May 28, 2024 Excel Macro Delete Empty Columns with Header We want to Delete Empty Columns with Header Answer TC Thomas C - MSFT
The free Excel workbook "Professional_Compare" (updated) is available at MediaFire. (compares every cell in two worksheets Or each row in one worksheet against all rows in a second worksheet - choice of compare type) It includes optional "Clean Data" and "Quick Uniques List" utilities.
How do I concatenate all the rows in column one into ONE cell in column two? I'm using a long list of email addresses and need to copy/paste the entire list into a single email. Thanks for any help!
Copying conditional formatting across rows (specifically Excel 2007 Graded Color Scales) I have a column that I've conditionally formatted with Graded Color Scales. I'd like to apply the colors in that particular column across a row (not re-grade each add'l column). Is there any way to do this?
Hallo ich habe das Problem, das ich in Excel eine Auswertung für Spiel 77 von Lotto erstellen möchte.Das Problem ist, das bei Spiel 77 der Gewinn erst mit der letzten Zahl beginnt.Ich habe es schon über MAX versucht und es funktioniert wenn alle Zahlen…
